13,917 reputation
12253
bio website
location Munich, Bavaria
age
visits member for 3 years, 10 months
seen 1 hour ago

Feb
11
comment Use Oracle on Web App (New Question)
So why did you install MySQL amd phpMyAdmin then? phpMyAdmin is only for MySQL
Feb
11
comment Use Oracle on Web App (New Question)
I don't get it: do you want to use Oracle or MySQL?
Feb
11
comment Combining date and date/time ranges in PostgreSQL
I would go for the third option as well
Feb
11
comment check key if exists in other table without fk constraint
If your trigger raises an exception, the insert won't happen (and the insert will fail with an error). If you want the insert to fail "silently" just return null from the trigger: "Row-level triggers fired BEFORE can return null to signal the trigger manager to skip the rest of the operation for this row"
Feb
10
comment How to add entries to tables in PostgreSQL if the attributes are reliant on other tables?
The groupid in group leaders is not necessary. And unless a group leader has additional attributes that a user does not have, I don't see the reason for the group leaders table at all. If the group leader is "just a user", let leaderID reference the users table.
Feb
10
comment is camel case for column names safe?
It depends: select ThisIsAColumnName from SomeTable is the same as select thisisacolumnanme from sometable (according to the SQL standard) . This is true for all Postgres versions. On MySQL this depends the storage engine used, the MySQL and storage engine configuration and the file system that is used. I personally prefer snake_case over CamelCase in SQL - but that is just my opinion.
Feb
10
comment Storing floating point values for various units of measurement (kg, ml, mm, pl)
floating-point-gui.de
Feb
10
comment Oracle StartUp Error
Looks like your data files are corrupted. You will need to restore your backup
Feb
9
comment Database-agnostic stored procedure call passing array of name/value pairs
@ThomasKejser: not sure what you mean with "temp database". I was talking about a temp table not a temp *database. As I see it: it's only one additional roundtrip (either using on insert with many rows or in case of Oracle a batched insert). Most DBMS will be more efficient when using a JOIN rather than a large IN clause, so that might alleviate the cost of the additional round trip(s) - I would at least give this a try and test the performance.
Feb
9
comment sp_sequence_get_range equivalent in Oracle
What does sp_sequence_get_range do?
Feb
9
comment Database-agnostic stored procedure call passing array of name/value pairs
Why not put the parameters into a temporary table and then join to that table in the stored procedure? That should be fairly DBMS independent.
Feb
6
comment Optimizing a single table, write-once, read-many PostgreSQL database
increasing shared_buffers comes to mind. You might also want to go through this: wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
Feb
6
comment Postgres user without password
You should be able to achieve this by putting a line in pg_hba.conf that defines a trust connection for that user. That line should be before the lines defining the peer authentication in order to have a higher priority
Feb
6
comment How to generate an SQL file with DBMS_DATAPUMP
If you only do this to get the SQL for the schema, you might want to add dbms_datapump.data_filter(handle => datapump_job, name => 'INCLUDE_ROWS', value => 0); (before starting the export job). Using that, no data will be exported which should be faster. Depending on what kind of SQL script you are after, you should also look into dbms_metadata - it can generate the SQL for everything(?) without the need to export first.
Feb
6
comment Can PostgreSQL use multiple partial indexes per query?
No. In fact I have hardly ever seen multiple indexes of any kind used for an and condition (at least I can't recall it)
Feb
5
comment Can PostgreSQL use multiple partial indexes per query?
I think it all depends on the data distribution. I would assume that the choice to use more than one index is not determined by the fact whether it's a partial index or not, but whether it will reduce the cost of the query. The only way to find out is to run explain analyze on your query with your data. My experience is that Postgres prefers to use two indexes only when or conditions are involved, I have hardly ever seen this with and conditions.
Feb
5
comment Postgresql - Stuck building a plpgsql function
@Egidi: you didn't mention you were using an unsupported and outdated Postgres version
Feb
5
comment Postgresql - Stuck building a plpgsql function
Cross post: stackoverflow.com/q/28344460/330315
Feb
5
comment Slow transactions, many locks
If an update is sometimes slow and sometimes fast, this could be caused by locking, and concurrent updates waiting for each other.
Feb
5
comment How to generate an SQL file with DBMS_DATAPUMP
Try job_mode => 'FULL'