All Questions
Tagged with postgresql beginner
7 questions
3
votes
0
answers
146
views
Updating user information in SQL
Newbie here. I have this gqlgen api with sqlc update code, which updates the user by given id with provided fields:
...
- 131
6
votes
2
answers
342
views
Update SQL database, similar-but-different queries for each month
This snippet works and does as desired, but I just wonder if I am being too repetitive.
What I mean by this is, eventually I will have all 12 months in there.
So.... 12 Update Queries, 12 Commands, ...
- 163
4
votes
1
answer
163
views
Flask Database Model Design
I am developing my first website in Flask using PostgreSQL and I want my database to have professors from all universities and courses in the USA.
As I am not very familiar with databases I have ...
- 265
6
votes
1
answer
140
views
HackerNews news fetcher
The following code is part of a big application. I am new to Go, and appreciate feedback on the best practices and improvements. Please consider styling and comments as well.
Every 30 minutes, this ...
- 802
1
vote
2
answers
273
views
Argument parser for a PostgreSQL backup utility
I'm sure it's still not yet perfect and tips will be greatly appreciated!
I just re-read the script and I realised I'm not handling exceptions! The script is unfinished but I'm looking for WIP (work ...
- 211
8
votes
3
answers
4k
views
MySQL-to-PostgreSQL migration script
I'm working on a Python script to migrate a MySQL database into a PostgreSQL database with a different Schema (different table structures, different datatypes and so on).
I'm a sysadmin and ...
- 145
6
votes
4
answers
462
views
Using PostgreSQL effectively with a banking app
I'm kind of newbie for these things but I did something and I want to know how I can do this effectively.
...
- 183