The SQLite documentation says it is transactional. The explanation in the linked article states that if a C++ program which has the SQLite C++ code statically linked into it is forcibly terminated (for example, TerminateProcess() in WinAPI) or crashes when a write is being performed the database remains intact - either fully updated or ...
I want to create a large database of GPS coordinates that can be queried by saying "Return all coordinates that are within 'n' metres of [this coordinate]". I need it to be as efficient as possible so looping through all the coordinates in the database and calculating whether a coordinate is within 'n' metres wouldn't be a desired solut...
I want to select rows from multiple tables using subsonic. For one table I can use Query object, but I don't know how I can add more than one tables to query. ...
I have a script with a few hundreds of sql queries that I need to execute on an Access DB. Since executing sql queries in Access is IMO quit awkward, you can only execute one at a time and does not recognize comment-lines starting with '--', I would like to know if there exist out there an easier way to do this. Is there a good alternat...
I'm currently developing a monthly checklist system for our organization. A user may login, select a month, then submit a list of yes/no questions relevant to that month for our organization's purposes. Some of the questions are used in more than 1 month's checklist, so I'm creating an intersection table to facilitate this one-to-many re...
In my current project, some tables have a column named "changed", which indicates if the the current line had been changed since the last check. All the insert and update statements includes this column. Every hour, I run a schedulated task that queries all changed rows, do some stuff with those rows and then sets null to it's "changed"...
What are the constituents of a good relational database design? I'd want to ask this question in a bit unusual way, lets see if anyone likes the idea. Also read on to see how it's not a duplicate of the question about DB design best practices (or any other question for that matter). The idea is that as a result of voting we will have co...
Hi I'm project managing a development that's pulling data from all kinds of data sources (SQL MySQL, Filemaker, excel) before installing into a new database structure with a record base through 10 years. Obviously I need to clean all this before exporting, and am wondering if there are any apps that can simplify this process for me, or ...
Hi, I'm newbie using Delphi 2007, but I have a some problems and I have one question, Is there a good tutorial or something like that for database programming in Delphi 2007? I have some problems when I try to use DBLookupCombobox and other components in the correct way. Please, if any of you have a good tutorial, I appreciate. Th...
I want to make a query to list cats that took longer than average cats to sell? I have five tables: Animal, Sale, AnimalOrderItem, AnimalOrder, and SaleAnimal Animal table: AnimalID, Name, Category (cat, dog, fish) SaleAnimal table: SaleID, AnimalID, SalePrice Sale table: SaleID, date, employeeID, CustomerID Ani...
I'm trying to avoid reinventing the wheel when it comes to storing street addresses in a table only once. Uniqueness constraints won't work in some common situations: 100 W 5th Ave 100 West 5th Ave 100 W 5th 200 N 6th Ave Suite 405 200 N 6th Ave #405 I could implement some business logic or a trigger to normalize all fields before ...
For reasons that are irrelevant to this question I'll need to run several SQLite databases instead of the more common MySQL for some of my projects, I would like to know how SQLite compares to MySQL in terms of speed and performance regarding disk I/O (the database will be hosted in a USB 2.0 pen drive). I've read the Database Speed Com...
How can I ensure that all data that I've erase from the db tables, is no longer stored in the mdb files (and others) on the hard disk? Here's my situation: My client used to store non-encrypted credit card data, in their database (SQL Server). Thanks to PCI requirements, they now encrypt all that data... However, the mdb file still has ...
I'm trying to find a way to browse a PostgreSQL database from the Visual Studio 2008 "Server Explorer" panel. I downloaded Npgsql but as I understand that's only a library for the code itself, not the Server Explorer. ...
I have this query: SELECT Items.Name, tblBooks.AuthorLastName, tblBooks.AuthorFirstName FROM Items WHERE Items.ProductCode IN ( SELECT TOP 10 Recommended.ProductCode FROM Recommended INNER JOIN Stock ON Recomended.ProductCode = Stock.ProductCode AND Stock.StatusCode = 1 WHERE (Recommended.Type = 'TOPICAL') ORDER BY CHECKSUM(NEWID()));...
I am hitting an brick wall during normal SQL processing, When connected to Oracle 10g from a remote client w/DBEXPRESS, - using the standard dbxpora.dll + oci.dll When in a transaction, after exactly 255 record insertions, the connection hangs for 30 seconds and returns the error: ORA-03114 (as if it lost the connection...) This h...
This is a generic database design question - What are the benefits of using a synonym in database development, over a simple view? What are the main considerations to keep in mind when choosing between the two? ...
Is there any way to bulk-delete a bunch of objects matching a given query in LINQ or LINQ-to-Entities? The only references that I can find are outdated, and it seems silly to iterate over and manually delete all objects I wish to remove. ...
I'm using sphinx to list me some items from my database here. It's almost 100%, I just haven't figured out yet how to create an OR between two different filters. For example: My Object in the database has a starting and an ending date, I can filter(starting_date, x, y) and filter(ending_date,x,y), but both filters will have to return tr...
I am studying B+ trees for the first time. I just want to know, on what basis should a developer choose the order of the B+ tree? Also, is there something like, B+ trees for the dummies tutorial? I desperately need it. ...