Tech C**P
14 subscribers
161 photos
9 videos
59 files
304 links
مدرس و برنامه نویس پایتون و لینوکس @alirezastack
Download Telegram
You may have used 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
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