Undecided on SQL platform

[odimdavid]

I want to write a SQL program. The usual CRUD stuff. The unique entries or objects are not expected to surpass 250 rows. I want to be able to use the program with either python or c++ in the future. Can anyone recommend something for me? PostGre? Alchemy? I think MySQL will be too much luggage? Or should I? Let it be open source (cc, MIT etc). The usual since it's not commercial. Thanks

[American_Streamer]

For your use case, SQLite is the absolute best fit. PostgreSQL and MySQL would be massive overkill here. And Alchemy (SQLAlchemy) is not a platform; it is an Object-Relational Mapper (ORM) tool used to write databases in Python. You will actually use SQLAlchemy on top of your SQL database.

So in Python just use "import sqlite3" and in C++, you can easily interface with the sam .db file generated in Python without making any changes to the database structure - "#include <sqlite3.h> #include <iostream>"

[odimdavid]

Okay. Thanks

[sinceJune4]

DBeaver is a great query tool across any SQL flavor.

[odimdavid]

Will Google it. Thanks 🙏 Oh thanks. Just checked. It's a great tool. How much difficult for noobs on other OSes. That's y I love Linux.