How to serialize SqlAlchemy result to JSON?
Django has some good automatic serialization of ORM models returned from DB to JSON format.
sqlalchemy
Writing a connection string when password contains special characters
I’m using SQLalchemy for a Python project, and I want to have a tidy connection string to access my database. So for example:
How to execute raw SQL in Flask-SQLAlchemy app
How do you execute raw SQL in SQLAlchemy?
Does SQLAlchemy have an equivalent of Django’s get_or_create?
I want to get an object from the database if it already exists (based on provided parameters) or create it if it does not.
Difference between filter and filter_by in SQLAlchemy
Could anyone explain the difference between filter and filter_by functions in SQLAlchemy?
Which one should I be using?
How to write DataFrame to postgres table
There is DataFrame.to_sql method, but it works only for mysql, sqlite and oracle databases. I cant pass to this method postgres connection or sqlalchemy engine.
Sqlite / SQLAlchemy: how to enforce Foreign Keys?
The new version of SQLite has the ability to enforce Foreign Key constraints, but for the sake of backwards-compatibility, you have to turn it on for each database connection separately!
jsonify a SQLAlchemy result set in Flask
marshmallow is an ORM/ODM/framework-agnostic library for converting
complex datatypes, such as objects, to and from native Python
datatypes.
Speeding up pandas.DataFrame.to_sql with fast_executemany of pyODBC
I would like to send a large pandas.DataFrame to a remote server running MS SQL. The way I do it now is by converting a data_frame object to a list of tuples and then send it away with pyODBC’s executemany() function. It goes something like this:
SQLAlchemy: print the actual query
I’d really like to be able to print out valid SQL for my application, including values, rather than bind parameters, but it’s not obvious how to do this in SQLAlchemy (by design, I’m fairly sure).