A popular open-source embeddable (i.e. non client-server) RDBMS implemented as a C library.
0
votes
0answers
78 views
Database structure advice for large data text searching
I want to search scanned text (comprised of a few gigabytes of text).
The problem with this text (which is why I cannot make an index of words) is that it was OCRed, so there could be (and are) ...
2
votes
1answer
415 views
Is there any way to get the position of a value in a table returned by a SELECT statement?
I have the following statement:
SELECT id FROM myTable WHERE aCondition == 1 ORDER BY id
which returns a table like this one for example:
id
1
3
4
5
But what I need is to know the position of a ...
1
vote
1answer
354 views
How to create a train schedule in SQLite3?
I am interested in what a SQLite3 database schema would look like for a train timetable.
Generally this is presented in table format as the final result.
Sample Schedule for M to F
STATION A ...
3
votes
2answers
1k views
Storing prices in SQLite, what data-type to use?
I am using SQLite and need to store prices. SQLite's REAL data-type says it uses floating-point which is unacceptable storage for prices. Is there a data-type besides TEXT that I can use to store ...
1
vote
1answer
412 views
Looking for a tool to convert between MySql, Sql Server CE, Sql Server and SQLite
Our old product supports 4 different database types for storing data:
SQLite
MySql
Sql Server CE
Sql Server
There is also an export feature, which allows to export some data and here is the ...
1
vote
4answers
757 views
RAM/memory based databases
I am looking for a RAM/memory based database, and these two seem to be interesting:
SQLite
Oracle Berkeley DB
Do you have any other suggestions?
I need more than one executable to be able to ...
2
votes
1answer
859 views
Postgres uuid: Use as primary key, or in addition to SERIAL -for disconnected app-
For a new SASS app with postgres 9, that will support disconnected clients.
The client not will use the regular IDs, only the UUID. The clients will be on iOS, html5/python and perhaps later on other ...
4
votes
1answer
877 views
Why doesn't INSERT AFTER Trigger add all results?
I'm working on the exercises for db-class.org where we have to write a trigger that makes new students named 'Friendly' automatically like everyone else in their grade. That is, after the trigger ...
3
votes
2answers
653 views
MySQL vs SQLite on Amazon EC2
I have a Java program and PHP website I plan to run on my Amazon EC2 instance with an EBS volume. The program writes to and reads from a database. The website only reads from the same database.
On ...
0
votes
1answer
270 views
How SQLite index ID (or line number)
SQLite is based on a flatfile, and store virtual tables in a flatfile (I think based on offset, correct me if I'm wrong). But how it index the Primary Key (ID), which I think is identical to line ...
3
votes
1answer
737 views
How do I force SQLite to materialize a subquery?
Because SQLite sometimes evaluates functions like random() more than once if they appear in a subquery, which may be a bug, eg:
select op, op from (select abs(random())%10 as op from (select 1));
3|1
...
2
votes
1answer
611 views
Track daily view count of youtube videos
I am making program that searches youtube for given keyword and need to get links of active videos. Term "active" means that video must have 1000 views per day. Youtube API doesn't give such ...
3
votes
1answer
414 views
SQL Server Embedded Edition vs SQLite
Can anybody shed some light on how these SQL products compare? No need for essays, only highlights such as "X supports this, while Y doesn't".
How is efficiency affected as the database grows ...
12
votes
1answer
665 views
Limits of SQLite
How far can one take the sqlite database from a single-user , embedded , prototype oriented db engine ?
11
votes
1answer
504 views
What does collation mean in database parlance?
I am learning sqlite from a book which has mentioned collation and collating sequence multiple times. What does it mean exactly in the database world ?
3
votes
1answer
674 views
Estimating impact of indexes SQLite database size
I'm trying to estimate the database size (on disk) for a SQLite DB that includes a number of indexed columns. These columns are of (SQLite) type Integer and String. It's straightforward enough to ...
6
votes
1answer
187 views
How many disk seeks does it take to write one row on SQLite?
As far as I understand, there can be one disk-seek per rotation of a harddisk, therefore I am interested to know how many disk seeks are needed for writing a row to an SQLite table, including locking ...
3
votes
2answers
332 views
Using desktop computers to manage an SQLite database on a fileserver?
Sometimes, it can take months to get a proper database server up and running in large companies. They have all kinds of policies, which means that this process takes months. An alternative in the ...
2
votes
1answer
614 views
Auto Increment Index Field For Create and Update
I'm trying to create an unique auto increment index field that is re-generated on both inserts and updates. I need it so that a client can send a server an integer and get back all outdated (created ...
5
votes
1answer
334 views
Which is the most performant way to copy a number of SQL Server tables to a readonly SQLite database?
I have a database with about 50 tables with use together about 1 GB space.
The SQLite database will be readonly.
This copying will be done once each month.
EDIT:
I see one possible solution using ...
3
votes
1answer
563 views
Casesensitive vs. Caseinsensitive Collatesequences?
I just started working with the SQLite database places.sqlite.
Fact is that this database uses case sensitive collate sequences making writing queries as funny as in Oracle.
I want to know, are ...
5
votes
1answer
804 views
Is there a free software addition to SQLite available for data-replication?
I am aware of the possibility to create my own trigger(ed) solution, but I didn't want to reinvent the wheel :-)
2
votes
1answer
222 views
Using CoreData on a client-side application
This may be a bit more of an SO question, but...
If I'm writing a client-side application for OS X that's going to sync with an online MySQL database, is there any difference on if I have CD use ...
