I recently had a user of the ADO.NET provider report a problem on Vista.
His database is 5gb, and he's doing a full table scan of 16 million rows.
Yea.
I ran some tests using the command-line sqlite3.exe, and observed that
Windows Vista (SP1) is actually trying to cache the entire 5gb file
How about Flex, AIR and a P backend!
On Sep 16, 2008, at 4:33 PM, Javier Julio wrote:
> Um... excuse me! You can all move to the side and make room for Flex
> and AIR!
>
> Ciao!
> Javi
>
> On Sep 16, 2008, at 5:29 PM, A. H. Ongun wrote:
>
>> Best language to use is the one that is suited for
On Tue, Sep 16, 2008 at 3:49 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> But if you insist on doing it in SQL, this should work:
>
> sqlite3 foobar.db "select replace(id,'_',cast(x'09' as text)) from bar;"
That worked:
$ sqlite3 foobar.db 'select replace(id,"_",cast(x"09" as text)) from
Glory Be to You!
That is the platform I am currently moving into!
Adobe Flex/Air where Desktop App and Web Apps merge!
P.
> To: sqlite-users@sqlite.org
> Date: Tue, 16 Sep 2008 17:33:09 -0400
> From: [EMAIL PROTECTED]
> Subject: Re: [sqlite] best language match for SQLite?
>
> Um... excuse me!
Um... excuse me! You can all move to the side and make room for Flex
and AIR!
Ciao!
Javi
On Sep 16, 2008, at 5:29 PM, A. H. Ongun wrote:
> Best language to use is the one that is suited for the job.
>
> Examples:
> I use Perl as a gluing language to connect various subsystems
> together,
Best language to use is the one that is suited for the job.
Examples:
I use Perl as a gluing language to connect various subsystems together, and as
a swiss army knife.
C, C++ for embedded development on Linux.
C++ for Windows development.
Forth for embedded development on some specialized
I don't see any problems with people waving the FLAGS of their
favorite programming languages.
The more FLAG waving the merrier i say, and people will get to
see the many languages being used by the users of SQLite!
This is a wonderful venue for freedom of expression and exchange of
points of
Robert Citek <[EMAIL PROTECTED]>
wrote:
> How can I replace an underscore ("_") in a field with a tab?
>
> This works but seems like suck a hack:
>
> $ sqlite3 foobar.db 'select replace(id,"_","{tab}") from bar;' |
> sed -e 's/{tab}/\t/'
>
> I was hoping for a char(9) or similar but couldn't find
My advice was not to have the tail wag the dog. Choose you language as
appropriate for the application. Sqlite fits everywhere. For example
if it is an embedded system use C. If it it something else a script
system like Perl of whatever would be appropriate.
If you want an ideally
How can I replace an underscore ("_") in a field with a tab?
This works but seems like suck a hack:
$ sqlite3 foobar.db 'select replace(id,"_","{tab}") from bar;' |
sed -e 's/{tab}/\t/'
I was hoping for a char(9) or similar but couldn't find anything in the docs:
I use ISO time, which is 20080916122801 as I write this. It can be stored in
integer format, is very easy to manipulate and sort.
YearMonthDateHourMinuteSecond
Brown, Daniel wrote:
>
> Good morning list,
>
> Could someone point me to the documentation regarding dates and SQLite?
> I'm having
On Tue, Sep 16, 2008 at 12:02 AM, Holger Lembke <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>> Database will grow from about 3.615 KB and continue growing.
>> After 100 more FILLs (40.000 delete+insert actions.) it
>> reaches a size of 85.683 KB.
>
> Just in case we are confused due to
Michael Schlenker wrote:
> Patrick schrieb:
>> I am a beginner to intermediate Python Programmer. I can use SQLite with
>> it just fine but it is my understanding that relational database and
>> object oriented programming our not the perfect marriage.
>
> Otherwise it does not really matter.
Hello, I am writing an application with the database layer implemented with
SQLite.NET. I am using SQLite 3.6.1 for Windows. I have 2 tables, Document and
File, where File has a foreign key to the autoincrement primary key of
Document. I enforce referential integrity using a set of foreign key
On 9/16/08, Martin (OPENGeoMap) <[EMAIL PROTECTED]> wrote:
> Mohit Sindhwani escribió:
>
> > Jeff Godfrey wrote:
> >
> >> According to a paper written by Richard Hipp (the creator of SQLite),
> >> Tcl is the ideal language. Here's a quote from the mentioned paper:
> >>
> >> "The increasing
Mohit Sindhwani escribió:
> Jeff Godfrey wrote:
>
>> According to a paper written by Richard Hipp (the creator of SQLite),
>> Tcl is the ideal language. Here's a quote from the mentioned paper:
>>
>> "The increasing popularity of SQLite is seen in the fact that the main
>> website daily
For myself, I find C and C++ to be the best for use with SQLite (and the
STL makes the set oriented nature of relational databases fit reasonably
well). Mostly though that's because those are the languages I prefer to
work in, rather than in inherent quality of the bindings. Like the man
I get a lot of miles out of Perl, 116,000 lines and counting.
On Tue, Sep 16, 2008 at 9:41 AM, Fred Williams <[EMAIL PROTECTED]> wrote:
> I haven't met a real programmer since I wrote my last TASM program quite a
> few years ago. :-(
>
> -Original Message-
> From: [EMAIL PROTECTED]
>
On 9/16/08, Patrick <[EMAIL PROTECTED]> wrote:
> I am a beginner to intermediate Python Programmer. I can use SQLite with
> it just fine but it is my understanding that relational database and
> object oriented programming our not the perfect marriage.
>
> I was just wondering if anyone had an
On Sep 16, 2008, at 12:09 PM, Jeff Godfrey wrote:
> Patrick wrote:
>> I was just wondering if anyone had an opinion on the most ideal
>> language
>> to use with SQLite?
>>
>> I love Python but I LOVE SQLite, I would learn another language
>> just to
>> use it better-Patrick
>>
> According to
I haven't met a real programmer since I wrote my last TASM program quite a
few years ago. :-(
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of palmer ristevski
Sent: Tuesday, September 16, 2008 11:19 AM
To: General Discussion of SQLite Database
Subject: Re:
Patrick schrieb:
> I am a beginner to intermediate Python Programmer. I can use SQLite with
> it just fine but it is my understanding that relational database and
> object oriented programming our not the perfect marriage.
>
> I was just wondering if anyone had an opinion on the most ideal
On Tue, Sep 16, 2008 at 12:20 PM, <[EMAIL PROTECTED]> wrote:
>> "And of course, Perl is always best. :)"
>
> Of course; but VB (VB6) is just a bit better.
>
> RBS
>
Almost fell out of my chair laughing.
But in all seriousness, if you're into ADO.Net, the System.Data.SQLite
wrapper by Robert
"Of course; but VB (VB6) is just a bit better."
YES brothers, Educate them, Educate them
For you see those 2 are actually my two main programming platforms!
Disciples go forth to educate the peoples!
P.
> Date: Tue, 16 Sep 2008 17:20:55 +0100
> From: [EMAIL PROTECTED]
> To:
> "And of course, Perl is always best. :)"
Of course; but VB (VB6) is just a bit better.
RBS
>
> "And of course, Perl is always best. :)"
>
> That's right brother!
> Educate them , Educate them i say!
>
> P.
>
>> Date: Tue, 16 Sep 2008 11:13:27 -0500
>> From: [EMAIL PROTECTED]
>> To:
"And of course, Perl is always best. :)"
That's right brother!
Educate them , Educate them i say!
P.
> Date: Tue, 16 Sep 2008 11:13:27 -0500
> From: [EMAIL PROTECTED]
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] best language match for SQLite?
>
> SQLite is written in C, and its
SQLite is written in C, and its creators seem to be fond of TCL, so
those are 2 good choices, but I don't think there is a most ideal
language for anything - it all depends on balancing what you need to do
and what you want to learn.
And of course, Perl is always best. :)
g
-Original
Jeff Godfrey wrote:
> According to a paper written by Richard Hipp (the creator of SQLite),
> Tcl is the ideal language. Here's a quote from the mentioned paper:
>
> "The increasing popularity of SQLite is seen in the fact that the main
> website daily serves about a gigabyte of data to around
Patrick wrote:
> I was just wondering if anyone had an opinion on the most ideal language
> to use with SQLite?
>
> I love Python but I LOVE SQLite, I would learn another language just to
> use it better-Patrick
>
According to a paper written by Richard Hipp (the creator of SQLite),
Tcl is
I am a beginner to intermediate Python Programmer. I can use SQLite with
it just fine but it is my understanding that relational database and
object oriented programming our not the perfect marriage.
I was just wondering if anyone had an opinion on the most ideal language
to use with SQLite?
On Tue, Sep 16, 2008 at 11:44:24AM +0200, Lothar Behrens scratched on the wall:
> Hi,
>
> I do have any unfinalized statements in my application when compiled
> on Windows, but not on Mac OS X.
>
> Is there any difference I am missing to attent for ?
>
> How could I see, wich statement
On Sep 16, 2008, at 4:44 PM, Lothar Behrens wrote:
> Hi,
>
> I do have any unfinalized statements in my application when compiled
> on Windows, but not on Mac OS X.
>
> Is there any difference I am missing to attent for ?
>
> How could I see, wich statement (statement handle or SQL query to be
>
> Another question I have is do I understand correctly that an SQLite
> database, on a network share, has no problems with many readers, the
> problem starts with many writers. Is this correct?
>
> Thanks,
> TD
Yes, you'll have problems with many writers since each network file
system
On Mon, Sep 15, 2008 at 11:49:48PM -0400, [EMAIL PROTECTED] scratched on the
wall:
> I would like to use SQLite from a network share. I would like to create a
> server app that would do all of the writing to the database except for
> certain tables, one table per client,the clients would write
On Mon, Sep 15, 2008 at 10:57:37PM -0700, Tomas Lee scratched on the wall:
> I want to delete the 1000 members with the lowest scores. Assume that
> it is extremely unlikely for two members to have identical scores.
> Also, the 1000 is arbitrary -- it could be more or less on different
> days.
2008/9/16 Aravinda babu <[EMAIL PROTECTED]>:
> Hi all,
>
.
.
.
> static const char *updateCmd = "UPDATE cert_store_table set lastRowFlag =
> :lastRowFlag where lastRowFlag = :lastRowFlag;" ;
> < same named parameter twice
>
.
.
.
> Is there
Hi all,
static const char *cmd = "CREATE TABLE cert_store_table ( certNumber
INTEGER primary key , certTypeLen INTEGER , certType TEXT , validFlag TEXT,
certData BLOB , lastRowFlag INTEGER)";
static const char *updateCmd = "UPDATE cert_store_table set lastRowFlag =
:lastRowFlag where
Hi,
I do have any unfinalized statements in my application when compiled
on Windows, but not on Mac OS X.
Is there any difference I am missing to attent for ?
How could I see, wich statement (statement handle or SQL query to be
used in that statement) is unfinalized ?
I do not have any
Aravinda babu wrote:
Hi all,
Does sqlite have any mechanism to determine if sqlite3_open has
created a new database or opened an existing database?
sqlite3_open returns SQLITE_OK for both creation and open
How can i check whether it created or opened an existing database ?
Thanks in
Hi all,
Does sqlite have any mechanism to determine if sqlite3_open has
created a new database or opened an existing database?
sqlite3_open returns SQLITE_OK for both creation and open
How can i check whether it created or opened an existing database ?
Thanks in advance,
Aravind.
[EMAIL PROTECTED] wrote:
> Database will grow from about 3.615 KB and continue growing.
> After 100 more FILLs (40.000 delete+insert actions.) it
> reaches a size of 85.683 KB.
Just in case we are confused due to European and American dots: those are
European dots.
So it reads: grows from 3 MB
I have this schema:
CREATE TABLE members
(uid INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
score INTEGER);
CREATE INDEX members_score_index ON log (score);
I want to delete the 1000 members with the lowest scores. Assume that
it is extremely unlikely for two members to have identical
On Sep 16, 2008, at 5:19 AM, Sathish R wrote:
> Hi All,
> We are using sqlite3 (version 3.2.1) in our product and we are
> experiencing
> a problem of infinite loop from sqlite3_close(). The problem is
> intermittently reproduced and I am not sure about the exact sequence.
> I have described
43 matches
Mail list logo