Even if I constantly access/save the data?
By constantly I mean like in an infinite loop that will constantly need to
check and update the table data.
I'm thinking of using SQLite for a game I'm working on and am still in the
design process. I figured for what I need SQL statements can significan
Hello JOIN expoerts:)
I have the following schema:
CREATE TABLE instances (
instanceid integer primary key,
type,
instance);
CREATE INDEX instances_type_instance ON instances(type,instance);
CREATE TABLE instance_fields (
instanceid references instances(instanceid),
field,
subscript
[EMAIL PROTECTED] wrote:
>
> Process A wants to modify the database, so it flock()s
> the rows it needs to changes and starts changing them.
> But half way in the middle of the change, somebody sends
> process A a SIGKILL and it dies. The OS automatically
> releases the flocks as process A
Tzu-Chien Chiu uttered:
OK. But what I don't understand is: is this (lack of sqlite3_exec16) by
design?
The sqlite3_exec function is a deprecated interface used by earlier SQLite
releases. New applications should use, for performance reasons if nothing
else, sqlite3_compile/sqlite3_step/sql
Good morning all,
A poster to digg mentioned some sql performance tuning tips.
I've checked one of them out to see what difference it makes.
My results are below, but first here's the poster's tuning tip list:
// SQL tuning tips
//
// Avoid using the following:
//
// - Boolean operators >, =, <=
OK. But what I don't understand is: is this (lack of sqlite3_exec16) by design?
Yet another question on the library design. I've seen some projects
which provide a same interface for all supported encodings, e.g.
#ifdef _UNICODE
#define sqlite3_open sqlite3_open_utf16
#else
#define sqlite3_open
"Tzu-Chien Chiu" <[EMAIL PROTECTED]> wrote:
>
> Is it true: the only way the fetch the values of the fields in UTF-16
> is to write another version of sqlite3_exec() wrapping sqlite3_*16()
> functions?
>
You do not have to write a new sqlite3_exec16() from scratch.
You can make a copy of sqlite3
Hello, everyone.
Are the parameters of the callback of sqlite3_exec() encoded in UTF-16?
It seems not. I read the source code of sqlite3_exec(), and I found
that it calls sqlite3_column_text() instead of
sqlite3_column_text16(). Why there is no sqlite3_exec16(), with a
UTF-16 encoded callback fu
C.Peachment <[EMAIL PROTECTED]> wrote:
What is wrong with using:
select EventID, EventDate, EventTime
order by EventDate, EventTime
group by EventDate;
Remove GROUP BY clause - it would result in just one record for every
distinct EventDate value, which is clearly not what the OP wants.
Igo
The SQL query will do the grouping and present them in the correct sequence.
All programming languages require that you iterate over the set of retrieved
records. What you do with them as you retrieve them is up to you.
Code would look quite similar in 'C' and would have the same structure in any
Hello, and thanks for the reply.
I dont' know PHP, but I can understand that you are suggesting to "manually"
iterate the records to find the events, and group them by day. Is this right?
"C.Peachment" <[EMAIL PROTECTED]> ha scritto: What is wrong with using:
select EventID, EventDate, Event
What is wrong with using:
select EventID, EventDate, EventTime
order by EventDate, EventTime
group by EventDate;
You have a separate display problem - you want
to put up to three records on the same line. This is
a language and application specific problem. In PHP,
using the PDO module and prod
Hello, everybody
I have the following problem: I have a table that contains "Events", with the
related date and time:
Fields:
EventID
EventDate
EventTime
I would like to "group" these records by day, returning all the "times" of the
events, like:
EventID, EventDate, EventTime1, EventTime2, E
I have an SQLite database which I work in memory (:MEMORY) and I have to get
the binary text (string) of it.
Is there a way to do it without writing it to disk and reading the file?
Command ATTACH works good to get and write from disk or to work directly in
memory but I cannot get the database it
14 matches
Mail list logo
