-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/19/2010 07:31 AM, Benjamin Peterson wrote:
> I was curious if there's a reason why BINARY as a column type doesn't produce
> a
> column without a type affinity like BLOB. This would be one less special case
> between SQLite and other RDMS.
The
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/11/2010 10:28 PM, Kirk Clemons wrote:
> I would like to be able to tell SQLite that if line 2 is bad just skip to
> line 3 and so on until the database has been parsed all the through
> maximizing the amount of data I retain.
It would require
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/11/2010 12:12 AM, Rosbicn wrote:
> ... sqlite3_initialize() ... sqlite3_shutdown() ...
Why are you calling these functions - ie what do you hope to achieve?
Unless you are in a very small device, or doing behind the scenes
infrastructure, or us
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/08/2010 09:17 PM, David Barrett wrote:
> Right now I'm just doing a copy of the live file and then running .dump on
> the copy,
I suggest you use the backup API which will handle all your issues. The way
it works is that you start the backup w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/04/2010 11:39 AM, Chris Hare wrote:
> I have 3.6.12 in use. So how do I get around this error message> It
> prevents part of my code from executing
Easy - do no create SQLite objects (connections, cursors) in one thread and
use them in anothe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/02/2010 07:42 AM, Kirk Clemons wrote:
> I have seen some information on repairing a corrupt database and recovering
> at least some of the data. But I have not had any luck finding out how to do
> it.
You can use .dump in the shell. It does a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/02/2010 08:24 AM, Black, Michael (IS) wrote:
> Would it be possible to have SQLite tell you "not enabled" for any functions
> that are not compiled in?
No because to do that it would have to compile in extra code to produce the
"not enabled" me
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/2010 10:14 AM, Artur Reilin wrote:
> On the end of this site:
> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
>
> Is an error with the entities.
It is a just a Russian spammer and I've removed the text. The wiki pages
are not part of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/2010 08:47 AM, Nikolaus Rath wrote:
> Since in this
> case the file names are just opaque labels without any relations or
> structure, hashing them all was a pretty good solution.
I think it is rare that would work as a way of obfuscating SQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/31/2010 07:28 PM, Nikolaus Rath wrote:
> Possible use case: I want to send someone an SQLite database with my
> data, so that he can debug an application that's using the database
> (since it's having problems with the particular set of data that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/30/2010 08:00 AM, Tim Romano wrote:
> Several things might be responsible for there being no "outpouring of
> support" for a raw reverse function.
Also note that you are proposing it as a very specific workaround for a
specific scenario which is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/28/2010 07:37 AM, Ben Harper wrote:
> then it would be great if the xUpdate function could inform one that only the
> field 'age' is being altered. As it is now, every field is fed to xUpdate,
> causing a circumventable read/verify/write burden
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/27/2010 05:48 AM, Gilles Ganault wrote:
> Found it: For newbies like me... "table" is a reserved name so cannot
> be used as a name to table:
You can if you quote it. Note use double quotes to quote table & column
names, single quotes for strin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/27/2010 01:52 PM, Alexey Pechnikov wrote:
> Why difficulty?
I meant supporting any possible pragma, without having to hard code a list
of column names for each one. Implementing your approach and using virtual
tables both require knowing the c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/27/2010 11:36 AM, Alexey Pechnikov wrote:
> I did write pragmawrapper extension
I had also considered doing one. The approach I would have taken is using
virtual tables where you could supply the pragma statement as the first
parameter to the t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/27/2010 07:07 AM, Tim Romano wrote:
> I will consider it progress if we could get beyond the two stock replies:
> "you should do that in your application" and "you could do that in an
> extension".
You seem to think I am sort of gatekeeper of w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/26/2010 12:17 PM, Tim Romano wrote:
> But Roger, the "layer sitting in front of SQLite" is a programming
> environment which provides its own (black-box) connectivity to SQLite, and
> it isn't going to be calling any DLL into which one will hav
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/26/2010 06:03 AM, Tim Romano wrote:
> The goal is to expose the UDF to the "layer sitting in front". Are you
> saying sqlite3_auto_extension allows me to run a program, once, that will
> register a piece of code that is loaded whenever ANY OTHE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/25/2010 07:08 AM, Tim Romano wrote:
> Something that can be knocked out in a half-hour
Nothing gets banged out in half an hour with SQLite :-) Using a string
reverse example:
- - The code has to be hooked in various places
- - The function has
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/24/2010 05:38 AM, ve3meo wrote:
> I am a humble user of the command line implementation and of various SQLite
> managers and not an application developer so I cannot do it in code.
You are coding! The command line tool is merely a thin wrapper
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/24/2010 04:42 AM, Tim Romano wrote:
> Quite a few users of SQLite these days are not wrapping
> the SQLite libraries in their own client app but are communicating with the
> database via a bridge as if it were a remote server engine.
Yes, but th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/23/2010 07:47 PM, ve3meo wrote:
> Is it possible to store the results of a PRAGMA statement, especially PRAGMA
> database_list in a SQLite temporary table using only SQLite commands?
No. Is there any particular reason your code can't copy them
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/21/2010 08:01 PM, Darren Duncan wrote:
> Simply substituting in 3.7.0 causes a few new test failures for me with the
> Perl
> binding, DBD::SQLite, citing "disk I/O error".
I can't speak for the Perl binding, but some of the underlying error
h
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/21/2010 12:22 PM, Aleksander Morgado wrote:
> Now, apart from the issue above, is there any other method to know if a
> precompiled statement expired? I see that sqlite3_expired() is marked as
> deprecated, so what would be the equivalent?
The t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/19/2010 07:50 AM, Sam Carleton wrote:
> How expensive is doing a PRAGMA database_list?
17.
Without context numbers are useless. The internal implementation involves
traversing data structures and populating the VDBE so that you get the right
a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/17/2010 09:51 PM, Peng Yu wrote:
> I import a tab-sep file and create index on it. It seems that sqlite3
> only use 1 CPU. Is there a way to make it use more than one CPUs?
What kind of speeds are you seeing, and what do you think you would see
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/13/2010 05:30 PM, Jim Wilcoxson wrote:
> I don't think this would work, because the problem described is that the
> writes aren't making it to disk. If pages don't make it to disk, the old
> pages will be present, with the old, and valid checks
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/13/2010 04:57 PM, Simon Slavin wrote:
> One on each page and one for the entire file that checksums the page
> checksums ?
One for each page plus one of the header would make the most sense, but the
overriding concern would be something that is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/13/2010 12:59 PM, D. Richard Hipp wrote:
> You are encouraged to submit comments, insights, criticism, and
> analysis to this mailing list. Thanks.
Have you considered adding internal checksums to SQLite files so that at the
very least corrup
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/12/2010 08:53 PM, Nicolas Williams wrote:
> On Mon, Jul 12, 2010 at 08:43:32PM -0700, Roger Binns wrote:
>> Earlier you were trying to optimise out calls to getpid() and now you want
>> every SQLite function source to be changed
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/12/2010 02:59 PM, Nicolas Williams wrote:
> You can return an error to the caller too.
That would require substantial surgery to SQLite. Almost every routine
acquires and releases locks so they would have to be changed along with
SQLite mutex
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/12/2010 12:07 PM, Eric Smith wrote:
> I don't think the devs would complain about that. "This code has too
> few lines!"
They also have to have signed paper copies dedicating the code to public
domain and acknowledging the right to do so. That
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/11/2010 10:36 PM, zeal wrote:
> how about (tableId=? or tableId=? or tableId=? or tableId=?)
> just convert IN to or.
Jay already mentioned that approach. The downside is you have to know how
big the list is in advance and construct SQL text wi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/11/2010 06:42 PM, Sam Carleton wrote:
> Is there any way to bind to this query?
>
> SELECT * FROM table WHERE tableId IN ( ? );
>
> Where ? should be 1,2,3,4
There is no C api that allows for binding a list so you'll have to pick an
alternativ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 01:54 AM, Ian Hardingham wrote:
> And here is my query (written in a script language):
Are you actually getting correct answers from this?
> upper('?')
Unless your script language includes a SQL parser, that does not do what you
thin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/10/2010 07:12 AM, Eric Smith wrote:
> Your wrapper is nice -- have you considered folding something like it
> into the core (disabled by default, enabled by a compile-time flag) and
> submitting it to drh for official adoption?
DRH and the d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 02:31 PM, Nicolas Williams wrote:
> The trick to making that go fast is to use pthread_atfork() to get the
> new PID on the child side of fork() and store the PID in a global
> variable so that you don't need to call getpid().
That assum
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 01:52 PM, Eric Smith wrote:
> What do you mean, "immediately"? As I said, my child comes to life,
> does some work without touching (its copy of) existing SQLite strucures,
> and then calls exit(2).
I'll bet you are actually getting exi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 10:54 AM, Eric Smith wrote:
> My question came purely from a mild curiosity. I was wondering about
> the behavior of sqlite call sqlite3_bind_text when it is passed a range
> of BYTES that includes nulls.
bind_text and bind_blob use t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 09:30 AM, Jay A. Kreibich wrote:
> They can't be stored as text values without some type of encoding
> (like base64), but they can be stored as BLOBs.
Nulls can be stored in text values. Behind the scenes SQLite treats strings
and b
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 09:24 AM, Kavita Raghunathan wrote:
> 1. Is this an issue for storing in database ? If strcpy is used anywhere,
> it would be a problem
SQLite quite happily stores/retrieves null bytes in strings. It is part of
my test suite. If you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/26/2010 10:18 PM, Bill Webster wrote:
> My use case is long-lived C++ application, which invokes millions of worker
> threads during its lifetime.
Making my point about Windows application design rather well :-)
> My C++ objects do "clean up af
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/26/2010 09:48 PM, Bill Webster wrote:
> Closing file handles and statement handles is not particularly drastic. Not
> to be encouraged obviously, but no worse than sudden termination of the
> program or power-off.
What is it exactly that leads y
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/26/2010 07:47 PM, Bill Webster wrote:
> I meant something that released all open files, blob handles, statement
> handles etc., without terminating the process.
>
> I guess that this must've been considered and that there is a practical or
> phi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/26/2010 07:29 PM, Bill Webster wrote:
> Excuse me as an extreme newbie, but it would seem useful to have a method
> that is guaranteed to release all resources.
>
> Perhaps it exists and I just didn't see it?
It does indeed and is provided by y
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/24/2010 12:38 PM, Darren Duncan wrote:
> The test suite being AFAIK
> essentially an application that links against the already-compiled SQLite,
Not quite the case. The test suite includes large amounts of code to induce
various faults, track
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/24/2010 05:10 AM, Israel Lins Albuquerque wrote:
> I'm needing a corrupted database for test purpose, someone can help me?
> I want an database with corruption on index like:
> "rowid [%ld] missing from index %s" or "wrong # of entries in index
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/24/2010 06:08 AM, Peng Yu wrote:
> It is very common that software provide
> document in many different format. For example, python, GNU make.
Not really the case. The software that provides documentation in PDF has
usually done so because the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/23/2010 08:50 PM, Peng Yu wrote:
> Is there a way to use Shebang for sqlite3 script?
What happened when you tried it?
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.moz
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/21/2010 04:47 AM, Igor Sereda quoted Oracle:
>> The application-level behavior of the two products is identical,
I did test the Oracle version a few months ago and found that statement to
be false. Oracle know about the issues but gave the imp
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/21/2010 08:44 AM, Sam Carleton wrote:
> I know I cannot afford ...
For some reason you are assuming that your time is free and that you have no
other things to do with it (opportunity cost). That is how you should be
weighing all of this.
And
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/20/2010 08:31 PM, Sam Carleton wrote:
> So, that seems to leave a memory error in my code, which is also very
> tough to find. All the code that is blowing up is within an Apache
> Module and I am following the Apache rules very closely. To top
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/20/2010 05:55 PM, Sam Carleton wrote:
> Ok, that is what i am doing, checking the value of db and closing if
> it has a value. So why might closing the db cause a crash?
It is 99 point lots of nines percent certain that you have a programming
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/20/2010 03:07 PM, Simon Slavin wrote:
> The ppDb value is about allocating memory. It's possible that the file might
> be open and no memory allocated. Or that memory was allocated and the file
> not opened. I forget which.
>
> Instead chec
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/17/2010 01:50 PM, Simon Slavin wrote:
> Sometimes it's best to use the command-line tool to dump the data to a file
> of SQL commands,
The command line tool needs its code fixing first:
http://www.sqlite.org/src/tktview?name=2466653295
In p
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/16/2010 11:35 AM, Fabio Spadaro wrote:
> You can also determine the path and file name from the blob or should I
> create a column attached with this information stored?
You are overthinking this. A blob is just a collection of bytes in the sam
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/16/2010 04:14 AM, Fabio Spadaro wrote:
> But the next time I select a single line instead of two:
> fetchall [( 0x02CC2A30>,)]
>
> What's wrong.
Errr, nothing. Blobs are returned as buffers too. (This way you can
distinguish them from
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/15/2010 09:33 PM, Jay A. Kreibich wrote:
> Contiguous, yes, but the pages may not be in any logical order.
> The internal node pages will get shuffled as the tree is built,
> meaning you might still have a significant number of seeks.
Seek
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/15/2010 07:59 PM, Simon Slavin wrote:
> The standard assumption about SQLite is that it's faster to do your INSERTs
> first, then create the indices.
If the index is created first then the data in the table and the pages
making up the index wil
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/15/2010 08:02 PM, Igor Tandetnik wrote:
> That's just polling, really. SQLite's busy handler tries to access the
> database, sleeps a little, tries again, sleeps again, and so on. It's not
> "woken up" the way, say, a thread waiting on a mutex
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/15/2010 06:48 PM, Igor Tandetnik wrote:
> Well, what trick? There is no way I know of for another process to get
> notified of changes to the database. That is, other than polling, or a side
> channel independent of SQLite.
One way I have done
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/15/2010 02:16 PM, Simon Slavin wrote:
> An image file is just a file. If you really want to store a file in a
> database, open the file, read the contents, and store what you read in a BLOB
> field.
That is the general correct answer but not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/15/2010 01:46 PM, Fabio Spadaro wrote:
> I am developing an interface to Python 's SQLite and would it be
> you can store files in the sqlite database. To do this
> obviously need to create a blob field but how to store image files?
If you are u
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/14/2010 02:56 AM, Prakash Reddy Bande wrote:
> Our application is a simple desktop application with a simple install and run
> setup. It is not possible to tell users to apply workaround of sharing the
> drive via SMB etc.
BTW SMB won't be muc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/05/2010 08:20 AM, noel frankinet wrote:
>> I see windows 2000 as the finest os that redmont has produced. You'd
>> better not develop on the latest ms os if you want to have some
>> installed base.
Your opinion is fine, but someone has to bear
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/05/2010 04:21 AM, noel frankinet wrote:
> But in fact sqlite runs perfectly fine on windows2000
Exactly as my second paragraph says. But in the Windows 2000 time frame
applications used to install their own copies of msvcrt.dll in the system
d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/05/2010 12:01 AM, Frank Church wrote:
> and Windows 2000.
Mainstream support ended 5 years ago, and all support ends in just over
a month, no matter how much money anyone is prepared to throw at them:
http://support.microsoft.com/lifecycle/?L
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> You might be interested in NoSQL, or in databases which have no schema: every
> piece of information is a property of an object.
I do happen to use them pretty intensively, especially MongoDB, so here are
some things they do differently:
There is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/29/2010 07:01 PM, Richard Hipp wrote:
>> Good to know. Would moving to shm_open() help?
The problem is that unless the networked filesystem provides exclusive locks
that can be retained by one client only then there will always be race
conditi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/29/2010 02:01 PM, Richard Hipp wrote:
> Does anybody know if mmap() works for network files?
It does. However there is no way to ensure that everyone seeing the file
will have a consistent view of it. This is especially the case when they
are
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/26/2010 08:45 PM, Art wrote:
> There should be no reason that the openv2 statement with read_only specified
> should fail under these circumstances,
Just because you are opening the database read only does not mean that other
connections in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/26/2010 07:22 PM, Sam Carleton wrote:
> I did this search:
>
> http://www.google.com/search?q=sqlite+text+search
Thanks. I have updated the relevant wiki pages to say the information is
old and to point to the current FTS3 implementation.
> m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/26/2010 10:24 AM, Sam Carleton wrote:
> If I do opt to use FTS, which one should I be using, FTS1 or FTS2?
> According to the web site, it should be FTS1, correct?
Just as a matter of interest what part of the web site led you to those
conclusio
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/20/2010 01:21 PM, Max Cat wrote:
> Thanks. In writing the VFS, I see several function pointers that don't appear
> to have explanations. Can anyone help shed some light on what the following
> are supposed to do (and what their parameters are)?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/17/2010 06:29 AM, Samuel Adam wrote:
> Plug for outstanding feature request: DECIMAL type
Leaving the merits of the type aside, adding it would make the database
incompatible with every existing SQLite library version already out there.
That is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/13/2010 12:22 PM, Nikolaus Rath wrote:
> Where can I find the corresponding ticket? The sqlite homepage seems to
> have lost all references to the bug tracker... I know that bug reporting is
> no longer open to the public, but I hope there is sti
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/13/2010 12:56 PM, Pavel Ivanov wrote:
> Roger, '-g' flag doesn't necessarily mean SQLITE_DEBUG turned on and
> doesn't mean all debugging stuff turned on. This flag (if we're
> talking about gcc)
We aren't talking about gcc, but rather Python's
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/13/2010 06:43 AM, Nikolaus Rath wrote:
> Yeah, I'm around. I don't know what an "exact disassembly" is or how to
> provide one, but if someone tells me what to do then I'm most likely
> willing to do it.
We can test the hypothesis very easily.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/12/2010 03:23 PM, Pavel Ivanov wrote:
> pthreadMutexNotheld() checks that mutex is not held by current thread
> - if mutex is held by another thread it will return true.
Ooops, I got this completely wrong!
> Although I see that it can return fa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- From a user backtrace when SQLite is compiled with assertions on, it looks
like an assertion is incorrect. The raw backtrace is later.
pcache1Alloc() contains this code:
pcache1LeaveMutex();
p = sqlite3Malloc(nByte);
pcache1EnterMutex(
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/11/2010 11:50 AM, Matt Young wrote:
> sqlite> create virtual table if not exists words using fts3 (f1 );
> Error: near "not": syntax error
http://www.sqlite.org/cvstrac/tktview?tn=2604
To fix it requires code changes to SQLite and the SQLite
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/10/2010 04:07 PM, daksh jasra wrote:
> I have ported SQLITE over VRTX based embedded platform,
I'd suggest licensing the TH3 test suite in order to verify your port. You
could be doing something like getting an operating wrong once the database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/07/2010 04:55 PM, Raeldor wrote:
> That's interesting, I'll give that a shot. I've noticed in my dealings with
> MS Sql server, that it is very bad at using compound indexes... I hope
> sqlite is better! :)
Put "explain query plan" in front of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/07/2010 01:43 PM, Pavel Ivanov wrote:
> select() has limitation that it can be used
> only with file descriptors less than 1024.
This is rarely true and I only know of one crappy operating system that had
that limitation 13 years ago. You can s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/06/2010 04:55 PM, Matt Young wrote:
> It could be done and only adds a few bytes to the binary since the
> code would simply check the 'ignore on import setting of .mode' before
> taking error action for missing or too many columns.
The issue i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/04/2010 07:30 PM, Doug wrote:
> Sure, if the book is just a copy-paste of the website,
> that's not too helpful. But hopefully things are stated differently, or
> examples are given which can be valuable.
I picked some random spots to check:
"
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/04/2010 09:41 PM, Aron Rubin wrote:
> Most execution environments that support calling including C and
> Sqlite use a stack of frames.
C has a conceptual stack - the actual implementation does not require
one. SQLite has no such thing - the int
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/04/2010 03:50 PM, Aron Rubin wrote:
> If I could have a SQL function that returned an id of the current
> frame I could create poor man's variables.
You'll need to be more specific about what you mean here. Give an example
of the code you would
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/04/2010 02:19 PM, Jay A. Kreibich wrote:
> I invite all SQLite list members to register and participate:
OpenID - no need for yet another username and password.
I've always been mystified why these kind of books duplicate installation
instruc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/03/2010 07:47 AM, D. Richard Hipp wrote:
> Question 2: Are there other foibles that we could correct using
> sqlite3_open_v3?
I'd like the shared cache busy handling to be exactly the same as
non-shared cache. ie if the only line of code cha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/29/2010 11:10 PM, Dan Kennedy wrote:
> For those playing at home, this is an example of how to write
> a great bug report. Clear, concise explanation and a
> self-contained minimal example.
The credit all goes to Nikolaus Rath who initially repo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I prepare a statement with one binding that results in a constraint failure
(correctly). Then I reset it, clear the bindings and bind a second value.
I still get a constraint failure even though it shouldn't (it was reset).
If I prepare a new statemen
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/25/2010 09:43 PM, Navaneeth Sen B wrote:
> I just have some doubts on the licensing issues of SQLite.
SQLite doesn't have a license - it is public domain - copyright has been
waived. (Some countries claim you can't do this - allegedly Germany i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/23/2010 08:42 AM, Derek Martin wrote:
> It would be swell if sqlite3 had a -notruncate option or some such,
You do know that the code is public domain, so you can copy it, modify it,
redistribute it, use it to take over the world, charge for it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/22/2010 02:19 PM, Nikolaus Rath wrote:
> To prevent other applications from accidentally using the 32bit apsw,
> I therefore wanted to install this version under a different module
> name.
Please post your question to the python-sqlite mailing l
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/18/2010 11:03 PM, Dan Bishop wrote:
> I've written a quoting routine too, in C++. I just truncated strings at
> the first NUL character because I didn't think that SQLite supported them.
SQLite supports some weird things. In addition to suppo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/18/2010 06:37 PM, Peter Haworth wrote:
> Does Sqlite have a STDEV function? Don;t see it listed under the core
> or aggregate functions.
You can find that and many other functions in a contributed extension. See
the bottom of http://sqlite.o
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/17/2010 07:12 PM, Dan Bishop wrote:
> Newlines, backslashes, and double quotes can be included literally. The
> only other character you need to worry about is NUL.
Funnily enough I'm busy writing my own quoting routine right now (the source
ar
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/17/2010 11:57 AM, slowpoison wrote:
> I was unable to find a reference to how TEXT data types are stored in
> the db files.
2.3.1 and 2.3.2 answer that:
http://www.sqlite.org/fileformat.html#varint_format
> I want to know whether a TEXT fiel
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/17/2010 10:33 AM, Feng Tony wrote:
> It's possible to create temporary tables by running sql scripts in my
> application?
What makes you think it wouldn't work, and what failed when you tried it?
Roger
-BEGIN PGP SIGNATURE-
Version: Gnu
701 - 800 of 1461 matches
Mail list logo
