"msaka msaka" <[EMAIL PROTECTED]> writes:
> how can i use timestamp value in sqlite
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
On Fri, 2005-04-22 at 13:30 +0200, Tobias RundstrÃm wrote:
> > If you disable the F_FULLFSYNC, it will go much faster.
>
> Compiletime change or some pragma?
>
PRAGMA synchronous=NORMAL;
> >>Secondly after holding the DB open and not sending any querys to it for
> >>quite some time (3-4
Thanks for your reply,
D. Richard Hipp wrote:
On Fri, 2005-04-22 at 09:10 +0200, Tobias RundstrÃm wrote:
First of all performance is TERRIBLE, without syncronous=off I see
insert times of up to 1 second for one row?!
This is the F_FULLFSYNC issue. It's a sad hardware story and there is
nothing
I've been working on cleaning up some assertion failures in 2.8.15
which occur when sqlite fails a write in the middle of a transaction,
due to the disk being full. My testing methodology is having the
database in a small tmpfs filesystem, running transactions continuously
against it, and
On Fri, 2005-04-22 at 08:56 +0200, [EMAIL PROTECTED] wrote:
> 3. SQLite
> SQLite is developed for these types of applications. 1 user, local
> datasets, quick access, etc.
> But many problems with it:
> - it have only english "order by" lang support
You can add "order by" support for any
On Thu, 2005-04-21 at 19:33 -0700, Vladimir Vukicevic wrote:
> That would work, except right now you only get SQLITE_SCHEMA from
> sqlite3_finalize() -- sqlite_step just returns SQLITE_ERROR. If
> step() returned SQLITE_SCHEMA(), transfer_bindings() would work well,
> or even if there was another
On Fri, 2005-04-22 at 09:10 +0200, Tobias RundstrÃm wrote:
> First of all performance is TERRIBLE, without syncronous=off I see
> insert times of up to 1 second for one row?!
This is the F_FULLFSYNC issue. It's a sad hardware story and there is
nothing that software can do to fix it. Google
On 4/22/05, Jan-Eric Duden <[EMAIL PROTECTED]> wrote:
> I use the sqlite3_expired api - which is only documented in the
> sqlite3.h header.
> Unfortunately it is considered an experimental API.
Huh, I never noticed that function in the header -- thanks for
pointing it out! It looks like the call
hi
how can i use timestamp value in sqlite
i create table :
create table sales (id integer not nul primary key, --- [this is time stamp
information ??]
bill_number integer,
item_code integer,
amount double);
then i insert into sales:
Hi !
I don't know about the language issue, someone else must answer that.
I have a solution for search. If I put another field aside every
char-based field, with manually UPPERED content, then I can search in
with SQL, not with my search functions. And I can create another plus
field with
Op vr, 22-04-2005 te 09:26 +0200, schreef [EMAIL PROTECTED]:
> Dear Bert !
>
> >This group is not about firebird,
>
> Ok, I know it.
>
>
> But I want info from SQLite.
>
> I wrote these fbembed question to see, I want to compare the possible
> solutions.
> I don't know enough about the
Dear Bert !
This group is not about firebird,
Ok, I know it.
But I want info from SQLite.
I wrote these fbembed question to see, I want to compare the possible
solutions.
I don't know enough about the SQLite, so I'm not sure that is true, or
not true, what I say about it.
If you think that
Vladimir Vukicevic wrote:
On 4/21/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
How about sqlite3_transfer_bindings(). So if you get an
SQLITE_SCHEMA error you rerun sqlite3_prepare() to get
a new sqlite3_stmt, then call sqlite3_transfer_bindings()
to transfer bindings from the old statement
Op vr, 22-04-2005 te 08:56 +0200, schreef [EMAIL PROTECTED]:
> Hi !
>
> In the years of 2000 I wrote 3 programs.
> These apps are placed in CD, but in this time I don't have good solution
> for online databases.
>
> Then I placed an Installer in CD, and this Setup prg. is install
> InterBase
Hello,
We (XMMS2 Team) have been using SQLite for quite some time now, it's
used to cache metainformation about songs played. It can also be used
to be searched and store addtional information. SQLite fits us very
well and have been a good complement to xmms2.
My primary platform is MacOSX and
Hi !
In the years of 2000 I wrote 3 programs.
These apps are placed in CD, but in this time I don't have good solution
for online databases.
Then I placed an Installer in CD, and this Setup prg. is install
InterBase 6.0 in the computer with my software.
That is very wrong solution (I think it
16 matches
Mail list logo