Re: [sqlite] cygwin and sqlite

Jim Showalter wrote: > I thought you were exaggerating, but this weekend I wrote a script for > work that used cygwin. It's unbelievably slow compared to the DOS > script it replaced, and it performs mostly the same operations as the > DOS script. Which is weird, because they wouldn't have to

Re: [sqlite] Date comparisons

Barton Torbert wrote: > Even though this is a bit more complicated, it does seem to work > correctly. > > SELECT t1.realdate1, > t2.realdate2 > from test_table_1 t1 left outer join test_table_2 t2 where > strftime ('%s', t2.realdate2) between strftime ('%s', >

Re: [sqlite] Date comparisons

Barton Torbert wrote: > What you suggested sort of worked. The problem was that the two > dates I were comparing were only 1 minute apart, but I had to put in > '-1000 minutes' and '+1000 minutes' to get the test to work. > > My two data values are; > 2009-04-13T12:19:00.000 > and >

Re: [sqlite] cygwin and sqlite

I thought you were exaggerating, but this weekend I wrote a script for work that used cygwin. It's unbelievably slow compared to the DOS script it replaced, and it performs mostly the same operations as the DOS script. Which is weird, because they wouldn't have to spawn off separate Windows

Re: [sqlite] cygwin and sqlite

Pavel Ivanov wrote: >> MacBook Mac OS X 10.5.8 >> 2 GHz Intel Core Duo >> 1 GB memory: >> 17 minutes 46 seconds. >> >> IBM ThinkPad >> Windows XP (latest patches) >> 1.70 GHz, 512 MB memory: >> 6 hours 25 minutes 57 seconds > > Windows is very slow in starting new processes if compared to any

Re: [sqlite] SQLite database on a certain high-performance "SSD"

SSDs aren't necessarily faster than disks: http://en.wikipedia.org/wiki/Solid-state_drive#Disadvantages - Original Message - From: "Mark" To: Sent: Monday, September 21, 2009 1:53 PM Subject: [sqlite] SQLite database on a certain

Re: [sqlite] List of active savepoints names

I half get his point--if it's hard to program, then only really good programmers will do it. But that argument has been made against every advance in software development since the profession began. Patchcord-pluggers made fun of switch-flippers. Switch-flippers made fun of microcoders.

Re: [sqlite] Date comparisons

Even though this is a bit more complicated, it does seem to work correctly. SELECT t1.realdate1, t2.realdate2 from test_table_1 t1 left outer join test_table_2 t2 where strftime ('%s', t2.realdate2) between strftime ('%s', datetime(t1.realdate1, '-1 minutes') ) and strftime

Re: [sqlite] Date comparisons

Richard, What you suggested sort of worked. The problem was that the two dates I were comparing were only 1 minute apart, but I had to put in '-1000 minutes' and '+1000 minutes' to get the test to work. My two data values are; 2009-04-13T12:19:00.000 and 2009-04-13T12:18:00.000

Re: [sqlite] Date comparisons

On Sep 21, 2009, at 8:00 PM, Barton Torbert wrote: > My data are dates in the format; > -MM-DD HH:MM:SS.SSS > > I am trying to use the function strftime () to convert the data to > seconds since 1970-01-01. I was hoping that within a WHERE clause > or the ON condition in an OUTER JOIN.

Re: [sqlite] Most wanted features of SQLite?: Stored procedures

On 20/09/2009, at 6:57 AM, Simon Slavin wrote: > > Ah. Okay, so in SQLite3 you can emulate stored procedures using > triggers. Just define a trigger to operate on something that > doesn't matter to you. For instance inserting a record in a table > that you never bother reading. Every so

Re: [sqlite] Most wanted features of SQLite?: Access to database structure

I would like to see some more access to the database structure via SQL calls. For instance, we can currently get the list of tables, views, indexes and/or triggers via queries to SQLite_Master. For instance, to get the name and SQL of all triggers that are initiated by MyTable, we can

Re: [sqlite] Date comparisons

My data are dates in the format; -MM-DD HH:MM:SS.SSS I am trying to use the function strftime () to convert the data to seconds since 1970-01-01. I was hoping that within a WHERE clause or the ON condition in an OUTER JOIN. What I wanted to do was something like this; SELECT

Re: [sqlite] SQLite database on a certain high-performance "SSD"

On Mon, Sep 21, 2009 at 1:53 PM, Mark wrote: > I've currently got a loaner high-performance flash-based "SSD" (let's > just say it doesn't connect to any disk controllers) that I'm testing > for performance. I've run my application against it, and I believe that > I should see

Re: [sqlite] Most wanted features of SQLite ?

On 21 Sep 2009, at 9:36pm, Fred Williams wrote: > would SQLite not work as the "back end" > for a client server (wrapper) implementation that did the multi > process (or > whatever) lock management up one level so to speak? Great question. I don't know. It requires either in-depth

Re: [sqlite] SQLite database on a certain high-performance "SSD"

Hi Mark I've had a little experience working with flash-based filesystems - I'd recommend playing with the page_size and temp_store PRAGMAs (and of course make sure you are using transactions to minimise the number of file writes) to improve performance. Cheers, Dave. -Original

Re: [sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

Ok. Simon and P Kishor. Thank very much for your response BestRegards GVS Simon Davies escribió: > 2009/9/21 Guillermo Varona Silupú : > >> Hi >> In these SQL commands: >> >> CREATE TABLE "test" ("code" char(2)); >> INSERT INTO test (code) VALUES("123") >> >> Why are

Re: [sqlite] Date comparisons

2009/9/21 Barton Torbert : > Hello, > > I am having trouble doing a rather odd data comparison. > > I have two table, each with a DateTime field.  The timestamps in these fields > do not match exactly.  I want to find the row in the second table that is > within a specific

Re: [sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

On Mon, Sep 21, 2009 at 5:10 PM, Guillermo Varona Silupú wrote: > Hi > In these SQL commands: > > CREATE TABLE "test" ("code" char(2)); > INSERT INTO test (code) VALUES("123") > > Why are allowed to keep a text of 3 characters in a field that has been > set to 2? > Is a bug?

Re: [sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

2009/9/21 Guillermo Varona Silupú : > Hi > In these SQL commands: > > CREATE TABLE "test" ("code" char(2)); > INSERT INTO test (code) VALUES("123") > > Why are allowed to keep a text of 3 characters in a field that has been > set to 2? > Is a bug? No - I suggest that you

[sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

Hi In these SQL commands: CREATE TABLE "test" ("code" char(2)); INSERT INTO test (code) VALUES("123") Why are allowed to keep a text of 3 characters in a field that has been set to 2? Is a bug? TIA BestRegards GVS ___ sqlite-users mailing list

[sqlite] Date comparisons

Hello, I am having trouble doing a rather odd data comparison. I have two table, each with a DateTime field. The timestamps in these fields do not match exactly. I want to find the row in the second table that is within a specific time period around the time period to the DateTime in the

Re: [sqlite] Most wanted features of SQLite ?

Simon Slavin wrote: > >> I definitely don't agree here as we're talking about these additional >> locks existing _only_ in memory, not on disk. > > Which requires client/server architecture. Which SQLite3 doesn't > have. Once you require concurrent access features in your DBMS (i.e. >

[sqlite] SQLite database on a certain high-performance "SSD"

I've currently got a loaner high-performance flash-based "SSD" (let's just say it doesn't connect to any disk controllers) that I'm testing for performance. I've run my application against it, and I believe that I should see numbers MUCH higher than I do. When I run my test app on a normal

Re: [sqlite] Most wanted features of SQLite ?

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Simon Slavin Sent: Monday, September 21, 2009 3:05 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Most wanted features of SQLite ? On 21 Sep 2009, at

Re: [sqlite] Most wanted features of SQLite ?

On 21 Sep 2009, at 6:53pm, Brad House wrote: > I definitely don't agree here as we're talking about these additional > locks existing _only_ in memory, not on disk. Which requires client/server architecture. Which SQLite3 doesn't have. Once you require concurrent access features in your DBMS

Re: [sqlite] Faster inserts in SQlite ...

On Mon, Sep 21, 2009 at 03:37:02PM -0400, Pavel Ivanov wrote: > > Have you any IO operations? As result you have dependence of page > > size. > > Though your performance most probably will not depend on these > operations because they will be executed at some random times by OS. > And they will

Re: [sqlite] Most wanted features of SQLite ?

Not really... Natural joins require that the column names be equivalent on each table. In my current database schema, the common practice is to use as the column name of the FK. (i.e. "CarType" to reference the "Type" column of a "Cars" table) But yea, what I'm looking for is a form of NATURAL

Re: [sqlite] Faster inserts in SQlite ...

> Have you any IO operations? As result you have dependence of page > size. Though your performance most probably will not depend on these operations because they will be executed at some random times by OS. And they will be collected to have multiple blocks in one operation anyway... I don't

Re: [sqlite] Faster inserts in SQlite ...

Hello! On Monday 21 September 2009 23:11:57 Pavel Ivanov wrote: > > Most modern FS have the same block size. > > Though I don't think that in case of synchronous = OFF there's any > benefit of using pages of the exactly same size as block in file > system. Correct me if I'm wrong. Have you any

Re: [sqlite] Most wanted features of SQLite ?

Shaun Seckman (Firaxis) wrote: > * I really would like some SQL syntax sugar that will > automatically include rows referenced by foreign keys in a table. I > haven't seen any other SQL database do this as all expect you to > explicitly include the conditions and joins

Re: [sqlite] Most wanted features of SQLite ?

Here are my most wanted features and they don't even require locking or threading fu ;) * I really would like some SQL syntax sugar that will automatically include rows referenced by foreign keys in a table. I haven't seen any other SQL database do this as all expect you to explicitly

Re: [sqlite] Faster inserts in SQlite ...

> Most modern FS have the same block size. Though I don't think that in case of synchronous = OFF there's any benefit of using pages of the exactly same size as block in file system. Correct me if I'm wrong. Pavel On Mon, Sep 21, 2009 at 2:53 PM, Alexey Pechnikov

Re: [sqlite] Faster inserts in SQlite ...

Hello! On Monday 21 September 2009 19:50:37 Pavel Ivanov wrote: > > You must set pragma page_size=4096; > > Can I ask why "must" and this number? Why not the maximum 32768? $ sudo tune2fs -l /dev/sdb1|grep 4096 Block size: 4096 Most modern FS have the same block size. Best

Re: [sqlite] Most wanted features of SQLite ?

>> It could probably benefit a large number of integrations to >> have finer grained locking even if it could not be implemented for all >> integration types. > > It makes the system a great deal slower, since you need to keep > checking all the levels of lock you have implemented. For

Re: [sqlite] Most wanted features of SQLite ?

Interesting point, Simon. Are you saying that all developers of big database engines that implemented row-level locks are just idiots because there's no benefit from it at all? They had to implement just database-level locks and all users would be a lot happier because they'd received a

Re: [sqlite] List of active savepoints names

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lukas Gebauer wrote: > I am not creating and releasing savepoints! Yes you are. The SQLite library is not magically doing them on a whim. Your code is asking for them. >> You can create a custom wrapper for savepoints which may have >> the stack

Re: [sqlite] Most wanted features of SQLite ?

On 21 Sep 2009, at 5:38pm, Brad House wrote: > It could probably benefit a large number of integrations to > have finer grained locking even if it could not be implemented for all > integration types. It makes the system a great deal slower, since you need to keep checking all the levels of

Re: [sqlite] Prepare Error from sqlite

Thank you, that fixed the problem. Kavita - Original Message - From: "Pavel Ivanov" To: "General Discussion of SQLite Database" Sent: Monday, September 21, 2009 11:33:35 AM GMT -06:00 US/Canada Central Subject: Re: [sqlite] Prepare Error

Re: [sqlite] Most wanted features of SQLite ?

>> Fine for me. It seems to be everybody else that wants their favorite >> feature imbedded in the core :-) >> >> Fine grained locking would be a great "asset" I feel. Notice I did >> not >> request a "feature." > > > On my to-do list is to write a paper that explains why fine-grain >

Re: [sqlite] Prepare Error from sqlite

> "CREATE TABLE EntityTbl (ID INTEGER PRIMARY KEY AUTOINCREMENT,AttrName > VARCHAR(50) COLLATE NOCASE,AttrEnum INTEGERAttrType INTEGER,AttrValue > VARCHAR(128) COLLATE NOCASE,ReadWrite VARCHAR(10),Entity_id INTEGER" In this sql string you're missing closing parenthesis at the end and apparently

Re: [sqlite] Index usage

Matthew, Regarding: "There's no way to optimize your query to be fast in both situations." I do *not* know if this would be of any help, but the newest 3.1.18 sqlite release which includes the SQLITE_ENABLE_STAT2 feature may possibly be of interest: (and excuse me if you've mentioned this

Re: [sqlite] Prepare Error from sqlite

Correction: The error seems to be set in sqlite3VdbeSetSql because that was the last executed statement. - Original Message - From: "Kavita Raghunathan" To: "sqlite-users" Sent: Monday, September 21, 2009 11:22:15 AM GMT -06:00

[sqlite] Prepare Error from sqlite

I just put in my sqlite wrappers and started testing. I get the following error and when I stepped into the sqlite code, its when sqlite3VdbeFinalize is called: "prepare error: near ",": syntax error" I was trying to do a "sqlite3_prepare_v2" and was using the following sqlstring and the

Re: [sqlite] Index usage

On Mon, Sep 21, 2009 at 8:27 AM, Pavel Ivanov wrote: > > There's no way to optimize your query to be fast in both situations. > LIMIT clause is pretty hard to optimize. Maybe just to have a closer > look at the application structure - maybe it's not so necessary to do > ORDER

Re: [sqlite] SQL Lite date / time functions

Alexey Pechnikov wrote: > On Monday 21 September 2009 15:59:47 Igor Tandetnik wrote: >>> Please speak is now correct to store 'start of month' dates in >>> julianday format? >> >> Was it at some point "incorrect" to do so? Yes, you can store any >> date in julian day

Re: [sqlite] Faster inserts in SQlite ...

> You must set pragma page_size=4096; Can I ask why "must" and this number? Why not the maximum 32768? Pavel On Mon, Sep 21, 2009 at 11:45 AM, Alexey Pechnikov wrote: > Hello! > > On Monday 21 September 2009 15:05:04 Atul_Vaidya wrote: >> 5. PRAGMA cache_size = 12000;

Re: [sqlite] Faster inserts in SQlite ...

Hello! On Monday 21 September 2009 15:05:04 Atul_Vaidya wrote: > 5. PRAGMA cache_size = 12000; I use value 128 000 on servers. You must set pragma page_size=4096; If database is not empty is needed to vacuum it. > > i also avoid the update calls, and i do all the insertion in between Begin >

Re: [sqlite] SQL Lite date / time functions

Hello! On Monday 21 September 2009 15:59:47 Igor Tandetnik wrote: > > Please speak is now correct to store 'start of month' dates in > > julianday format? > > Was it at some point "incorrect" to do so? Yes, you can store any date > in julian day format, start of month or otherwise. Are correct

Re: [sqlite] Code problem - apostrophes

On Mon, Sep 21, 2009 at 9:35 AM, Jimmy Verner wrote: > I did realize a couple of points that might be helpful to others: > > 1.  When you run "find and replace," it won't always pick up all the > apostrophes (or single close-quotes).  Apparently, different programs >

Re: [sqlite] Code problem - apostrophes

I did realize a couple of points that might be helpful to others: 1. When you run "find and replace," it won't always pick up all the apostrophes (or single close-quotes). Apparently, different programs encode this symbol differently. I've encountered this problem before when using more

Re: [sqlite] blocking when locking

> I see. Thanks for your explaination. > May I ask if SQLite can explicitly start a write lock transaction ? Yes. It's BEGIN IMMEDIATE or BEGIN EXCLUSIVE. The difference is that IMMEDIATE still allows readers to read until actual writing to the database file occurs (before that everything is

Re: [sqlite] Most wanted features of SQLite ?

Dr. Hip, As I stated before, I do not have a detailed understanding of the core source. Therefore I do not know how difficult or even possible adding a pragma controlled(?) finer grained locking "hook" or related API calls for those who might wish to "wrap" a server layer around the core.

Re: [sqlite] blocking when locking

2009/9/21 Pavel Ivanov > > What I want to say is in this example, there should be only one step, > > because the transaction knows it will do 'write'. > > Then the txn should start a write lock before the select. > > > > And this is not a good example to explain dead lock, I

Re: [sqlite] Most wanted features of SQLite ?

On Sep 21, 2009, at 8:58 AM, Fred Williams wrote: > > Fine for me. It seems to be everybody else that wants their favorite > feature imbedded in the core :-) > > Fine grained locking would be a great "asset" I feel. Notice I did > not > request a "feature." On my to-do list is to write a

Re: [sqlite] Most wanted features of SQLite ?

Fine for me. It seems to be everybody else that wants their favorite feature imbedded in the core :-) Fine grained locking would be a great "asset" I feel. Notice I did not request a "feature." Fred -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Index usage

> My question: how can I optimize this kind of query so that it utilizes > both indexes, to grab the first [b] rows (ordered by time) which also > match [a]? Or am I just going to have to guess at which way will be > faster, and use "INDEXED BY" to force it? (The documentation says I > shouldn't

Re: [sqlite] Newbie needing help to get set up for C++ in Windows

> I am using NetBeans 6.5.1 as my development environment and Cygwin (GNU) > C++. What does this mean? Do you program in C++ inside NetBeans? > If the DLL is all that I need, could someone give me a hint as to how to > link to it in NetBeans? > All my NetBeans work to date has been in Java and I

Re: [sqlite] SQL Lite date / time functions

Alexey Pechnikov wrote: > Please speak is now correct to store 'start of month' dates in > julianday format? Was it at some point "incorrect" to do so? Yes, you can store any date in julian day format, start of month or otherwise. > Does SQLite now uses internal reprezentation of > microseconds

Re: [sqlite] blocking when locking

> What I want to say is in this example, there should be only one step, > because the transaction knows it will do 'write'. > Then the txn should start a write lock before the select. > > And this is not a good example to explain dead lock, I think. And again, you're talking about application

[sqlite] sqlite command-line system escape

Is there an escape character or sequence that can be used from the sqlite3 command-line to run system commands ? For example sqlite> ! dir Using sqlite3 version 3.5.9-6 under Debian Linux I thought I remembered doing this in earlier versions from a few years

Re: [sqlite] List of active savepoints names

> And now compare it with simple API funtion what just list existing > savepoint stack inside Sqlite. It is simple, trivial, useful... and > working right at any case. So, just take SQLite code, implement this trivial function and use it as you like. It will be a separate function, you will not

Re: [sqlite] Most wanted features of SQLite ?

Hello! On Monday 21 September 2009 14:33:30 Grzegorz Wierzchowski wrote: > BTW while we are at subject of SQLite extensions. > I'm very new on this e-mail list but already saw here and there in mails > several links to places around the web with some extensions. There are a lot of extensions in

[sqlite] Faster inserts in SQlite ...

Hi List, I have been using SQlite to store the information from my application.However,when i did a time analysis, I found that the sqlite contributes to Half of the total time.The data that i am storing in the Database using SQlite is retrieved on a per entity basis. In order, to

Re: [sqlite] List of active savepoints names

> > > > I am searching some API function for get list of active > > > > savepoint names. Is this possible? Thank you! > > > No, this is not possible. Why do you need it in the first place? > > It will be great for debugging, for example. > You can create a custom wrapper for savepoints which

Re: [sqlite] Most wanted features of SQLite ?

You mean like http://www.sqlite.org/contrib ? I agree though there's much to improve in that area... Itamar. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Grzegorz Wierzchowski Sent: Monday, September 21, 2009 1:34 PM To:

Re: [sqlite] Most wanted features of SQLite ?

BTW while we are at subject of SQLite extensions. I'm very new on this e-mail list but already saw here and there in mails several links to places around the web with some extensions. What would you say guys for creating some centalized list of (known/recommended ...) extensions somewhere on

Re: [sqlite] perfomance optimisations on tmpfs file system

Ah, great "first post" :( and now I'm going to compound my crimes by replying to self with a real subject heading - Sorry about that. > Hi, (SQLite v3.6.17, on ARM with Linux 2.6.18) > > I'm currently investigating the applicability of SQLite in an embedded > application. Part of this would be

[sqlite] (no subject)

Hi, (SQLite v3.6.17, on ARM with Linux 2.6.18) I'm currently investigating the applicability of SQLite in an embedded application. Part of this would be to store configuration data, for which SQLite seems like a natural fit. I also have a requirement for exchange of realtime data between

Re: [sqlite] List of active savepoints names

Hello! On Monday 21 September 2009 11:48:37 Lukas Gebauer wrote: > > > I am searching some API function for get list of active savepoint > > > names. Is this possible? Thank you! > > > > No, this is not possible. Why do you need it in the first place? > > It will be great for debugging, for

Re: [sqlite] Most wanted features of SQLite ?

Hello! On Monday 21 September 2009 11:36:15 Roger Binns wrote: > Also not mentioned is that it is available under a public domain license and > hence anyone has the right to use it in any way they deem fit, make changes, > distribute changes, charge anything they want, keep everything public, >

Re: [sqlite] Viewer for blobs in hex?

Yan Bertrand wrote: > Hi all, > > > > I would like to display the contents of blobs in my table as > hexadecimal. I have not found any easy way of doing this. I tried : > > - wxSQLitePlus, but it does not display blobs contents (or I > could not make it do so) > > -

Re: [sqlite] Viewer for blobs in hex?

Yan, >I would like to display the contents of blobs in my table as >hexadecimal. I have not found any easy way of doing this. I tried : Give SQLite Expert a try. There are both free and Pro version available at http://www.sqliteexpert.com/index.html Free version has no hassle license, no

Re: [sqlite] Viewer for blobs in hex?

Hello Yan, you could use my SQLiteManager application: http://www.sqlabs.com/sqlitemanager.php Regards, -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Sep 21, 2009, at 9:43 AM, Yan Bertrand wrote: >Hi all, > > > > I would like to display the

Re: [sqlite] Viewer for blobs in hex?

2009/9/21 Yan Bertrand : >                Hi all, > > > > I would like to display the contents of blobs in my table as > hexadecimal. I have not found any easy way of doing this. I tried : > > -          wxSQLitePlus, but it does not display blobs contents (or I > could

Re: [sqlite] List of active savepoints names

> > I am searching some API function for get list of active savepoint > > names. Is this possible? Thank you! > > No, this is not possible. Why do you need it in the first place? It will be great for debugging, for example. -- Lukas Gebauer. E-mail: gebau...@mlp.cz http://synapse.ararat.cz/

Re: [sqlite] List of active savepoints names

> > I am searching some API function for get list of active savepoint > > names. Is this possible? Thank you! > > Since your code is creating and releasing savepoints, why not just > record them in your code? I am not creating and releasing savepoints! They are created and released by Sqlite, I

[sqlite] Viewer for blobs in hex?

Hi all, I would like to display the contents of blobs in my table as hexadecimal. I have not found any easy way of doing this. I tried : - wxSQLitePlus, but it does not display blobs contents (or I could not make it do so) - SQLiteManager plugin (for Mozilla

Re: [sqlite] Most wanted features of SQLite ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: > SQLite does have the best extensibility of known to me DBMS. Also not mentioned is that it is available under a public domain license and hence anyone has the right to use it in any way they deem fit, make changes,

Re: [sqlite] Reading "packed" data

Simon Slavin wrote: > On 20 Sep 2009, at 8:06pm, Mohit Sindhwani wrote: > > >> I'm just trying to see if there's a way to move more data per request. >> But it seems not (for now). >> > > By all means write your own routine that calls _step lots of times. > But it won't be faster or

Re: [sqlite] SQL Lite date / time functions

Hello! On Monday 21 September 2009 05:44:31 D. Richard Hipp wrote: > Is the content of the "date" field either a julian day number or an > ISO-8601 format date string? Please speak is now correct to store 'start of month' dates in julianday format? Does SQLite now uses internal reprezentation

Re: [sqlite] Most wanted features of SQLite ?

Hello! On Monday 21 September 2009 01:45:07 Fred Williams wrote: > With the background of the never ending drumbeat of "feature, feature, > feature..." on this list as a reason, I wonder if the structure of > SQLite could be "enhanced" to better support the "plug-in" concept, aka: > as with