Hey, I'm starting to build an app, a mobile device. Performance is quite important (as it is in anything else) and I'd like to maximize it. The database will be used pretty often. I'm looking to access it through the QtSQL library of the C++ Qt library. I have experience in MySQL, but don't think that's the right choice. So I'm looki...
Possible Duplicates: Which is more secure: filesystem or database? User images - database vs. filesystem storage store image in database or in a system file ? I can't decide which one I should follow. Can you guys give some opinions? Should I store my images in the file-system or DB? (I would like to prevent others from stea...
Hi , I am using NetBeans to build a Desktop App. I'm using JavaDB as the database. I need a column named "Date" . However , I get an error whenever I try to name a column that. Any suggestions ? Thanks in advance . P.S I'm a newbie ...
When I try adding a new data source to my project I get a prompt saying "The connection you selected uses a local data file that is not part of the current project. Would you like to copy the file to your project and modify the connection?" This sounds rather obscure to me, as I'm new to VB.NET and programming non-script apps in general...
Does anyone have any experience having worked with datasets where records become valid and invalid based on an effective start and end date? The issue is when records in these tables have foreign keys to other tables that also have effective start and end dates Seems you have to end up creating new records for just about every table to ...
What would be the best DB for Inserting records at a very high rate. The DB will have only one table and the Application is very simple. Insert a row into the DB and commit it but the insertion rate will be very high. Targetting about 5000 Row Insert per second. Any of the very expensive DB's like Oracle\SQLServer are out of option. ...
Hi, We're in the throws of redesigning a screen from "old style" edit and submit, to AJAXy style with auto saving every few seconds. The result will be way more, but way smaller server/db round trips. For example as a user edits a textarea field, we'll autosave their changes every 60 seconds via AJAX. Currently they would update one or...
The situation I have run into is this. When storing the Code of an entity (must be unique in database), someone could technically put "12345" and "12345 " as codes and the database would think they're unique, but to the end user, displaying of the space makes it look like they are duplicated and could cause confusion. In this case, I w...
I have two tables: OutputPackages (master) |PackageID| OutputItems (detail) |ItemID|PackageID| OutputItems has an index called 'idxPackage' set on the PackageID column. ItemID is set to auto increment. Here's the code I'm using to insert masters/details into these tables: //fill packages table for i := 1 to 10 do begin Packag...
I'm looking for an ORM that allows me to do bulk inserts, as well as create code based on python classes. I tried sqlobject, it worked fine for creating the tables but inserting was unacceptibly slow for the amount of data I wanted to insert. If such an ORM doesn't exist any pointers on classes that can help with things like sanitizing i...
All, Looking for some guidance on an Oracle design decision I am currently trying to evaluate: The problem I have data in three separate schemas on the same oracle db server. I am looking to build an application that will show data from all three schemas, however the data that is shown will be based on real time sorting and prioritis...
I recently moved a bunch of tables from an existing database into a new database due to the database getting rather large. After doing so I noticed a dramatic decrease in performance of my queries when running against the new database. The process I took to recreate the new database is this: Generate Table CREATE scripts using sql ser...
I'm using a framework that loads the table structure from the database everytime I open a page. I'm thinking of using JSON files to cache this data, and let PHP parse them when I need it. Is it better than loading data from the database? Are there another ways to do something similar? ...
I've got a bunch of tables that I'm joining using a unique item id. The majority of the where clause conditions will be built programatically from a user sumbitted form (search box) and multiple conditions will often be tested against the same table, in this case item tags. My experience with SQL is minimal, but I understand the basics....
Hello! I need to use an object oriented data repository for a project. It's going to be something between a wiki and a CMS. I'm not an expert in the field of persistence yet. I suppose Hibernate and Jackrabbit are the frameworks to go, right? As far as I'm informed correctly, Jackrabbit does not support annotations or other convenienc...
I'm a bit curious as to why one would want to use hex encoding over base64. It seems to me that base 64 is more efficient. In particular, why is it that databases seem to always use hex encoding? Is it a historical issue, or am I missing something about hex encoding? ...
i'm using Netbeans 6.5 for RoR development. I believe my sqlite3 DB is out of synch with rails migrations. how can I view and manipulate the database (through netbeans or command line)? ...
Is it best to store the enum value or the enum name in a database table field? For example should I store 'TJLeft' as a string or a it's equivalent value in the database? Public Enum TextJustification TJLeft TJCenter TJRight End Enum I'm currently leaning towards the name as some could come along later and explicitly assign a di...
Ok, so everyone has decided (and for good reason) strait SQL is of the devil. This leaves us with many methods of placing a "middle-man" in our code to separate our code from the database. I am now going to spit out all the info I have gathered in the hope someone can set me strait and tell me what I built. An ORM (Object-relational map...
At my company, we save each database object (stored proc, view, etc) as an individual SQL file, and place them under source control that way. Up until now, we've had a very flat storage model in our versioned file structure: DatabaseProject Functions (all functions here; no further nesting) StoredProcedures (all stored procs in h...