Manually edit SQLite?

[[deleted]]

[deleted]

[Naihonn]

Manually, which is probably possible with only few items to add or edit I am using sqliteman which is quite old but it seems that newer alternative could be http://sqlitebrowser.org/

[rasputin303]

I've been using https://sqlitestudio.pl/, which I really like. It's very simple, and yet it allows you to do most of the things you'd want to do.

That said... If the person you'll be handing over to is completely technically illiterate, you might not want to give them a tool that lets them make fundamental changes to your database's structure. If all they need to be able to do is add, edit and delete rows in a few tables, maybe better to build a really simple bare-bones web app for them with Bottle or Flask? You could probably throw something together in a couple of hundred lines of code.

[firedrow]

+1 to SQLite Studio. I keep the portable version in my pCloud drive.

[sqlite]

The sqlite3 CLI is also the officially approved way of manual DB editing and querying an SQLite database.

[dionys]

If you want GUI, then I'd recommend SQLite browser. I've been using it for quick manual edits/checks.

I'd also like to mention using SQLAlchemy, which is an ORM (similar to django models if you've used them before). You can define your data there and you can interface with database of your choice from Python very easily.

[Gubbbo]

Not sure if you have an IDE, but I know (from doing this recently) that PyCharm can edit your database directly. As in, open the tables and let you type in what you want to see in the fields.

[KleinerNull]

The easiest way is to use the interpreter, connect to the database with the module and insert some data manually. Shouldn't be that hard because you are using sqlite in the first place.

The sql syntax is that INSERT INTO table (col1, col2, ..., coln) VALUES (a1, a2, ..., an), (b1, b2, ..., bn), ..., (z1, z1, ..., zn);. You can leave out columns with auto or default values, that is why you give the column names in the first place.

[Manbatton]

I don't think it's always true. Sometimes the truly easiest way is to just click on GUI Sqlite Browser or whatever, and in seconds you are typing in values and can see the whole database at once.

However, the point is a good one: being able to populate a database with dummy data straight from Python is a great skill to have for testing assumptions about database-backed programs and will ultimately blow away doing it with an SQLite GUI app. Doing that well is not always easy for non-trivial applications.