Python Database

[Wictorian]

What is the best option for setting up a database in python? I have tried just writing to .txt files and using pickle but having to rewrite the whole file to make edits is annoying to me, is there an option that enables regular editing?

[Kilrah]

sqlite? https://docs.python.org/3/library/sqlite3.html

[SydneyBrokeIt]

sqlite would be a good choice here - it's pretty much what it was designed for.  The fact that a lot of tooling exists to touch it outside Python is a bonus.

[Eigenvektor]

Why reinvent the wheel? If you need a database, use an actual database (SQLite, MariaDB) and the appropriate client libs instead of implementing your own.

[SydneyBrokeIt]

19 hours ago, Eigenvektor said:

Why reinvent the wheel? If you need a database, use an actual database (SQLite, MariaDB) and the appropriate client libs instead of implementing your own.

This is just plain good advice for programming in general.

 

99% of all programming problems have already been solved, better, by someone else.  Use it.  Especially for encryption.  Unless you know exactly why you're rolling your own encryption, you have no business rolling your own encryption.

[Wictorian]

7 hours ago, SydneyBrokeIt said:

This is just plain good advice for programming in general.

 

99% of all programming problems have already been solved, better, by someone else.  Use it.  Especially for encryption.  Unless you know exactly why you're rolling your own encryption, you have no business rolling your own encryption.

A bit random but good advice about encryption nonetheless. I had implemented my encryption because I had thought it would be easier. I won't use encryption  this time at all though.

[Wictorian]

On 3/12/2022 at 12:19 AM, Kilrah said:

sqlite? https://docs.python.org/3/library/sqlite3.html

can I use it to store large chunks of data?

[Kilrah]

Yes, although in most cases "large chunks of data" don't really belong in a database... context is missing to give more advice though.

[t0int]

You can try Redis

[SydneyBrokeIt]

3 hours ago, t0int said:

You can try Redis

This is very dependent on your needs, and Redis generally isn't what I would recommend as a database if you have any sort of complicated structures.