All Questions
Tagged with postgresql database
16 questions
5
votes
2
answers
699
views
A schema for awallet system that allows transfers between users
I am currently working on a wallet system that allows transfers of money between users. I tried creating this as a Stack Overflow question, but it was rejected. I'm not sure if this is the right ...
- 163
4
votes
1
answer
223
views
Postgres DB design
I need to develop a database to handle muting people in an online community. The DB needs to keep track of the currently muted people. When somebody gets unmuted, that entry gets moved to an archive ...
4
votes
2
answers
179
views
Historical database design for school system
Context
We are a multi-academy trust designing a database system (more of a warehousing solution) to aggregate educational data from our 13 schools into a single source.
The data will be mostly ...
- 223
1
vote
2
answers
87
views
Querying and rendering an HTML table of ISP performance statistics
I have multiples measurements and I want to render it into tables like this
Measurements
Operator
browsings
FTP DL
FTP UL
Location
Event
Date
Operator
avg
min
max
avg
min
max
avg
min
max
Verizon
...
- 107
2
votes
0
answers
44
views
Handling failures in DB transactions
This code is meant to retry the db operation when a DB connection breaks: OperationalError.
A transaction can fail for example when a db is being restarted and a commit fails. Or when a network error ...
- 121
0
votes
1
answer
598
views
Filtering DbContext data dynamically by user input in WPF applications
I need to filter database data based on filters available to the end user in the form of search term text box, select boxes etc.
I have put together this code and need feedback if this is a good way ...
- 103
2
votes
4
answers
9k
views
Correct using of try/catch clause on database execution
When a statement to a DB returns null, I am catching it this way:
...
2
votes
1
answer
128
views
Exporting documents from PostgreSQL into a second database
This is my first try with a database. I read some articles/books and now i tried it myself and I want to know if I can write it better or what are my mistakes. All in all I am using try/catch/finally, ...
1
vote
1
answer
45
views
Combination aggregate/greatest-n-per-group SQL query on simplified data set
I've been reading the top 'greatest-n-per-group' answers on StackOverflow but haven't yet found any answers that fit my specific case.
The following code works, but it seems overly-complicated for ...
- 429
3
votes
1
answer
48
views
Creating a join table entry by looking up name
I wrote a stored procedure that allows a join entity to be created by name for my fictional characters database. I would like some feedback on it with regard to exception handling, and conditions I ...
- 915
5
votes
1
answer
8k
views
Importing database of 4 million rows into Pandas DataFrame
I am using the following code to import database table into a DataFrame:
...
- 105
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
5
votes
1
answer
7k
views
Database design for school attendance and scheduling
I work at a small English school in Japan and I'm trying to create a database to handle student attendance and class scheduling. I'm using PostgreSQL for the database and I'll use PHP for interacting ...
- 51
5
votes
1
answer
222
views
Gathering distinct patient diagnosis records
This code correctly gathers diagnosis records for a patient to show distinct records based on the AMA ICD9 code, diagnosis description, and date of posting. The output is distinct on (ICD code, ...
- 223
3
votes
0
answers
398
views
C++ PostgreSQL database driver wrapper
I am writing my own wrapper for PostgreSQL (but it can be used for other engines too).
I am using this desgin:
...
- 193