Why not just do this instead? USE master; Go SELECT ‘DROP DATABASE [‘+ name + ‘]’ FROM sys.databases WHERE name like ‘_database_name_%’; GO Capture the output of that resultset and then paste it into another query window. Then run that. Why write all this TSQL cursor code? “When you have a hammer, everything looks like … Read more
ProfaneDB: http://profanedb.gitlab.io “ProfaneDB is a gRPC interface between Protocol Buffers and RocksDB” P.S: Though the question was asked 10 years ago I still find it very relevant, specially with the ascension of gRPC. Hope that can be of help.
pgModeler looks promising: http://pgmodeler.com.br
If the charset of the tables is the same as it’s content try to use mysql_set_charset(‘UTF8’, $link_identifier). Note that MySQL uses UTF8 to specify the UTF-8 encoding instead of UTF-8 which is more common. Check my other answer on a similar question too.
I agree with everything Oded said except “It can’t reasonably be used as a foreign key either.” In this case it’s a pick your poison, the mapping table absolutely can be a parent, it’s just a matter of the child using a multicolumn FK or not. Take a simple case of Car and color. Each … Read more
You are correct that storing passwords in plaintext and in a settings.py file is not good security. You could increase security by: Setting the permissions correctly (this will depend on your set up). Ideally only python should be able to read the file. Storing the file out of the www or htdocs root. If at … Read more
It turns out there’s a very simple, pragmatic solution to this: alembic upgrade <target-revision> || alembic downgrade <target-revision>
I’ve recently discovered DBeaver. It automatically detects relations between tables in a visual manner. You can move tables around, change colors, see foreign keys, etc. It’s extremely good. Fully compatible with PostgreSQL Querying and manipulating data using the GUI is extremely easy. Not only that you can use it with all major SQL and noSQL … Read more