You may have used
If you want to query, create table, create partition and all the different operations on a database you can do now by using the below site without ever making a big mistake on your system:
https://www.db-fiddle.com/
#mysql #postgresql #database #fiddle #dbfiddle
JSFiddle
to interactively write JS code and get instant result. It is good to note that there is one for Database (MySQL, PostgreSQL, SQLite)!If you want to query, create table, create partition and all the different operations on a database you can do now by using the below site without ever making a big mistake on your system:
https://www.db-fiddle.com/
#mysql #postgresql #database #fiddle #dbfiddle
Db-Fiddle
DB Fiddle - SQL Database Playground
An online SQL database playground for testing, debugging and sharing SQL snippets.
One of the issues you always face with postgres on new systems is pg_config error. If you don't want to install postgres and willing to have postgres library in Pytho operational:
1. brew install libpq
2. xcode-select --install
3. echo 'export PATH="/usr/local/opt/libpq/bin:$PATH"' >> ~/.zshrc
4. env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip3 install psycopg2
#osx #libpq #pg_config #postgres #postgresql #xcode
1. brew install libpq
2. xcode-select --install
3. echo 'export PATH="/usr/local/opt/libpq/bin:$PATH"' >> ~/.zshrc
4. env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip3 install psycopg2
#osx #libpq #pg_config #postgres #postgresql #xcode