I have a Delphi application which hits a database (usually MySql) every 60 seconds through a TTimer. The application is more or less an unattended bulletin board. If the network drops the application needs to continue running and connect back to the database when the connection is back. Often it might be over broadband, so chances are...
Recently I’ve found myself in a database tangle where management wants the ability to remove data from the database, but still wants that data to appear in other places. Example: They want to remove all instances of the product whizbang, but they still want whizbang to appear in sales reports. (if they ran one for a previous date). Now...
Hi, Suppose I have a table with the following columns (a list of words): word: varchar contributor: integer (FK) Now, suppose I wanted to have translations for each "word". What would be best? Having a second table? word: integer (FK) translation: varchar contributor: integer (FK) lang: integer (FK) Or all in the same table? word...
INFO: I am working with Microsoft SQL. Ok the title is confusing but here is an example of the table I'm working with: ID Value Signal Read Firmware Date Time 5 123 656 444 217 3/30/2009 11:00:00 AM 5 123 421 333 217 3/30/2009 04:00:00 PM 5 123 ...
hey guys, As in many databases, i am designing a database that should keep record of previous versions of the rows changed in each table. The standard solution to this problem is to keep a history table for each data table, and whenever a row needs to be updated in the data table, a copy of the current row gets inserted to the history ...
We have a problem here. We need to translate a website into multiple language. We already use gettext to translate the static content. But we have to translate some text content in multiple language. The ui isn't a problem. We found 2 ways to translate the text. 1. use JSON inside our text input Why this solution is bad. Every text...
I want to use SQLite as an associative array that is saved to disk. Is this a good idea? I am worried about having to parse SQL every time I do something like: database["someindex"] which will have to be translated to something like select value from db where index = 'someindex' which in turn will have to be translated to the SQL int...
I am developing an app that needs to send text messages, so I have carrier information stored in a database. I also need that information in an XML file for client side code to read. To make this happen, I am writing a script that reads the carrier information from the DB and creates an XML file in the config directory. I felt this sc...
Is there any possability to create a database within mysql from java. I'm only aware of the String url="jdbc:mysql://localhost:3306/test"; Connection con = DriverManager.getConnection( url, "cb0", "xxx" ); syntax but here you have to specify a database name in the 'url'. But how do I create a mysql database when I only have a logi...
I am developing a PHP application that uses SQLite as database management system, MySQL and PostgreSQL etc. is not an alternative (although I would really like to use pgsql), because I want the setup to be very beginner-friendly and zero-headache alike. Now many people use a shared hosting, and alot of them only offer direct FTP access t...
Is this how one would normally design classes? One class = 1 Table. How about tables that contain a foreign key to another table? Suppose I have the following: PersonTable --------------- person_id name PersonMapTable --------------- map_id type_id (fk) person_id PersonTypeTable ------------------- type_id description parent_type_id ...
I'm writing an application that manipulates some sort of social network data, so the ideal underlying data structure is weighted directed graph. I'd like to do the manipulation (and searching) directly on the data, without first loading the entire graph into memory and serializing after. This could be simulated using a standard SQL data...
I'm seeing a lot of job posts that specifically mention Oracle and PL/SQL. What's unique about programming for this database? How different is it from programming for any other database, especially from Java? Isn't it the same normal SQL? Can't one just use JDBC? I've worked in the past with MySQL, DB2, and MSSQL, but haven't seen Or...
Can you recommend me books that you like the most in database design and optimization? Edit: General design and optimization books (database-independent, no matter it's Oracle, SQL Server or DB2,...) are great. But database-specific books are still great. I would appreciate any ones. :) ...
I am developing an application which involves multiple user interactivity in real time. It basically involves lots of AJAX POST/GET requests from each user to the server - which in turn translates to database reads and writes. The real time result returned from the server is used to update the client side front end. I know optimisation ...
Hi all.. First of all, I'm sorry about the feedback-nature of this question. I'm trying to generalize it as much as I can so others can gain from it as well, but I don't really have anyone to give me feedback on this design, so I hoped you guys could help me. With that being said, I wan't to model different usertypes in my database. I ...
I have an interesting problem which I've been looking into and would appreciate some advice: I'm trying to create a tool which mimics the basic capabilities of a requirements management tool as part of a company project. The basic design is a Windows Explorer-like setting of folders and documents. Documents can be opened in a GUI, edit...
I'm using MS Access 2007 for insert and read data in my application but it's really slow. I've got a long running application and if I run it from the memory it takes about 5 minutes, with MS Access 2007 it takes about 13 minutes! I'm looking for a faster yet portable database option, I'm using .NET . I'm not looking for advanced rela...
Question can also be: What is your preferred way of invoking stored procedures to fill a DataGrid? I am currently developing an ASP.NET Page, and I would like to know if Linq is the right way to go for use with my SQL Server DB. ADO seems nice too, so I would just like to have feedback on what is the most appropriate in general terms...
Hi, Suppose, I have a database named testdb in test server. Also I have a database named proddb in prod server. Now I want to select data of a table of testdb database from proddb database. How can I do that in SQL Server? Also, I can do it using database link in oracle. But how can do that in SQL Server? please help. Thanks Baju ...