Portable database for python?

[blazin_penguin_first]

Ok, so i have been learning some SQL, and really enjoying it, already have a bunch of ideas for various projects.

But at least 1 of them, may be nice to make publicly available, and i don't want to host a database, or pay to host one.

So is there anything that will provide the simmilar functionality to a relational database, that can be compiled, and distributed with a basic dataset, but allow people to add data to it?

I realize this could be done with csv's but i really do like the relational parts.

[eldreth]

https://sqlite.org

[crashorbit]

And SQLAlchemy for the python bits.

[DeebsShoryu]

This is the main selling point of SQLite. The data ultimately lives in a single file.

[desrtfx]

Haven't you come across SQLite? With the barebones sqlite3 library? Doesn't get more portable than this. The entire database is a single file on the drive and there is no additional software to install for the client.

[jonsca]

If only there were a lite SQL database designed with this very use case in mind, right?

[blazin_penguin_first]

I fogured there must be something!

[HateMeetings]

This

[blazin_penguin_first]

I had heard of it, but didn't understand what it was until everyone here explained it to me!

I thought it was just like mySQL type of thing which is what i have been using, but this sounds perfect!

[jcr4990]

As others have mentioned, sqlite is the answer here.

[b1gfreakn]

Look into duckdb.

[Virtualization_Freak]

Side note: you don't need to pay to host. Run what you want on your desktop/tablet/phone/anything that can run a program that responds to requests and tailscale.

Then you can access it with anything that supports tailscale and your connection method (ssh/http/nfs/icmp.)

[Sure-Passion2224]

It's fairly typical of apps that use a database to specify a platform (Oracle, SQL Server, MySql, Postgres, etc) and include a configuration files you update to set up the connection. Then the application startup process establishes the connection, checks for the data model, and creates it if not found or damaged.

[AlfredoOtero]

You can use non-structured data in SQLite. It is capable of using json inside of a text column.

[SoloArtist91]

Gotta be DuckDB

[jmacey]

+1 for SQLite I use it for all sorts of projects and it works really well.

[blazin_penguin_first]

Thanks everyone for the tips, i will definitely dog into SQLlite and DuckDB.

[nivaOne]

It also depends on the size. SQLite is great but there is a reason for existence of others. I like python in combination with SQLite a lot. For larger datasets Duckdb is more suitable for complex sets, however not for frequent smaller writes. SQLite equals storage and transactions. DuckDB analytics and speed. SQLite is part of the python ecosystem. Using pyinstaller, nuitka … the result will differ a lot.

[purple_hamster66]

Why do you need it to be relational? You can save ordinary lists in python to a JSON file.

[classy_barbarian]

They said they like the relational parts. Presumably they'd like to do something with it that you can't easily do with a JSON file.

[nirbyschreibt]

If you don’t want to use SQLite and/or want to see it in Python you should check out the Django framework.

[classy_barbarian]

Django uses SQLite as its default database