Hi guys! I'm in the process of coding my very first blog. With the help of various tutorials, and other forums I have managed to gather a semi-working code. Right now I have a code that takes and displays the comment, but the problem is coordinating which comments go on which post. My current set up is all my post are HTML files, and t...
I need to maintain a 200 entries, 12 column table at extremely high speed, can I simply use boost multiindex to cutoff the sql overhead? Has anyone ever tried to do this? What are the cons and pros of such a solution? thanks ...
I have an Access 2000 database that contains a table of little lotto numbers. The first column is "Drawdate", the second "P1", the third "P2", the fourth "P3", the fifth "P4", and the sixth "P5". I'm trying to find 10 numbers from the table that are used the most together. 10 numbers used 5 at a time would produce 252 combinations. Fr...
I'm just starting to work with database projects in Visual Studio 2010, and I'm wondering how I get the differential script generator to include a DROP TABLE statement. If I create a new table script in the Tables folder, the differential picks that up and includes a CREATE TABLE statement in the deployment script, but when I delete tha...
In SQL Server Management Studio, if I attempt to restore a database from a backup file with a command like: RESTORE DATABASE somedatabase FROM DISK = '<virtual disk>:\<path>\<backup file>'; I get a "file not found" error. I'm creating with the "subst" command. But if I replace with a physical disk and with the complete path, the ...
DB gurus, I am hoping someone can set set me on the right direction. I have two tables. Table A and Table B. When the system comes up, all entries from Table A are massaged and copied over to Table B (according to Table B's schema). Table A can have tens of thousands of rows. While the system is up, Table B is kept in sync with Table ...
Hi, I have a tableview with data, that i post to the app engine database. Whenever i delete an entry in the table, i want to delelte the item in the app engine database as well. How do i know which entry to delete? I was thinking of this: for every item i save in the GAE store, i make a reference to a model with the iphone unique devi...
Say I'm expecting about 100 requests a second, each request should take anywhere between 1 - 3 seconds (In a perfect world). Would I create a pool of 300 connections? Or something slightly higher to compensate for potential spikes? ...
Recently I change from <input type="button"> to <button> in my forms however the form being processed by PHP wouldn't then submit to the database. Am I missing something in my code? Basically all I have done is changed this: <input type="submit" name="submitAdd" value="Ask Question! " /> To this: <button type="submit" class="btn" n...
I was wondering if anyone knew how to generate a fixture.yml from data that is already existing in the database? As you can use the build-schema to generate a schema, is there a way to do that for data? symfony propel:build-schema ...
I have an existing data model where I can rename things freely to match CakePHP's conventions. I have a type of graph node, where a node can have an arbitrary number of child nodes and an arbitrary number of parent nodes (uni-directional relationships). Here's the table of nodes, following CakePHP's conventions: Table: nodes Column: no...
I'm building a J2EE web apps with Oracle database. The app server uses JDBC connection pooling to Oracle database A (e.g. 20 connections max), and some of the queries performed use tables in remote Oracle database B via database link. If the App Server creates 20 connections to database A, and all queries are looking up data in datab...
Hi, Is it possible and if so, how can I do it, to select all entries in a table in my database and then display five results at the time in one group. Meaning: A example is that I've 15 records total in my database, then I want to present my data like this: <div class="1-5">Record[1], Record[2], Record[3], Record[4], Record[5]</div> ...
For f# to talk to a database, I presume you turn to some code that looks quite a lot like C# code, using some NET libraries (ado.net for example) and quite a lot of imperative code that has, by definition, quite a lot of side-effects.. Or am I missing something here? Has F# some beauty to offer in this domain also? And would someone ...
If you copy or move an object that somebody else created, what should you do with the createdBy, createdOn, modifiedBy and modifiedOn? With move, I would change the modifiedBy and modifiedOn. With copy, I would change both the createdBy/createdOn and modifiedBy/modifiedOn. Is this correct? In my example the data gets persisted to a d...
I've an application, that uses encrypted (txt) files to store data. After investigating the decompiled assembly I concluded that it's a file of some DBMS. So how can find out which DBMS is this application using to store it's data, so that I can attach that file to the correct DBMS. This is little application and there is no license pro...
I need help for database tool. ...
Hi, i was wondering what the best way is to implement a hit counter for articles, products, etc. Now if someone visits the page the counter just adds one in the database. If someone refreshes the page it counts continuously, misleading results, and unnecessary reads, writes. I was thinking of storing their ip, but i don't know how to mo...
I'm working on a number of Delphi applications that will need to upgrade their own database structures in the field when new versions are released and when users choose to install additional modules. The applications are using a variety of embedded databases (DBISAM and Jet currently, but this may change). In the past I've done this wi...
Hi there, I'm using Hibernate with a JTAFactory - in my case: jBossJTA - I've configured my hibernate.xml with the current JTA, now maybe I'm doing something wrong, my dao code looks like this try{ ses = sessionFactory.getCurrentSession(); ses.beginTransaction(); doSomeWork... session.getTransaction().commit(); }catch(Exception...