Reputation
3,118
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
11 30
Impact
~208k people reached

Feb
2
comment MySQL: Soft Delete post likes
Copy-on-delete to table_history
Jan
31
comment How would you normalize a database that has multiple products to a single transaction ID?
A Sales Order has many Sales Order Line Items. One table for Sales Orders, one for Sales Order Line Items with a foreign key to the former.
Jan
29
answered Unstructured to Structured Data
Jan
23
comment Is there some kind of table-level replication in PostgreSQL?
how about postgresql.org/docs/current/static/postgres-fdw.html to read from the other db? (9.3+ though) . else postgresql.org/docs/9.3/static/dblink.html
Jan
21
comment Database agnostic auditing
Hibernate Envers? This is app layer though
Jan
21
comment PL/pgSQL issues when function used twice (caching problem ?)
What happens if you make it volatile instead of stable?
Jan
19
comment Postgresql Encryption by middleware
css.csail.mit.edu/cryptdb ?
Jan
18
comment should I denormalize for user profiles?
Are you having performance problems? Is the database structure the culprit?
Jan
15
comment Update all rows when sort/ordering value is changed for single row?
see stackoverflow.com/questions/8607998/…
Jan
9
comment Postgres with pgpool architecture
if you're going for high availability, you probably want two pgpool servers in front of at least 2 postgresql servers (all on different boxes)
Dec
18
comment why some one will use approximate data types for sales
Because some people don't know what they are doing
Dec
10
comment need better db design for project
Can you wait a week or 2 for PG 9.5? It has built-in Row Security
Dec
4
comment Multiple inserts across tables with serial primary keys
you can use 'default' in place of 'null': insert into top (top_id, top_name) values (default, 'first_top');
Dec
2
answered Exporting Postgres table to formatted document
Nov
26
comment Need help making a sane database schema
read up on table inheritance, aka subtype/supertype relationships
Nov
25
revised What's the quickest way to periodically export PostgreSQL data to a local file on Windows?
added 9 characters in body
Nov
19
comment Hard dba case [schema to store delivery prices for shops]
1. consider drools for complex business rules. 2. read The Data Model Resource Book vol 1. it covers this exact thing
Nov
19
comment See entire string from a lengthy text field in pgAdmin?
you can also copy and paste the output cell to say notepad to view it. it's a PITA I agree
Nov
18
comment Designing a database where records can reference different foreign keys
Use table inheritance, aka subtype/supertype relationships
Nov
17
comment How to document SQL statements (DDL & DML)?
They're called "columns" in these here parts