Re: [sqlite] Most appropriate Web based database? (Newbie)

On Mon, Apr 24, 2006 at 08:54:40PM -0400, Paul Malcher wrote: > On 4/24/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > > > > Keep in mind, there's *WAY* more Windows users than Linux users; that > > doesn't mean Windows is a better OS. > > > Indeed also keep in mind both Postgres and MySQL are

Re: [sqlite] Most appropriate Web based database? (Newbie)

On 4/24/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > > Keep in mind, there's *WAY* more Windows users than Linux users; that > doesn't mean Windows is a better OS. Indeed also keep in mind both Postgres and MySQL are cross platform as well. One final thought: the support you'll be able to get

Re: [sqlite] Sqlite inside MySQL as one of the pluggable "storage mechanisms" ?

On Sun, Apr 23, 2006 at 07:30:21AM +1000, John Stanton wrote: > I have actually done that and it works well for a particular class of > applications, ones with a relatively small number of simultaneous users. > For large numbers we switch to PostgreSQL The basic architecture of > Sqlite, and

Re: [sqlite] Most appropriate Web based database? (Newbie)

On Thu, Apr 06, 2006 at 04:58:43AM -0700, Lenster wrote: > 1) Googling PostgreSQL produced 52,700,000 hits, Googling MySQL produced > 397,000,000 hits I'd be much more concerned with the 'hits' you'll find at http://sql-info.de/mysql/gotchas.html ... Keep in mind, there's *WAY* more Windows

Re: [sqlite] Intermittent crash in sqlite3_prepare()

Hi Doug, This is what I see in the console: (gdb) print *db $2 = { nDb = 2, aDb = 0x177a750c, flags = 32, errCode = 5, autoCommit = 1 '\001', temp_store = 0 '\0', nTable = 1, pDfltColl = 0x1770f300, lastRowid = 0, priorNewRowid = 0, magic = -1607883113, nChange = 0,

[sqlite] SQLite on limited Memory

I've been developing an app on a linux embedded device with 128 M of RAM, although the available RAM for queries is less than that. Now that the databases are getting a little larger (120 MB), I'm having problems with some queries that have large results. I watch my memory drop completely,

RE: [sqlite] Intermittent crash in sqlite3_prepare()

What does the code look like that is calling sqlite3_prepare? The crash point is just dereferening a pointer that you passed in, and it looks like the pointer value must be bad. > int sqlite3_prepare( > sqlite3 *db, /* Database handle. */ > const char *zSql, /* UTF-8

[sqlite] Intermittent crash in sqlite3_prepare()

Hello, When I'm running several threads at the same, I sometimes get a crash in sqlite3_prepare() in the marked statement below: int sqlite3_prepare( sqlite3 *db, /* Database handle. */ const char *zSql, /* UTF-8 encoded SQL statement. */ int nBytes,

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

Hi Jens, > If you're coding against the 'standard' Win32 APIs, Windows will send > you the strings in the character encoding specified by the either > the System or the current user settings. This has nothing to do with > unicode. However, for many roman characters, the standard Windows > code

Re: [sqlite] Database is locked

Gerry Snyder wrote: Steve Bergman wrote: Yeah, I know my post was light on details and pretty general. Basically, at this point I was wondering if anyone had any general advice. Although I'm pretty sure I have seen this problem when I am the only one in the application, the application

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

Am 24.04.2006 um 14:51 schrieb COS: Hi Jens, - Original Message - From: "Jens Miltner" <[EMAIL PROTECTED]> To: Sent: Monday, April 24, 2006 5:30 AM Subject: Re: [sqlite] Using sqlite3_open or sqlite3_open16? Am 22.04.2006 um 15:48 schrieb COS: Thanks for

Re: [sqlite] Database is locked

Steve Bergman wrote: Yeah, I know my post was light on details and pretty general. Basically, at this point I was wondering if anyone had any general advice. Although I'm pretty sure I have seen this problem when I am the only one in the application, the application has been in development,

Re: [sqlite] Database is locked

Jay Sprenkle wrote: To help debug it we'd need to see the code or get a good description. Yeah, I know my post was light on details and pretty general. Basically, at this point I was wondering if anyone had any general advice. Although I'm pretty sure I have seen this problem when I am

Re: [sqlite] Database is locked

On 4/22/06, Steve Bergman <[EMAIL PROTECTED]> wrote: > Hi All, > > I was wondering if anyone here had any comments on this thread on the > Python TurboGears group: > > http://tinyurl.com/qhmyw > > Essentially, people are getting a Database is locked error from the ORM > (SQLObject). The

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

> I tried to look for some information in the MSDN, without success. I'm > starting to look at SQlite code to find out how the conversion is made and > maybe I can simulate the same process before opening the file and choose the > proper way. If I remember correctly there are different

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

Hi Jens, - Original Message - From: "Jens Miltner" <[EMAIL PROTECTED]> To: Sent: Monday, April 24, 2006 5:30 AM Subject: Re: [sqlite] Using sqlite3_open or sqlite3_open16? > > Am 22.04.2006 um 15:48 schrieb COS: > > Thanks for the info. I did have found in the

[sqlite] Recursive Query Support?

Hi, Are you planning on any Recursive Query support in SQLite at any time? Many DBMS's support this and more are doing so. For me personally it would help a great deal. Pasted below is some example explaining the workings of such a query. Greetings, Marco. Example schema:

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

Am 22.04.2006 um 15:48 schrieb COS: Thanks for the info. I did have found in the manual that UTF16 is converted to UTF8 on Windows environments. But one little question: How would one know if the filename is in UTF8 or UTF16? You see, my little application is installed in PC's all around

Re: [sqlite] Re: How to improve performance of SQL DELETE

Am 19.04.2006 um 14:08 schrieb Igor Tandetnik: Kai Wu <[EMAIL PROTECTED]> wrote: 2. The table schema is simple TABLE MID(id VARCHAR(8),scts VARCHAR(12),daddr VARCHAR(20)) the scenario is it needs first select the "id" by select id from MID where scts= .. AND daddr=... after