452 reputation
311
bio website manavgoel.net
location India
age
visits member for 2 years, 10 months
seen Mar 21 at 6:05

I am a freelance developer with specialisation in python web application.


Jul
2
awarded  Curious
Dec
22
awarded  Popular Question
Sep
13
awarded  Yearling
May
22
comment Usage of foreign key when the referenced table data will not change
Thanks for the answer. What are these option1 and 2 tables?
May
22
asked Usage of foreign key when the referenced table data will not change
May
16
awarded  Notable Question
Dec
9
accepted Postgres Backup queries on AWS after reading Postgres docs
Dec
3
comment Many To Many Relationships
Agreed, it depends on the use case. I just mentioned it so that op gets a clear picture of this type of relationship. :)
Dec
3
comment Many To Many Relationships
Also both the foreign keys should be part of primary key so that no record gets duplicated and it also helps performance when getting data back.
Dec
3
comment Postgres Backup queries on AWS after reading Postgres docs
Regarding pg_start_backup command, I should issue it then take snapshot and then issue pg_stop_backup. Right?
Dec
2
accepted Database design with different user roles connected by different relationships to one organizaiton table
Dec
2
asked Postgres Backup queries on AWS after reading Postgres docs
Nov
19
comment Moving postgresql data to different drive
Thanks. To change directory I just needed to run postgres -D /location after following steps mentioned by you. :)
Nov
19
accepted Moving postgresql data to different drive
Nov
19
awarded  Commentator
Nov
19
comment Moving postgresql data to different drive
In 4th point, what do you mean by 'This is usually defined through a commandline parameter...'?
Nov
19
asked Moving postgresql data to different drive
Nov
8
awarded  Popular Question
Oct
23
comment Database design with different user roles connected by different relationships to one organizaiton table
I also thought of the same schema which you have mentioned initially. It seems it is the best way. What I am thinking is make Primary_key(user_id, organization_id, employee_type_id). I have to keep a check in application code if an user is already fulltimeemployee then he cannot be connected to any other company.
Oct
22
asked Database design with different user roles connected by different relationships to one organizaiton table