-
[postgres] postgres ecosystem 이해📚 데이터베이스 2023. 2. 9. 10:11
How to run /connect postgres server
1) psql
2) pgAdmin
https://www.freecodecamp.org/news/how-to-get-started-with-postgresql-9d3bc1dd1b11/
How to get started with PostgreSQL
by Akul Tomar How to get started with PostgreSQL PostgreSQL is an open source Relational Database Management System (RDBMS). In this article, I’ll provide an introduction to getting started with PostgreSQL. Here is what we’ll cover: * Installation [htt
www.freecodecamp.org
https://www.geeksforgeeks.org/postgresql-connect-and-access-a-database/
Data importing
https://arctype.com/blog/import-data-postgres/
Three ways to import data into Postgres
If you're working with Postgres, you might need a way to get your data into your database. Here's approaches you can use.
arctype.com
1) use COPY to import csv file
2) restore .tar backup file
using with python
1) integrate in python script with sqlalchemy
https://towardsdatascience.com/sqlalchemy-python-tutorial-79a577141a91SQLAlchemy — Python Tutorial
We often encounter data as Relational Databases. To work with them we generally would need to write raw SQL queries, pass them to the…
towardsdatascience.com
https://www.learndatasci.com/tutorials/using-databases-python-postgres-sqlalchemy-and-alembic/
Beginner's Guide to Using Databases with Python: Postgres, SQLAlchemy, and Alembic
SQLAlchemy is very commonly used with Flask applications, and is usually accessed through the flask-sqlalchemy library. Here, we'll be interacting with the sqlalchemy library directly, so if you're used to Flask, there's a few things that are a little diff
www.learndatasci.com
https://www.geeksforgeeks.org/postgresql-connecting-to-the-database-using-python/?ref=rp
PostgreSQL - Connecting to the database using Python - GeeksforGeeks
A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.
www.geeksforgeeks.org
2) use %%sql in jupyter lab
https://levelup.gitconnected.com/how-to-run-sql-queries-in-jupyter-lab-1cbb1e3b1c04
How to Run SQL queries in Jupyter Lab
In this small article I will illustrate how to write sql queries in jupyter lab, perform data manipulations as well as visualizations.
levelup.gitconnected.com