On Mon, 2007-06-25 at 17:08 -0500, Andrew Finkenstadt wrote:
> How easy would it be for me to implement a "pragma page_count;" statement
> which returns the CURRENT page count of the database, and is much more
> cross-platform than my attempt to just "check the file size".
Not difficult I would th
On Sat, 2007-06-23 at 10:56 +0200, Jiri Hajek wrote:
> > The reason is as you've surmised. Not all systems have full unicode
> > support (I'm not sure, but if I had to guess, I would say very few
> > systems do). Including an implementation with SQLite would bloat
> > the library to at least severa
On Fri, 2007-06-22 at 18:57 +0200, Jiri Hajek wrote:
> Hello,
>
> I wonder whether there are any plans to include internally proper
> Unicode comparisons? Don't get me wrong, I think that it's great that
> SQLite supports custom collations, there's absolutely no problem to
> handle it in internall
On Thu, 2007-06-21 at 11:57 +0200, Andre du Plessis wrote:
> Is it possible to do this:
>
>
>
>Open DB1
>
>Attatch DB2
>
>
>
>
>
> In DB1 have a trigger that does
>
> Insert into DB2. ?
>
>
>
>
>
> Theoretically it seems possible but we couldn't get it to work. Before I
> Another question: Is it correct that virtual tables can be created using
> Perl but not Tcl? I don't have a current need (with the possible
> exception of FTS1/2, which are already accessible from Tcl), but the
> situation seemed curious. Wondering whether there was an undocumented
> capabil
> Hope that is more clear.
Perfectly. I get it now. As you say in the other post, every
sqlite call needs to be inside the critical section, including
sqlite3_finalize().
Dan.
-
To unsubscribe, send email to [EMAIL P
On Wed, 2007-06-20 at 11:05 +0200, Andre du Plessis wrote:
> Sorry if I created any confusion there were some code that seemed to
> have called
> Sqlite_reset simultaneously from more than one thread, even though the
> statements were unique for each thread the call to the library was not
> locked.
On Tue, 2007-06-19 at 11:51 -0700, Gerry Snyder wrote:
> Michael Hooker wrote:
> > Many thanks for the explanation Dan.
> Ditto the thanks.
> > I suspected the purpose of ROLLBACK was as you say, but couldn't see
> > why it was used here. You point out the "under the hood" difference
> > betwe
On Tue, 2007-06-19 at 15:39 -0400, Igor Tandetnik wrote:
> Shane Harrelson
> <[EMAIL PROTECTED]> wrote:
> > To use pragmas from code, do I simply prepare them as a regular SQL
> > statement and then execute them?
>
> Yes.
Another thing to note: Some pragmas take effect during
sqlite3_prepare(),
> My question is then, if any one connection makes any change to the database
> ( not neccesarily to the huge lookup table ) will all the other connections
> invalidate their entire cache?
Yes. The entire cache, regardless of what table was modified etc.
Dan.
On Tue, 2007-06-19 at 09:42 +0200, Roberto Davico wrote:
> Hi all,
>
>I am Roberto and I find a problem using sqlite3 (version: SQLite
> version 3.3.8).
>
>I make a sample db to explain the situation:
>
>1) Create the sample database using command line tool:
>
> sqlite> .schema
> C
On Tue, 2007-06-19 at 01:06 -0700, pompomJuice wrote:
> Hello there.
>
> I need some insight into how SQLite's caching works. I have a database that
> is quite large (5Gb) sitting on a production server that's IO is severely
> taxed. This causes my SQLite db to perform very poorly. Most of the tim
On Tue, 2007-06-19 at 10:58 +0530, anand chugh wrote:
> Hi
>
> I am having code like this:
>
>rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
>if( rc!=SQLITE_OK ){
> return rc;
>}
>sqlite3_bind_text(pStmt, 1, zKey, -1, SQLITE_STATIC);
>sqlite3_bind_blob(pStmt, 2, zBlob, nB
On Tue, 2007-06-19 at 00:46 +0100, Michael Hooker wrote:
> Christian wrote:
>
> >>Best way of doing this is to execute a 'BEGIN IMMEDIATE', copying the
> database file, then executing a 'ROLLBACK' to end the transaction.<<
>
> >>and can be safely copied at the OS level<<
>
> I also have a need t
On Mon, 2007-06-18 at 06:04 -0500, John Stanton wrote:
> Andre du Plessis wrote:
> > How can one optimize the creation of the journal file. The problem is
> > this, for our system which is an event based one each message needs to
> > be insterted and committed to the database (guaranteed), this res
On Thu, 2007-06-14 at 15:08 -0700, Joe Wilson wrote:
> Is there an SQLite 3.x equivalent document for this?
>
> SQLite 2.X Database File Format
> http://sqlite.org/fileformat.html
>
> If not, is this 2.x document worth reading as a background to
> the general structure of the sqlite 3.x file
> What exactly happens when I change the cache_size (both increase and
> decrease size)?
A variable is set.
> What happens to the data that's there in the result cache at the time
> when the instruction PRAGMA cache_size = 0 is executed?
Nothing. The aforementioned variable is set to 10 inste
On Tue, 2007-06-12 at 09:56 +0200, weiyang wang wrote:
> Hi Dr.H,
> Yes, I did a clean build in a clean directory( (top)/bld ). and i had run
> 'make clean' before i run the 'make'.
>
> i am wondering whether the lemon tool configuration in my environment is
> well done or not.
>
> thanks in adva
On Sun, 2007-06-10 at 16:08 -0700, Brett Keating wrote:
> Well I basically did the following, but not sure it's optimal:
>
> 1) Took 3.3.17 amalgamation
> 2) Took shell.c from 3.3.17 full distribution, and made a target that
> just uses sqlite3.c and shell.c to get the command line tool
> 3) Took
On Fri, 2007-06-08 at 09:50 +0530, Jimmy Mathew Ambalathuruthel wrote:
> Hi all,
>
> I am working in a porting project of SQLite from windows.
>
> I Could not port the Truncate () function (For Eg: WinTruncate () in
> windows code in the file os_win.c ) as the same logic cannot be applied
> t
On Wed, 2007-06-06 at 13:38 +0200, [EMAIL PROTECTED] wrote:
> > There have been some recent changes to try to address this
> > by placing various limits on number of columns, length of
> > SQL expressions, length of SQL statements etc. See:
> >
> > http://www.sqlite.org/cvstrac/fileview?f=sqlite
On Tue, 2007-06-05 at 13:35 +0200, [EMAIL PROTECTED] wrote:
> I'v read in change log that some stack allocted memory were moved to the
> heap, but I think that there is still to much allocated memory on the stack.
> After creating a table with 2000 columns, jdbc driver created a query that
> run
On Fri, 2007-06-01 at 10:51 +0100, Mark Gilbert wrote:
> Folks.
>
> My app just crashed in the field randomly after some time running fine.
>
> Thread 12 Crashed:
> 0 libsqlite3.0.dylib0x9406e587 sqlite3pager_get + 390
> 1 libsqlite3.0.dylib0x94054275 sqlite3Bt
On Tue, 2007-05-29 at 13:11 -0700, Smith1, Robert E wrote:
> Hi,
>
> I am trying to install sqlite3 on Sun Solaris 2.8. I am not root so I
> cannot install to /usr/local. I start configure with
> --prefix=/ptmp/usr/localto try to get it to install to a different
> directory. But I get the sa
erform db access. And all clients are queued and blocked upon the
> single threads message queue.
>
> Thanks,
> Ken
>
>
>
>
> Dan Kennedy <[EMAIL PROTECTED]> wrote:
> > Which in that case whats the point of a shared cache?
> > What
> Which in that case whats the point of a shared cache?
> What is it shared against, since all threads must send
> data to the shared server anyways and none may access
> it concurrently.
The idea is to have a single cache shared accessed by
more than one logical connection (read: more than one
On Thu, 2007-05-17 at 18:26 -0400, Martin Gentry wrote:
> Can you be a bit more specific? :-) I ask because this is immediately
> relevant to some code I'm writing today, and have been operating on the
> understanding that I should honour the restriction. I'm fine with honouring
> the restrict
On Thu, 2007-05-17 at 16:54 +0200, Jiri Hajek wrote:
> > The Unicode standard is beside the point. There is lots of code
> > that does not handle charsets and encodings correctly, which can
> > open vulnerabilities to metacharacter injection. (Examples of
> > this class of problem are SQL injection
On Wed, 2007-05-16 at 11:39 +0530, B V, Phanisekhar wrote:
> Igor,
>
> Assume I have a database of the files/folders.
>
> Let it be
>
> Rowid puid
> 1 1
> 2 2
> 3 3
> 4 5
> 5 7
> 6 8
> 7 10
>
> Assume I have a relation table showing which file is in which folder
>
>
On Tue, 2007-05-15 at 17:24 -0700, Mike Johnston wrote:
> Absolutely but it seems like duplicate effort if sqlite already has the info.
> Any guess if this is a big deal to put into the source?
Not a big deal at all. But there's no real advantage
to putting this in the core. And it would add a f
On Tue, 2007-05-15 at 13:47 +0530, B V, Phanisekhar wrote:
> Hello all,
>
> When I try to prepare the stmt for the query "PRAGMA
> cache_size = ?" I am getting an SQLITE_ERROR.
You can only use '?' in place of an SQL expression. PRAGMA
commands take a literal string, identifier or nu
On Sat, 2007-05-12 at 08:02 -0700, Mike Johnston wrote:
> When doing a "select * from foo" and using sqlite3_step() with
> the associated sqlite3_column_xx funcs, is the order of the
> columns in the resultset deterministic?
>
> What is the rule that defines what the order?
> it seems to be th
On Wed, 2007-05-09 at 16:18 -0700, Jon Scully wrote:
> Simpler than that. I merely want to attach to two databases (files).
> flash.db contains a set of tables that hold non-volatile data; ram.db
> contains a set of tables that is re-built (volatile) on re-boot -- but
> offers fast, read-only acce
On Mon, 2007-05-07 at 12:28 -0700, km4hr wrote:
> Notes on how I got sqlite running on hpux 11.0
>
> To install sqlite on hpux:
> * download sqlite-3.3.17.tar.gz from web site.
> (I unzipped the file on linux using gunzip I think. Then copied
>the tar file to /opt on the unix box. I guess gu
On Tue, 2007-05-08 at 10:45 +0700, Kirill wrote:
> Good day,
>
> SQLite version 3.3.17
> Enter ".help" for instructions
> sqlite> create table tbl1(t1 varchar(10));
> sqlite> insert into tbl1 values('софт'); - lowChar
> sqlite> insert into tbl1 values('СОФТ'); - upChar
> sqlite> select * from tbl1
On Fri, 2007-05-04 at 18:22 -0400, Vitali Lovich wrote:
> Hi,
>
> I was wondering what would be the optimal way to select 1 matching row
> from multiple tables. Here is the scenario.
>
> Multiple tables contain a primary key KEY. If Table1 contains a
> matching KEY, then I want that row from
> It seems like the use_up_files command must work sometimes, since
> several iterations of the test worked (i.e. 6.1.1 and 6.1.2). I'm not
> sure what to make of the sequence of test failures and successes before
> it finally hangs.
>
> Since the comment indicates that this test is designed f
On Fri, 2007-04-20 at 10:13 +0200, Jens Miltner wrote:
> Am 20.04.2007 um 09:13 schrieb Jens Miltner:
>
> >
> > Am 01.04.2007 um 20:05 schrieb Iulian Musat:
> >
> >>
> >> [EMAIL PROTECTED] wrote:
> >>> [...]
> >>> In past releases of SQLite, we have made available a ZIP archive
> >>> with preproce
On Thu, 2007-04-19 at 13:29 -0500, David A O L wrote:
> I have a very basic sql statement, mainly Im printing it...
>
> static int GuardaActividadEnArchivo(void *arg1, int argc, char **argv, char
> **azColName){
> int i;
> char *nombre, *ok, *ko, *actividad;
> nombre = ok = ko = activi
On Wed, 2007-04-18 at 10:06 -0400, Joel Cochran wrote:
> OK, then I won't be worrying about Transactions for SELECT statements, it
> doesn't really apply to our application.
>
> And some additionaly confirmation that Christian seems to have been right on
> key: according to the problems reported a
On Wed, 2007-04-18 at 11:06 +0100, Alberto Simões wrote:
> On 4/17/07, Alberto Simões <[EMAIL PROTECTED]> wrote:
> > On 4/17/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > > "=?ISO-8859-1?Q?Alberto_Sim=F5es?=" <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Consider the following database schema:
> At first I thought this had solved the problem, because all in house testing
> runs beautifully. However, as soon as the device is sent to the field, the
> error starts again. Unfortunately, it means that I have never been able to
> catch this in debug. I did, however, change the error reporti
On Tue, 2007-04-17 at 11:53 +0100, Alberto Simões wrote:
> Hi
>
> I've found SQLite faster than MySQL and Postgres for small/medium
> databases. Now I have big ones and I really do not want to change, but
> I have some performance issues.
>
> Consider the following database schema:
> CREATE TABLE
On Tue, 2007-04-10 at 09:26 -0700, Scott Hess wrote:
> On 4/10/07, Dan Kennedy <[EMAIL PROTECTED]> wrote:
> > I checked the code and conflict handling mechanisms (OR ERROR,
> > OR ABORT, OR REPLACE) do not apply to virtual tables.
>
> > Something to think about
On Mon, 2007-04-09 at 13:02 -0700, Scott Hess wrote:
> Thanks for the concise report. I'm going to take a look at this
> today, to see if it's an fts1/2 problem. If it's _not_, I'll still
> look at it, but perhaps with less eventual success :-).
I checked the code and conflict handling mechanism
On Fri, 2007-04-06 at 13:22 -0700, Mike Johnston wrote:
> Hi,
> Is it possible to have memory databases located at a specific memory
> address? I have a battery backed memory I'd like to store specific
> information apart from the main database.
Not really possible at the moment.
An in-memory d
failing for? And are
there any other SQL statements from the same handle active at the
time? Definition of active: have called step() but not finalize()
or reset().
Thanks,
Dan.
> Regards,
> Werner
>
>
>
>
> Dan Kennedy-4 wrote:
> >
> > On Thu, 2007-04-05 at
On Thu, 2007-04-05 at 04:04 -0700, pompomJuice wrote:
> Ok.
>
> I went and re-prepared the statement anyway even though the documentation
> says it won't work. This trick only works if you finalize the failed
> statement after the step command. Otherwhise you keep on getting
> SQLITE_SCHEMA errors
On Wed, 2007-04-04 at 23:36 -0400, Rich Rattanni wrote:
> On 4/3/07, Rich Rattanni <[EMAIL PROTECTED]> wrote:
> > All:
> >I was wondering exactly how SQLite handles freeing memory used
> > from the heap when compiled without SQLITE_ENABLE_MEMORY_MANAGEMENT?
> >
> >Will absolutely no memory
> exclusive2-1.7...
> Expected: [1]
> Got: [2]
> exclusive2-1.9...
> Expected: [1]
> Got: [0]
> exclusive2-1.10... Ok
> exclusive2-1.11... Ok
> exclusive2-2.1... Ok
> exclusive2-2.2... Ok
> exclusive2-2.3... Ok
> exclusive2-2.4... Ok
> exclusive2-2.5...
> Expected: [5]
> Got: [3]
>
On Wed, 2007-03-28 at 11:11 +0200, Jonas Sandman wrote:
> Yes, it seems so.
>
> Still, can this be done without knowing how many extensions there are on
> beforehand?
> what happens if I make a
>
> SELECT * FROM Files WHERE extension IN (:ext1, :ext2, :ext3, :ext4) and only
> bind :ext1 but not t
> I am trying to use this query:
>
> SELECT * FROM Files WHERE extension IN ('mp3','avi','ogg');
>
> I am not getting any row back though.
>
> SELECT * FROM Files WHERE extension='mp3' works though.
If this is literally the case, it's probably a bug.
> I am using sqlite3_step to execute a pre
On Wed, 2007-03-28 at 12:27 +0530, Lloyd K L wrote:
> Hi,
> My table contains a text field called Name. Let the data be
>
> Name
> ---
> Abc
> abcd
> AB
> cab
> def
>
> I want to selcct all the rows which contains the term ab (not case
> sensitive). How can I do this?
SELECT name FROM "My
On Mon, 2007-03-26 at 17:08 +0200, Vivien Malerba wrote:
> On 3/26/07, Martin Jenkins <[EMAIL PROTECTED]> wrote:
> > Vivien Malerba wrote:
> > > Hi!
> > >
> > > I've got an error reporting problem when trying to insert a row which
> > > breaks a UNIQUE constraint in a table in a C program, I get th
I think you need 3.3.8 or greater.
On Mon, 2007-03-26 at 07:39 +0200, stephan nies wrote:
> I am using sqlite 3.3.5 .
>
> On 3/25/07, Eric Pankoke <[EMAIL PROTECTED]> wrote:
> >
> > What version of SQLite are you using? I'm not sure the IF EXISTS option
> > was present until a certain version o
On Fri, 2007-03-23 at 18:53 +0100, stephan nies wrote:
> Hi I read about a "strict affinity mode"
> on http://www.sqlite.org/datatype3.html.
>
> But from searching the net, i get the impression
> that this mode is not yet implemented.
>
> I think it seems to be a FAQ since it is even listed
> in
On Tue, 2007-03-20 at 02:44 +0200, Rafi Cohen wrote:
> Hi, I'm calling system from a C application in order to invoke sqlite3
> database, then continue with commands: .separator "," and .import file
> table, all in a single string as argument to system.
> sqlite3 is indeed invoked with the correct
> My Intentions are towards exploring the reason behind these differences; and
> what can be
> done to counter these performance differences. I'm seeking some pointers
> from the Community.
Version 3 has a different default safety-level (default FULL) to
version 3 (default NORMAL). So if you did
On Mon, 2007-03-12 at 10:51 +0100, Jef Driesen wrote:
> I was planning to use the sqlite3_update_hook function to notify my GUI
> about changes. The idea was that every part of the GUI can update itself
> when a database change is detected. But during testing, I encountered
> some problems with thi
ase of each connections are irrelevant ?
Shared cache mode does not apply to :memory: databases. It is not
currently possible for more than one database handle to access a
single in-memory database.
Dan.
> Regards,
>
> 2007/3/10, Dan Kennedy <[EMAIL PROTECTED]>:
> > On Sat, 20
On Sat, 2007-03-10 at 14:11 +0900, Brownie wrote:
> Hi,
>
> I have two questions about shared cache mode of SQLite.
>
> 1. When is shared cache of SQLite deallocated?
> A last call of sqlite3_close()? Or end of thread procedure?
The former. The shared cache (and shared schema) are reference
cou
On Sat, 2007-03-03 at 19:18 -0500, Mitchell Vincent wrote:
> I found the nifty ODBC driver for SQLite and have been trying to use
> it to replace a 2.8 SQlite implementation in some desktop software.
> It's working very well except for a rather large problem of not being
> able to call the last_id
On Thu, 2007-03-01 at 15:13 -0800, jp wrote:
> Hi, I have a custom collation sequence (e.g.
> mycollate). Are there any advantages in terms of
> performance of declaring this collation at the table
> level, instead of just at the index level?
>
> For example, if I have:
>
> CREATE TABLE peopl
On Thu, 2007-03-01 at 05:35 +0100, daan wrote:
> I'm compiling a SQL statement (consisting of multiple statements separated
> by semicolons) using sqlite3_prepare_v2 into a series of sqlite3_stmt
> pointers, later to be executed with sqlite3_step().
>
> A statement such as:
>
> DROP TABLE IF EX
On Wed, 2007-02-28 at 13:13 +0100, Pavan wrote:
> Hi Lucas,
>
> >Shouldn't it be "sqlite3_open16(L"test.db",&db)" ?
>
> I tried this call. It works. But, the db file is created only with the first
> character name
> and the extenstion is also missing. (its like 't')
>
> Also, can you point to me
On Tue, 2007-02-27 at 10:48 +0100, Michael Schlenker wrote:
> Hi all,
>
> for some uses its nice to query the PRAGMA and the sqlite_master table
> with a single query instead of multiple PRAGMA statements.
>
> Could the Pragmas to query the database schema be converted to virtual
> tables? (tha
On Mon, 2007-02-26 at 17:05 -0800, Travis Daygale wrote:
> I'll do that. I was troubled enough by that bug report and this new testing
> info to be so motivated. :-)
This would be handy for Tcl developers.
In case you haven't noticed it yet, the SQL quote() function
in func.c will help with th
On Mon, 2007-02-26 at 09:15 -0500, Samuel R. Neff wrote:
> The SQLite optimization faq [1] mentions a PRAGMA default_temp_store which
> should set temp_store on a per-database level. However this doesn't seem to
> be correct--the official docs [2] don't mention default_temp_store and
> calling "PR
On Mon, 2007-02-26 at 11:37 +0100, Jakub Ladman wrote:
> > It's seems a bit strange to me that Makefile.linux-gcc includes tcl in
> > the build by default, but it does. Maybe that should change...
> >
> > If you add "-DNO_TCL" to the OPTS variable in Makefile.linux-gcc this
> > error should go away
On Sun, 2007-02-25 at 22:48 +0100, Jakub Ladman wrote:
> Dne neděle 25 únor 2007 19:25 Martin Jenkins napsal(a):
> > Jakub Ladman wrote:
> >
> > You want "make -f Makefile.linux-gcc"
> Oh, of course, sorry.
>
> And how to fix this?
>
> [EMAIL PROTECTED] ~/src/sqlite-3.3.13 $ make -f Makefile.linu
> I'm quite interested in hearing people's reasoning for going the blob route,
> when you have a perfectly good "database" format for "blobs" already (various
> filesystems).
Three technical reasons for me personally:
* Can include blob operations as part of atomic transactions.
* In SQLite
On Tue, 2007-02-20 at 00:29 -0500, Jim Crafton wrote:
> If I have a simple table without an index column, and have multiple
> rows with the same data, is it possible to *only* delete one row? In
> other words, is there anything like the LIMIT syntax that's found in
> the SELECT command for DELETEs?
On Sat, 2007-02-17 at 00:38 -0800, Tom Olson wrote:
> Hello,
>
> If a REPLACE INTO statement is executed and the there is an existing row
> that is replaced will sqlite3_last_inserted_rowid return the rowid of the
> record that was changed?
REPLACE INTO doesn't change records. It replaces them. W
I think with a virtual table all you can do is:
SELECT * FROM vtable WHERE x = 'a' UNION
SELECT * FROM vtable WHERE x = 'b'
Virtual tables cannot supply an index for WHERE clauses of the form
"x IN ('a', 'b')" or "x = 'a' OR x = 'b'" the way normal tables
can.
Dan.
On Fri, 2007-02-16 at
On Thu, 2007-02-15 at 11:49 +0100, Pavan wrote:
> Hi,
>
> Can anyone tell me what is the difference between sqlite and sqlite3.
By itself, "sqlite" probably means SQLite version 2. Same concept as
version 3 - a client library to access an SQL database stored in a
single file -, but a different fi
> wxString getDBVersion = "PRAGMA user_version = 2;";
> rc = (sqlPrepareAdd)(newdb,getDBVersion.c_str(),getDBVersion.length(),
> &pStmt, &pzTail);
>
> if(rc != SQLITE_OK){
> wxString msg;
> msg.Printf(wxT("Can't process database:
> %s"),(sqlErrMsgAdd
On Tue, 2007-02-13 at 16:18 +, Paul Simpson wrote:
> rc = (sqlStepAdd)(&pStmt);
rc = (sqlStepAdd)(pStmt);
-
To unsubscribe, send email to [EMAIL PROTECTED]
On Tue, 2007-02-13 at 11:58 +0200, DragonK wrote:
> Hi,
>
> I have a table containing a text field, which is UTF-8 encoded data. I want
> to know if I use sqlite3_column_text16() to retrieve the contents
> of the field, would the data be automatically converted to UTF-16, or would
> the character
On Sun, 2007-02-11 at 22:38 -0800, tolson wrote:
> Hello,
>
> I just finished reading through the help files and I am unclear as to when
> database should be used to prefix the pragma call (i.e. PRAGMA
> [database.]cache_size;).
For pager pragmas not specifying a database where it is optional is
; like ':memory:2'? Nothing that I've tried works.
> -Dave Gierok
>
> -Original Message-
> From: Dan Kennedy [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 07, 2007 9:56 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ATTACH and :memory: da
On Wed, 2007-02-07 at 09:37 -0800, Dave Gierok wrote:
> I would like to attach a :memory: database to another :memory: database. How
> is this possible since the ATTACH command requires the database's file name?
>
> ATTACH [DATABASE] database-filename AS database-name
>
> -Dave Gierok
I don't
On Sat, 2007-02-03 at 00:53 -0600, P Kishor wrote:
> how do I add a constraint to a column so neither null nor empty
> strings ("") are allowed?
>
create table tbl(col CHECK (col IS NOT NULL AND col != ''));
-
To un
On Thu, 2007-02-01 at 21:18 +0100, Info wrote:
> If I use the following inner join of 3 tables:
>
> SELECT T1.A
> FROM(T1 INNER JOIN T2 ON T1.A=T2.A) INNER JOIN T3 ON T1.B=T3.B
>
> SQLite returns an error message saying that the column T1.A does not exist.
> If I run this statement on MysQL,
On Wed, 2007-01-31 at 20:04 -0600, Jay Sprenkle wrote:
> On 1/31/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > > Please pick a pseudo algorithm of your choice and give us the ability to
> > > seed it?
> > >
> >
> > You already have this capability. Use the redefinably I/O feature
> > to
The basic rule is that the result of any comparison involving a
NULL value (including comparing against another NULL) is NULL.
See the following for the details:
http://www.sqlite.org/nulls.html
Dan.
On Tue, 2007-01-30 at 16:41 -0800, Clark Christensen wrote:
> I've read through numerous discu
On Mon, 2007-01-29 at 19:26 -0300, Brodie Thiesfield wrote:
> Does sqlite support numeric literals in hexadecimal?
> e.g.INSERT INTO table(mask) VALUES (0x);
I don't think so.
> Additionally, is there a constant like MAX_INTEGER defined which I can
> use as the maximum value that an INTEGER f
On Fri, 2007-01-19 at 11:42 +0800, LuYanJun wrote:
> The next question is that if I want to use multi-thread in sqlite, so
> I need to open same database for two times, right?
Right. Each thread has to have it's own sqlite3* handle.
> - Original Message -
> From: "LuYanJun" <[EMAIL PRO
On Thu, 2007-01-18 at 11:21 -0800, mikpol wrote:
> Hi,
>
> I got a weid behavior while writing some triggers. It would be best to show
> it using an example. Basically, I have two tables A and B. When something is
> inserted into A, it is inserted into B with a trigger using the rowid of
> newly i
On Sat, 2007-01-13 at 23:55 -0800, Peter James wrote:
> Hey folks...
>
> I have a situation that caused me a little head-scratching and I'm wondering
> if it's intended behavior or not.
>
> I'm running a server thread (roughly based on test_server.c in the distro)
> on top of the 3.3.6 library.
On Sat, 2007-01-13 at 10:03 +0100, Marco Bambini wrote:
> I am sorry if the question is too obvious but I haven't found any
> documentation about the SQLITE_ENABLE_LOCKING_STYLE macro (it is in
> os.c).
> Should I set it to 0 (default) or 1?
> I need to be able to access database files located
On Thu, 2007-01-11 at 15:00 -0800, ohadp wrote:
> here's the detailed description of the apparent bug:
>
> i'm using the _16 versions for getting text from an fts1 table.
> if i insert data and select, i get good data, meaning my call to
> sqlite3_column_text16(..) returns a pointer to a UNICODE
On Thu, 2007-01-11 at 21:47 -0500, Dan Cooperstock wrote:
> I have a slightly unusual situation in my database design. Several of my
> tables have primary keys composed of two integer fields, such as customerid
> and year. The customerid should be an Autoincrement field, in the sense that
> when a
I don't think so. The master journal file is created (and also
deleted, unless a crash occurs) during the final commit
processing (i.e. during sqlite3_step() of COMMIT). Up until
that point there's no special processing for multi-database
transactions.
I'm wondering if attaching a database in t
On Tue, 2007-01-09 at 22:28 -0500, Mark Richards wrote:
> Using sqlite in our embedded device has offered tremendous capabilities
> and very conveniently, and I thank the developers and enthusiasts who
> continue to further this excellent project.
>
> I've had one issue that I cannot explain and
On Tue, 2007-01-09 at 08:01 -0800, Peter James wrote:
> On 1/9/07, Dan Kennedy <[EMAIL PROTECTED]> wrote:
> But it looks to me like commit #3341 (August 2006) covers this
> up. #3341
> changes things so that the shared-schema is reset whenever any
&g
On Mon, 2007-01-08 at 16:03 -0800, Peter James wrote:
> Hey folks...
>
> The context of this message is sqlite library version 3.3.6, using the
> shared-cache mode, effectively following the test_server.c example.
> Immediately upon switching to shared-cache mode we started seeing errors
> like so
On Mon, 2007-01-08 at 06:55 -0800, jfbaro wrote:
> Hi,
>
> We need to use a trigger to update the column sync into a table when any
> column is changed (except the sync column itself), so by looking in the
> SQLite website we came across that:
>
> CREATE TRIGGER syncTransactions AFTER
> UPDATE OF
--- Martin Jenkins <[EMAIL PROTECTED]> wrote:
> James. L wrote:
> > hello,
> >
> > i just notice something strange in sqlite. i have a db
> > file which is a copy of another one(not a symlink).
> Seems very unlikely to be an SQLite (or a Debian) problem, it sounds
> like an inadvertent hard lin
What sqlite versions, OS etc.? This worked for me:
$ sqlite3
SQLite version 3.2.8
Enter ".help" for instructions
sqlite> create table abc(a, b, c);
sqlite> .output out.txt
sqlite> select * from sqlite_master;
sqlite> .quit
$ cat out.txt
table|abc|abc|2|CREATE TABLE abc(a, b, c)
>
> How do I d
To my knowledge SQLite can only store text using UTF-8 or UTF-16
encoding.
I guess in some circumstances the latin1 representation
would be more compact than UTF-8, but if that's an issue for
you then you would probably want to apply some kind of external
compression algorithm to your strings an
1301 - 1400 of 1526 matches
Mail list logo