I am writing an application using an object database (db4o) and in agile fashion will be starting from a small, minimal implementation and iteratively adding features from there, while releasing new versions of the software as I go. The main question I have is how to maintain backwards compatibility for the database, as new implementati...
I have been experiencing an error that I believe is caused by the database timing out due to a large amount of data being processed and read to the database. I keep getting this error message: Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. I timed how long it takes t...
Hello everyone! Is it possible (and if yes, is it advisable) to do queries of Hibernate-mapped data without using SQL-strings, but some OOP way instead? ...
We all know MYSQL. We all know memcached. I love memcached. You have a string key , and it returns a value. Dead simple. Is there a database for memory? For example, I am building a website that needs to keep track of LOGGING. Everything people do...I need to keep track of. But it would be slow to write to disk every time someone hi...
I am writing the following sub query for some project specific purpose: SELECT count(*) from table1 WHERE userB='$p' AND userA IN (SELECT userB FROM table1 WHERE userA='$row[username]') I was curious if this was the best practice when doing it in PHP or should I resort to the conventional way of first getting the subquery resu...
I want to design a database about bus stations. There're about 60 buses in the city, each of them contains these informations: BusID BusName Lists of stations in the way (forward and back) This database must be efficient in searching, for example, when user want to list buses which are go through A and B stations, it must run quickly...
Using Shiro we have a great security framework embedded in our enterprise application running on GF. You define users, roles, permissions and we can control at any fine-grain level if a user can access the application, a certain page or even click a specific button. Is there a recipe or pattern, that allows on top of that, to restrict a...
Hi, Currently we are using xml files as local data store for our disconnected application, there is proposal to move to SQL CE database. Can some one with experience of SQL CE provide some pros and cons of using sql compact, for example data type support etc. As Central DB server we are using SQL Server2005. One of the requirement is ...
Does "fn:id" function return IDREFS when it is used in a FLOWER xquery with eXists database? I can't get any example... :( TIA ...
I have a website I have developed using a databse and I have created some security on the site. This ceates another DB called ASPNETDB.MDF. The main site database is on a server at the website host. At this time the aspnetdb is in the APP_DATA folder of my website. I want to copy the tables and their data from the aspnetdb to the main ...
I have a model named Tickets that being saved to the database even when invalid. This is stopping me from using validations to help prevent duplicate data being saved to the DB. In script/console >> Ticket.last.valid? => False >> Ticket.first.valid? => False If I try to see what errors are associated with this invalid object >> Tic...
I recently ran across a very interesting problem involving database design. I have changed the table names to simplify the problem, so let me describe it as such: I have 2 tables, fruit and vegetable each stores whether or not a fruit or vegetable is tasty. Now lets say that someone keeps changing the IsTasty setting through the UI of m...
Is there a good free POI database (i'm thinking mainly public places like cinemas, shops, etc). OpenStreetMap would seem like a good source, but I haven't worked out how to download the POI database. ...
I'm trying to convert the permanent tables used in a stored procedure to global temp tables. I've looked at the stats on these permanent tables and some have tens of millions of rows of data and are on the order if gigabytes in size (up to 10 GB). So, CREATE TABLE my_table ( column1 NUMBER, column2 NUMBER, etc... ) TABLESPAC...
I have written this program for connecting and fetching the data into file, but this program is so slow in fetching . is there is any way to improve the performance and faster way to load the data into the file . iam targeting around 100,000 to million of records so thats why iam worried about performance and also can i use array fetch s...
What is the age old method of testing execution time of stored procedures on informix 11.5. I am thinking of doing something like this from a unix prompt: $ time (echo 'execute procedure foo(1)' | dbaccess ...) Any other ideas? ...
how do i connect excel to an oracle DB? ...
I am trying to connect to a database using a login form. Currently there is one user in the database but when pressing submit the page just appears to refresh and is not redirected to the home page as it should. Here is my code: <html> <head><title>Login</title></head> <body> <?php ob_start(); include('connect.php'); $handle = mysql_...
I did updatedb. I did locate my.cnf But I cannot find it? Nothing. (I installed MYSQL using aptitude install mysql-server, and mysql does work right now.) ...
When you study relational theory foreign keys are, of course, mandatory. But in practice, in every place I worked, table products and joins are always done by specifying the keys explicitly in the query, instead of relying on foreign keys in the DBMS. This way, you could of course join two tables by fields that are not meant to be for...