Hi!
I figured out a while ago, that prepared statements
(sqlite3_prepare/sqlite3_prepare16) will get invalid if database scheme
changes.
That happens also to statements that don't depend on the changed objects.
Unfortunately, sqlite3_step only returns SQLITE_ERROR in this case.
This is
Hi All,
I'm quite new to SQLite, but like it very much.
I am trying it out for an existing applicationm which seems good, but
I have one problem:
How do I get the number of rows in the result set after having called
sqlite3_prepare( ... ) ? Of course I could call sqlite3_step() until
Hello SQLite users,
I'm pleased to announce the release of SQLite Analyzer.
http://www.kraslabs.com/files/sqlanlz.exe
--
Best regards
Sergey Startsev
SQLite Analyzer - SQLite database management tool with GUI.
http://www.kraslabs.com/sqlite_analyzer.html
On Mar 11, 2005, at 10:07 AM, D. Richard Hipp wrote:
Version 3.1.5 is now available on the website. This release
fixes a typo in the previous release that caused problems
for OS-X users.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Any chance this patch (http://www.sqlite.org/cvstrac/tktview?tn=1151)
On Tue, Mar 15, 2005 at 12:21:15AM +0100, Thomas Lotterer wrote:
> On Sun, Mar 13, 2005, jed wrote:
>
> > [...] web applications fit well into the model of "many readers, one
> > writer", sqlite does this very well.
> >
> Well, there might be web applications which are read-only from the web's
>
On Sun, Mar 13, 2005, Jan-Eric Duden wrote:
> The issue 1159 was marked as "not_a_bug".
> So is there a misunderstanding?
>
Maybe. I tried hard to explain my point of view.
--
[EMAIL PROTECTED], Cable & Wireless
Re,
this solution rocks. Thanks a lot!
On Sun, Mar 13, 2005, D. Richard Hipp wrote:
> On Sun, 2005-03-13 at 16:49 -0500, D. Richard Hipp wrote:
> > On Sun, 2005-03-13 at 21:56 +0100, Thomas Lotterer wrote:
> >
> > > I cannot believe it is normal behavior of a database application
> > > running
On Mon, Mar 14, 2005 at 11:50:45AM -0700, Ara T Howard wrote:
> > > does anyone have a strategy for doing massive updates to a db and
> > atomicly> replacing it in a multi-process situation?
> >
> > Assuming you have a cgi-like application with many processes that just
> > looks up a row,
- Original Message -
From: Lothar M=E4rkle <[EMAIL PROTECTED]>
Date: Sunday, March 13, 2005 11:39 pm
Subject: Re: [sqlite] atomic db replacement
> > does anyone have a strategy for doing massive updates to a db and
> atomicly> replacing it in a multi-process situation?
>
> Assuming
On Mon, 2005-03-14 at 16:44 +0100, Jan StÃrtz wrote:
> It would be a hard job to change all my view definitions (which where fine for
> informix and oracle) to fit sqlite.
If you will write a ticket that describes the column names assigned
to views by Informix, Oracle, and PostgreSQL, I'll
On Mon, 2005-03-14 at 10:51 -0500, Mitchell Vincent wrote:
> Mitchell Vincent wrote:
> > D. Richard Hipp wrote:
> >>
> >> Can you tell me what the original schema is?
> >
> >
> > Replied in private with the schema. I'm also happy to send the custom
> > compiled DLL and the database if you need
Mitchell Vincent wrote:
D. Richard Hipp wrote:
Can you tell me what the original schema is?
Replied in private with the schema. I'm also happy to send the custom
compiled DLL and the database if you need it.
Thanks!!!
Any additional thoughts on this? I'm happy to provide any additional
Hi list,
before I open a ticket, I'd like to ask you.
I tried to use views with sqlite 3.1.5 with short_column_names
(as default within 3.x). Below is the script of my try.
As with CheckIns 2230 - 2232 (Tickets #269, etc.) I thought I
can access view elements without defining an alias. That does
[EMAIL PROTECTED] wrote:
Keep It Simple, Keep It Small Foot Print.
If the multi-access, multi writter can be implemented without compromising
these two tenets, then great. Otherwise, let's use a different RDBMS.
Jim Dodgen wrote:
Applications that need many concurrent tasks doing updates might
Keep It Simple, Keep It Small Foot Print.
If the multi-access, multi writter can be implemented without compromising
these two tenets, then great. Otherwise, let's use a different RDBMS.
Regards,
Uriel_Carrasquilla
On Fri, 11 Mar 2005, Eric Hochmeister wrote:
>Hi,
>
>I'm trying to figure out how to set the PRAGMA synchronous attribute
>to ON permanently for my database. I've read the pragma docs at
>(http://www.sqlite.org/pragma.html) and looked at the source code and
>haven't been able to figure it out.
>
16 matches
Mail list logo