Reputation
4,321
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
5 14 29
Newest
 Nice Answer
Impact
~223k people reached

1d
comment Postgres 9.4+: JSONB instead of EAV
Please do as @dezso suggests and answer your own question here. I'm guessing jsonb will win as it has been a much touted feature for this kind of use case. I've seen some benchmarks and it's very fast.
2d
comment SQL Server: track database changes
And what does that link say? Please distill the contents and add it to your answer.
2d
comment Oracle password has expired, however I have no way of changing it
This changes the password for the user SYSTEM, not the user "TPMDBO".
Jun
27
comment Is it possible to use SQLite as a client-server database?
I'd start with a DBMS designed from the ground-up to work client-server and with full-concurrency in mind.
Jun
26
comment Connecting to oracle 11g through maestro gives initialization error
On the same machine as Maestro?
Jun
26
comment Connecting to oracle 11g through maestro gives initialization error
Did you install an Oracle client?
Jun
26
comment Data dump from Mongo to CSV
What do you mean by "mises out on some records"?
Jun
26
comment Connecting to oracle 11g through maestro gives initialization error
What is Maestro? Googling shows about 5 or 6 software packages with that name!
Jun
25
comment should I change mysql platform for higher innodb_buffer_pool_size?
Why do you think you need more than 4Gb?
Jun
25
comment `chown -R` equivalent for PostgreSQL
IMHO you should fix this by creating personal logins for your DBAs instead of using postgres and using set role in your scripts to become the correct owner of the objects.
Jun
24
comment Insert from Another Table + Removing Duplicate Entries in Postgres
Increase your sort memory? Tune work_mem -- see postgresql.org/docs/current/static/…
Jun
24
comment Multiple left join where not in another table
Can you show the data you currently get and the data you want to get?
Jun
24
comment How can I install Oracle (10g or above) on my MacBook running OS X Yosemite (10.10.4)?
Why don't you want to use a virtual machine? Even if it's your only option?
Jun
24
comment Insert from Another Table + Removing Duplicate Entries in Postgres
Use distint on. See my answer.
Jun
24
comment Insert from Another Table + Removing Duplicate Entries in Postgres
This question is about Postgres, not Oracle.
Jun
23
comment Insert from Another Table + Removing Duplicate Entries in Postgres
Check edited answer.
Jun
23
comment Syntax error in postgresql query
From which DBMS?
Jun
22
comment How to see list of databases in Oracle?
This assumes ASM is being used! What about databases stored on a filesystem or SAN?
Jun
22
comment Bulk insert M:N relation in PostgreSQL
How much data are we talking about? In large systems I try to generate IDs based on the IDs from the old system. This helps with testing before and problem solving after cutting over to the new system.
Jun
22
comment PostgreSQL 9.1 Hot Backup Error: the database system is starting up
This in no way answers the question.