8,316 reputation
11027
bio website
location Munich
age
visits member for 2 years, 1 month
seen 50 mins ago
stats profile views 773

I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)


40m
comment Is it ok to let users add new columns and tables to your database?
But "a database that's actually a database" would still need tables to store data?
44m
answered query to get list of tables that has same columns from information_schema.columns?
1h
comment Is it ok to let users add new columns and tables to your database?
Did you want to write "your users would be better off without a database" - otherwise that sentence does not make sense to me
8h
comment Difficulties in createing a PostgreSQL Database
How do you dconnect to the server? Which SQL client are you using?
16h
comment Commands like CREATE, GRANT, DROP always return “0 rows affected”
This is actually a problem of the SQL client rather than "MySQL" itself. Not all clients behave this way.
2d
comment How to set password for PostgreSQL database with a script?
See here: stackoverflow.com/q/11039499/330315 and here: stackoverflow.com/a/9736231/330315
Jun
15
comment 2 Outer Joins on Same Table?
This is a good reason to dump the old implicit joins and propietary outer join syntax and settle for ANSI 92 explicit joins.
Jun
15
revised 2 Outer Joins on Same Table?
edited tags
Jun
15
revised How to drop inheritance?
added 13 characters in body
Jun
14
comment create table with date name
Cross-posted: stackoverflow.com/q/17106254/330315
Jun
13
answered Why Oracle SQL Developer does not need Oracle client?
Jun
13
comment Can we create a table in specific datafile - Oracle 11g R2?
You can only put tables in tablespaces, not in data files.
Jun
13
revised PostgreSQL: How can I setup Master-Slave replication with DML changes in Slave
added 1 characters in body
Jun
13
revised PostgreSQL: How can I setup Master-Slave replication with DML changes in Slave
fixed spelling of postgres
Jun
13
comment Sybase tools in web
What are you referring to? What exactly is your question?
Jun
12
comment Postgres books for a Sql Server DBA
It's geared towards people that are Postgres to deliver good performance. In most of the cases that would be the DBA I guess.
Jun
12
comment Postgres books for a Sql Server DBA
I can highly recommend the "PostgreSQL High Performance Book": packtpub.com/postgresql-90-high-performance/book
Jun
12
answered Is there any way to retrieve “Messages” in SQL Server through JDBC?
Jun
12
comment Best practice for storing record metadata
Then I don't see any reason not to add those three columns to the base table.
Jun
12
comment how to view content of Sybase procedures?
What exactly is xbase?