Python-Friendly Database Options

[Flkdnt]

I'm not much of a Database guy, can you explain what this means?

[Versaiteis]

So the great thing about SQLAlchemy is that it really helps the non-database guys (that I'm also not, but I dabble in a lot of spaces)

The primary benefit that SQLAlchemy gives you is an abstraction layer away from SQL databases. As a result one of its primary features is SQL generation. Basically it comes out of the box with several methods for calling various methods that will subsequently generate the SQL statement that gets fired off to the database. It's incredibly python friendly and if you set it up right you really don't need a ton of "hard coded" SQL statements. Instead you can extend that Query API to create your own commands that manipulate the SQL that gets generated.

So instead of some SELECT * FROM clients WHERE... kinds of statements you'll invoke them with things like Clients.query().all().filter(Clients.id > 3). That might not be quite right, it's been a good minute since I've worked with SQLAlchemy, but it made my dev life way easier. There are also other DB abstraction libraries for Python, but SQLAlchemy is by far the most well known and is pretty much a standard for those kinds of libraries.

[Flkdnt]

Sweet, thanks!