Skip to main content
2 votes

Update table with data from another table under certain criteria

Too many unnecessary joins and subqueries. Clean solution: ...
Basil Peace's user avatar
2 votes

Simple Connection Pooling with psycopg2 and PostgreSQL

Your code looks okay, but I would suggest a few things. Don't worry about calling putconn function to put back the connection every time you are managing data in a ...
JustBeingHelpful's user avatar
2 votes
Accepted

PostgreSQL Search Feature

multiple instances of coalesce and jsonb_extract_path_text ... somewhat cluttered Meh, whatever. Doesn't trouble me. If you feel strongly about it, you could always fix it with a VIEW. Or consider ...
J_H's user avatar
  • 29.3k
1 vote
Accepted

Find and conditionally sort all venues matching a filter provided by an API client in PostgreSQL

distance Here's a curious column: ...
J_H's user avatar
  • 29.3k
1 vote

Creating single table vs creating multiple table

Often people will choose to store service credentials in a crypted vault and inject them via text file or env vars. But I will just assume that an RDBMS is perfect for your needs. store service [...
J_H's user avatar
  • 29.3k

Only top scored, non community-wiki answers of a minimum length are eligible