4 ms·
Is there a good source for the queries run on different data base types (MySql, Postgres) to reflect it's schema?
by soulnothing 7y ago
Is there a good source for the queries run on different data base types (MySql, Postgres) to reflect it's schema?
- mvc 7y agoThe information schema is part of the SQL standard so the queries should be the same in all the databases that support that (which is quite a few). Here's the doc links for MySQL and PostgreSQL https://dev.mysql.com/doc/refman/8.0/en/information-schema.html https://dev.mysql.com/doc/refman/8.0/en/information-schema.h... https://www.postgresql.org/docs/12/information-schema.html https://www.postgresql.org/docs/12/information-schema.html As it happens, I did a talk about this at re:Clojure this week. Videos aren't up yet but they will appear here when they are available https://www.youtube.com/channel/UCbZW8yCqEncYciie8_1yy7w/featured https://www.youtube.com/channel/UCbZW8yCqEncYciie8_1yy7w/fea...
- pmart123 7y agoOne way I found helpful was to look at ORM libraries like sqlalchemy to see how they queried each db to translate schemas into objects.