Hello, I am currently trying to build a navigation that is semi built by the user, basically the user has a primary navigation in which if they click on a category name a block is created on the page for that category. If they click the same link again the block is removed from the page, the website is set up to remember which blocks the...
We have 2 object types and want to connect them N:N. For example, articles & authors. How would you name relations table? What would you put first at table name, articles or authors? (articles2authors or books2authors) Someone would, probably, recognize this question as stupid. I don't think so because I'm looking for ideal naming co...
Hello, I have a mysql query, that does the following, SELECT * FROM categoryTable LEFT JOIN userMenuTable ON userMenuTable.categoryId = categoryTable.categoryId this returns only results that match this condition ON userMenuTable.categoryId = categoryTable.categoryId I was hoping it would be possible to pull all the results and ...
should we always combine one-to-one tables? I have a user id uid, a table containing the basics: uid, name, address, etc.. and another table that is essentially the same thing, with the foreign key on the previous user table uid, stats, etc.. should i just combined them? when does it make sense to and when would i not want to? ...
I have two versions of the same application. When people upgrade from the free version to the paid version I'd like the free database to be copied to the pro database location. Is there a way I can access the database file itself if it belongs to another application? Does the file even belong to the application or is it generally acces...
I need to generate data in a database to test lucene. If anyone knows where I can get a sample database all a way to generate real life data please let me know. I need to test millions of rows that contains real life articles. ...
Hello, I have a customers table with information about our customers (ID, login, name, contacts info, different options, TS column, and so on, ~15 columns, ~few hundreds of customers). Now we need to send every-day-updates to our biggest customers (<10% of all customers). And I need to store timestamp of the latest update which were s...
Apache Jackrabbit includes some sort of database/archive query mechanism called JQOM. Where is a good place to start learning about what it is and how it works? Thanks in advance. ...
How can i deploy a system that I can install in a PC and dont have to install a DBMS locally. I want the data repository of this system to sync with the main database online whenever the user want. The local system wont have internet access all the time. I could manage data locally with files or Access but I think a better solution must ...
Using Greenplum database version 3.2.3 on Solaris. Step 1. Create a table. CREATE TABLE ivdb.OPTION_PRICE ( SecurityID integer NOT NULL, Date timestamp NOT NULL, Root char(5) NOT NULL, Suffix char(2) NOT NULL, Strike integer NOT NULL, Expiration timestamp NOT NULL, CallPut char(1), BestBid real NOT NULL...
Hi, I just submitted this to Apple Support, but I'm wondering if anyone here has encountered something similar. SUMMARY: my iphone app crashes when downloaded from the iTunes app store or from an ad-hoc distribution, but doesn't "crash" when run in debug mode on the simulator or on my iPod DETAILS: The app contains a rather large sqli...
We have a Sales related project. Now we are keeping the stock of the products in a separate table named Stock. At the time of sales, sales-return, purchase and purchase-return the stock table will be updated. It works well, but while we are deleting or modifying one of the sales or purchase, it's more difficult to maintain the stock. ...
Hi all: Disclaimer: first time I've used DBI. I have a MySQL table with a lot of indexed fields (f1, f2, f3, etc) that are used to generate WHERE clauses by long-running processes that iterate over chunks of the database performing various cleaning and testing operations. The current version of this code works something like this: s...
on my website a user can post comments and group these into categories. eg. category: good quotes links: "some quote 1", "some quote 2", and so on. so the nr of categories and comments are determined by the users. im thinking how i should organize this in the mysql database. i cant have one table for each category because there wo...
In a WPF application I use LINQ to SQL, SQL Server 2008. SQL Server computer was replaced and SQL Server was installed under instance name not the same as before. Database was restored under the same name as before. The new connection string was added to the application. But it appeared that it is impossible for the application to con...
I created a gwt app with a gxt combobox. I have it where it pulls data (a list of names apprx 5000) from the database places it in an array which in turns places it in a store. That is then placed in the combobox using set store, so when a user starts typing in the combo it searches through the store for the name. My question: is this t...
I'm trying to get a float to show up with the decimal point in my sqlite table. I've included the code below for how it shoes up in the game which is all fine. As well as for what happens at the end of a level. And how it gets updated to the sqlite table. It shoes up fine as a decimal during the game, but it gets recorded to the tabl...
I have Users which can be either TypeS, TypeC, or TypeA. I have models for each of these types to store additional information. Now, in the Users table, should I have 3 nullable foreign-key fields to designate which type they are 2 fields, 1 with the name of the type and 1 with the foreign key 1 field designating the type with the for...
I am writing an application that initially will be developed as web (probably Silverlight) and Android application. I found on Android website that SQLite is supported, but I plan to release the same app for Windows Mobile, Palm Web OS and iPhone as well. Could you please advice me on which database would be the best to work with for al...
I can't seem to get an answer through google about this. If I perform updates to multiple entities at one time, attach them all to context, call Submit() and one of the updates to the entities fails, do all the changes get rolled back? For example, in my asp.net application I have a note and a note revision table. In my asp.net applic...