Tagged Questions

0
votes
1answer
29 views

Use MySQL and PostgreSQL in the same PHP script

I'm trying to do some migrations from an old site to a new site. The old site uses MySQL and the new site uses PostgreSQL. My problem is I wrote a migration script in PHP that queries info from the ...
-6
votes
0answers
37 views

which is better according to memory performance regular tables or temp tables in postgresql [closed]

which is better for memory performance regular tables or temp tables in postgresql and mySQL? and I tried Table vs Temp Table Performance but I couldn't find the needed solution.
-2
votes
0answers
31 views

FOSS web session replication solutions [closed]

Context I am developing a simple web application (written in python/pyramid) with an underlying http service as data store and with a partner integration by using backend http communication and ...
0
votes
1answer
39 views

Analog of OUTER APPLY in other RDBMS (not SQL Server)

I'm using SQL Server at work, and I have some nice tricks with OUTER APPLY clause which helps me do not repeat code. For example, if I have a table like this: create table Transactions ( ID ...
-1
votes
2answers
45 views

Insert command without id postgreSQL

In mySQL i am able to do INSERT INTO table_name (column_name1, column_name2) VALUES('John', 'Doe); As you can see I do not have to mention the ID, how would I do this in postgreSQL. Thank you
1
vote
1answer
25 views

Selecting schema configuration in Postgres with doctrine 2

I've got a complex question, I hope you will help me. I'm using Doctrine DBAL in my application because I would like to make it works in Postgres and Mysql. The problem is that I want to switch over ...
0
votes
0answers
46 views

What type of database should I use for separate logs of event/time series data? [closed]

I am planning on developing a Web site for MMO combat log analysis similar to World of Logs but for a different game. :) I would like to ultimately be able to handle having on the order of 200k ...
0
votes
2answers
55 views

Get max id of all sequences in PostgreSQL

We have a monitor on our databases to check for ids approaching max-int or max-bigint. We just moved from MySQL, and I'm struggling to get a similar check working on PostgreSQL. I'm hoping someone can ...
0
votes
1answer
41 views

MySQL x Java - Raising Exception

I've been learning MySQL this past few days. Previously, I develop with PostgreSQL. Maybe I missed something and wasn't able to find the right tutorial or question here in SO. If this is a duplicate, ...
-2
votes
0answers
37 views

Could a sqlite3 db be corrupt by 3rd party software? [closed]

we have 2 rails 3.2 apps using sqlite3 (gem sqlite3 1.3.7) hosted on ubuntu. One has never had problem with sqlite3. Another one has 2 complete lock-out (need to reboot) and one file corruption so far ...
-2
votes
1answer
45 views

CREATE FULLTEXT INDEX in PostgreSQL [closed]

I have to "translate" a MySQL SQL script (table and index creations basically) to PostgreSQL and have come across the following: CREATE FULLTEXT INDEX param_description ON info_param (description ...
1
vote
2answers
56 views

time zone confusion in relational databases

I have downloaded a postgres database in .sql format. The type of temporal column in the database is: timestamp with time zone. And dates are mentioned in the database in the form given below: ...
0
votes
1answer
39 views

Database Design - Party Object Model and Relating Index's correctly [closed]

Im a developer by trade and I am currently dabbling in database design. I have been advised on StackOverflow to use the Party Model to achieve the ability to relate customers that may be people or ...
0
votes
1answer
34 views

MYSQL migrating to postgreSQL issues

Trying to convert my MYSQL db to postgreSQL so it will play nicely with heroku. I installed the gem mysql2psql and run it. When I run it, I get... mysql2psql Creating table breads... Created table ...
-2
votes
3answers
78 views

Sql Result IN a Query

dont blame for the database design.I am not its database architect. I am the one who has to use it in current situation I hope this will be understandable. I have 3 tables containing following data ...

1 2 3 4 5 … 60
15 30 50 per page