11,143 reputation
11842
bio website
location Munich
age
visits member for 3 years, 2 months
seen 36 mins ago

May
22
comment HStore vs. multiple tables with inheritance - do I have a good use case for HStore?
Do all experiments share the same attributes? (foo, bar in your example). If yes, then the second table is the best way to go. hstore is only useful if you have different attributes in each row of a table.
May
22
comment Schema for dynamic number of attributes
Which DBMS are you using? In Postgres you can very efficiently use the hstore (key/value) data type for this kind of problems
May
22
comment UPDATE Query replacing string primary key taking days to resolve
Which indexes are defined on the tables? What does the execution plan say? Unrelated but: I wouldn't store a UUID (or "UUID-like) in a bytea column. uuid or varchar is probably a better choice.
May
21
comment Column vs Field: have I been using these terms incorrectly?
People like Joe Celko tend to disagree that fields and columns are the same thing.
May
21
comment About creating a View With additional coumns (that are not in the table)
Which DBMS are you using? Postgres? Oracle?
May
21
comment Analize Query in MySQL Server 5.1
I don't think MySQL exposes that value in the execution plan
May
20
comment PostgreSQL replication with fsync disabled?
Turning off fsync does not mean WAL is not written, it's still written - just not in a reliable way.
May
19
comment Postgres 9.3 64 Bit Windows 7 and 64 bit Postgres install - cleared password no longer connects
There is no such thing as a "server password" in Postgres. And Postgres doesn't need a password to start unless you mis-configured the Windows service that runs Postgres.
May
19
comment Which is better MAX function or ORDER BY column_name DESC with LIMIT 1
What does the execution plan say?
May
19
comment Does MySQL guarantee atomic upgrade from read lock to write lock?
Why would a primary key "quadruple" the size of the table?
May
17
comment SQL query to find all parent records where all child records have a given value (not just some)
The syntax of the statement you have show is invalid for Postgres (dreaded backticks, invalid use of group by). That looks more like you are working with MySQL
May
17
comment Set up Firebird with shared storage?
One database can only be accessed by a single database server. SuperClassic, SuperServer is irrelevant here as it only defines how the server process internally works. Databases should never be stored on a shared filesystem.
May
17
comment Set up Firebird with shared storage?
@WorajedtS: using a single shared storage for multiple database instances is certainly not possible in Postgres (and I don't think it's possible in Firebird either) so I don't understand what exactly you want to do. Of course you can store the database files on a SAN (although it's probably not a good idea) but that can still be accessed only by a single server process.
May
17
comment Multiple primary keys in PostgreSQL
You can't have multiple primary keys. But the code you have shown will not generate that error (see here: sqlfiddle.com/#!15/3f775/1). There must be something you are not telling us.
May
14
comment How can I insert records 'into null' in Oracle?
I too think the view is the way to go. But I'd also be reluctant to base that view on the dual table. Just create a dummy table instead.
May
14
comment Checking if user owns child records (MySQL)
Please don't compare apples to oranges, i.e: don't compare strings ('20') to numbers (20). If user_id is defined as an integer column use a proper number: 20
May
12
comment MySQL: Is it possible to join a virtual table with itself?
The standard SQL solution (in nearly every other DBMS) would be to use a CTE - but MySQL still doesn't support that. You will need to create a view based on some select subquery.
May
9
comment Does database require block storage always?
Well, in the end regular file system is also using blocks to store the data - because that's the way how the harddisk is physically structured.
May
9
comment Easiest way of shutting down a PostgreSQL server on Ubuntu
Well as the error message says: you need to specify the data directory using the -D switch. Alternatively I think using service postgresql-9.3 stop should also work (the service name might be different though)
May
9
comment Authentification failure for PostgreSQL server (9.3)
If you forgot the password you need to switch to trust mode, then login using the postgres super user (no need for a sudo, just use psql -U postgres) change the password, then change trust back to md5