[sqlite] Minimum RAM requirements

I asked this question on the sql_dev list which Richard Hipp told me that this list was the proper place. I asked whether it is possible to execute SQLite in 80K of RAM. Well, I can now tell you that you can, just about. My environment has no malloc so I used the MEMSYS5 method of internal

Re: [sqlite] memory fault in sqlite3_open_v2()

Hello, Joe. You wrote Tuesday, January 17, 2012, 12:50:35: >> For now I've just defined _WIN32_WINNT as 0x500, but not sure is >> it correct, and will my application works if it will be launched under >> Windows 9X. > This is the correct fix. Also, most modern Windows projects already >

Re: [sqlite] How to get column datatype

Well, to begin with, SQLite doesn't exactly have column data types like most other DBMS, rather, columns have affinities, which might be looked at as sort of preferences. See http://www.sqlite.org/different.html#typing and http://www.sqlite.org/datatype3.html#affinity However, this command

Re: [sqlite] Bin parameters by name - generic function

David Garfield wrote, On 1/17/2012 7:05 PM: I believe the secret is: don't bother. sqlite does type conversion as needed, so you can just pass the strings you've parsed out of your larger string to sqlite3_bind_text(). Excellent! Exactly what I was looking for. If the issue is that you need

[sqlite] diacritic insensitive search

Hi, I have ICU integrated with SQLITE. How do I specify a diacritic insensitive search ?. ex:- when I search for all strings that begin with 'e', the result set should return all strings that begin with 'e' as well as the accentuated 'e'. -Sreekumar

[sqlite] How to get column datatype

Hi All, Does SQLite support any SQL command to get column datatype of table like varchar, INTEGER? Please share example of such command. It would be helpful for me. Thanking you. -- Regards, - Tarun Thakur ___ sqlite-users mailing list

Re: [sqlite] Bin parameters by name - generic function

http://www.c-sharpcorner.com/UploadFile/prasad_1/RegExpressionSample72005040853AM/RegExpressionSample1.aspx At that site they parse your string using regex in c#, though I did't see a time stamp test, and their is the equivalent regex functions, many, in a c libs. On Tue, Jan 17, 2012 at

Re: [sqlite] Bin parameters by name - generic function

I believe the secret is: don't bother. sqlite does type conversion as needed, so you can just pass the strings you've parsed out of your larger string to sqlite3_bind_text(). If the issue is that you need to decode your TIMESTAMP1 column to get the same format as TIMESTAMP2, and you want to use

[sqlite] Bin parameters by name - generic function

I'm trying to write a function with a sig like this: int BindParameter(sqlite3_stmt* stmt, int sqlType, const char* pname, char* value); Somewhere before the call(s) to BindParameter, I'll have a string that looks like this: (FOO=some text value, BAR=3.141, ZIP=45, TIMESTAMP1=01/17/12

Re: [sqlite] sqlite3_set_auxdata & invalid pointer

I guess that "sqlite3_set_auxdata" cannot be called by the xStep implementation of an aggregate function. The doc says: "The following two functions may be used by scalar SQL functions to associate metadata with argument values." I will try with "sqlite3_aggregate_context". Sorry for the

Re: [sqlite] Open source projects using sqlite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/01/12 05:01, Matt Young wrote: > Mainly grouping sqlite applications in the embedded environment, > hopefully generating some reusable methods of accessing the sqlite > internals. I'm still totally confused about what you are trying to achieve.

Re: [sqlite] R*Tree virtual table question

On Tue, 17 Jan 2012 11:35:58 +, "g...@novadsp.com" wrote: >Thanks Simon, > >> Neither of those things are simple. >> >> Rather than hack an existing library, I recommend that you allow the R*Tree >> module to maintain its integer keys and make another (normal, not R*Tree)

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

On Tue, Jan 17, 2012 at 06:21:48PM +0100, noel.frankinet wrote: > Le 17/01/2012 18:15, Chris Green a écrit : > > Hello Chris, > > You should look at Dojo javascript library, I think they have the > widget you are looking for. Of course you still need the back-end > plumbing (PHP I suppose).

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

Le 17/01/2012 18:15, Chris Green a écrit : Hello Chris, You should look at Dojo javascript library, I think they have the widget you are looking for. Of course you still need the back-end plumbing (PHP I suppose). Best wishes Noël On Tue, Jan 17, 2012 at 08:36:11AM -0800, Matt Young

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

On Tue, Jan 17, 2012 at 08:36:11AM -0800, Matt Young wrote: > http://javascriptsource.com/forms/dynamic-table.html > Looks great if you operate from a browser. Can we still get sqlite > embedded into the browser, or do we have to plug it in? > That doesn't really do it for me, it doesn't edit in

Re: [sqlite] sqlite3_close() necessary?

On Tue, Jan 17, 2012 at 11:51 AM, Bill McCormick wrote: > What happens if my application fails to call sqlite3_close() before it > exits? Does it leave the db in some unknown state or open to corruption? > > If I have a daemon type program, will I need to catch signals that

[sqlite] sqlite3_close() necessary?

What happens if my application fails to call sqlite3_close() before it exits? Does it leave the db in some unknown state or open to corruption? If I have a daemon type program, will I need to catch signals that try to close/kill the program and call sqlite3_close() before exiting? Thanks!!

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

http://javascriptsource.com/forms/dynamic-table.html Looks great if you operate from a browser. Can we still get sqlite embedded into the browser, or do we have to plug it in? On Tue, Jan 17, 2012 at 8:05 AM, Chris Green wrote: > I'm after an application which will allow me to

Re: [sqlite] Open source projects using sqlite

Another example is reusing parts of fossil code in a group ware application. The two projects might generate a common table view of what a user is, hence generating some common code to manage user id tables. Then you have folks doing something completely unrelated, but still using sqlite and

[sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

I'm after an application which will allow me to enter data into a sqlite database using a 'grid' layout of the data. I.e. I want the existing contents of the database displayed as a table and I want to be able to click on a field in a row and just edit the data in place. In addition I want to be

Re: [sqlite] Some pieces of the puzzle are coming together

Pavel Ivanov wrote, On 1/17/2012 9:42 AM: I attempted all of the above and the call stacks do not change. That leads me to one of two conclusions: 1. The call stacks are inaccurate 2. There is some side effect which is causing malloc to be called inside of a procedure which should not be

Re: [sqlite] Some pieces of the puzzle are coming together

> I attempted all of the above and the call stacks do not change.  That leads > me to one of two conclusions: > > 1.  The call stacks are inaccurate > 2.  There is some side effect which is causing malloc to be called inside > of a procedure which should not be calling malloc. > > I've posted an

[sqlite] msize in 3.7.10

Hi, I'm using static linking with Delphi and a new function required binding in 3.7.10 - msize (__msize). The problem here is that there's no official way to query the size of a memory block in Delphi memory manager, at least I'm not aware of one. Should I solve this anyway (for example by keeping

Re: [sqlite] memory fault in sqlite3_open_v2()

Hello, Igor. MSDN says, that GetFullPathNameW() is present since Windows 95, so i thought function GetFullPathNameW() can be used when _WIN32_WINNT is not defined. >> >>> I'm unable to locate the MSDN documentation that indicates this. >> >> I can't find it in WWW, seems

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 8:05 PM, John Elrick wrote: > > > On Mon, Jan 16, 2012 at 5:31 PM, Richard Hipp wrote: > >> On Mon, Jan 16, 2012 at 5:13 PM, John Elrick > >wrote: >> >> > I did this trace through the Delphi IDE and

Re: [sqlite] Pager Sub-system

u okafor wrote: > Is there a way to turn off the Pager subsystem of SQLIte application - that > is, > not have to deal with declarations and definitions of the functions ** that > make > up the Pager sub-system API? In what way do you feel you are forced to "deal" with those

Re: [sqlite] PENDING Lock / Sqlite .NET

Solanki, Ajay (GE Energy) wrote: > I have a question on how to enable PENDING LOCK before issuing an > INSERT statement from the C# code. What do you mean, enable PENDING LOCK? It's not something you can enable or disable. SQLite will acquire a pending lock on the database

Re: [sqlite] PENDING Lock / Sqlite .NET

On 17 Jan 2012, at 6:47am, Solanki, Ajay (GE Energy) wrote: > I have a question on how to enable PENDING LOCK before issuing an > INSERT statement from the C# code. What do you want SQLite to do instead of a pending lock ? If you want to disable the locking entirely, you can do it with

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 5:36 PM, Richard Hipp wrote: > On Mon, Jan 16, 2012 at 5:31 PM, John Elrick >wrote: > > SNIP > This is very curious and perhaps a useful clue. SQLite does call > SNIP It is a clue that I need a break. While updating the

Re: [sqlite] memory fault in sqlite3_open_v2()

darkelf wrote: >>> MSDN says, that GetFullPathNameW() is present since >>> Windows 95, so i thought function GetFullPathNameW() can be >>> used when _WIN32_WINNT is not defined. > >> I'm unable to locate the MSDN documentation that indicates this. > > I can't find it in

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 11:47 PM, Max Vlasov wrote: > On Tue, Jan 17, 2012 at 5:05 AM, John Elrick >wrote: > > > > > > I can try that approach with BCC. I was concerned that the IDE would be > > getting inaccurate information from the .OBJ.

[sqlite] PENDING Lock / Sqlite .NET

Hi I have a question on how to enable PENDING LOCK before issuing an INSERT statement from the C# code. Do let me know if you can point me to some resources where I can find the answer or provide me the response. Regards Ajay Solanki +91 98192 54465

[sqlite] Pager Sub-system

Dear sir, Is there a way to turn off the Pager subsystem of SQLIte application - that is, not have to deal with declarations and definitions of the functions ** that make up the Pager sub-system API? uo+   As examples:   /* Open and close a Pager connection. */ SQLITE_PRIVATE int

[sqlite] Bug report: shell only supports dumping a single table at a time

Hi, In the documentation for the .dump command for the sqlite3 shell (http://www.sqlite.org/sqlite.html) there is an ellipsis after the name of the table, implying that it is possible to specify multiple tables and have more than one table dumped at once. However in the shell.c source code, the

Re: [sqlite] Open source projects using sqlite

Mainly grouping sqlite applications in the embedded environment, hopefully generating some reusable methods of accessing the sqlite internals. One example might be a reusable method for storing BSON objects, so differing BSON applications share a common table/column view of BSON. On Mon, Jan

Re: [sqlite] memory fault in sqlite3_open_v2()

Hello, Joe. Thanks for your reply. >> MSDN says, that GetFullPathNameW() is present since >> Windows 95, so i thought function GetFullPathNameW() can be >> used when _WIN32_WINNT is not defined. > I'm unable to locate the MSDN documentation that indicates this. I can't find it in WWW,

Re: [sqlite] R*Tree virtual table question

Thanks Simon, Neither of those things are simple. Rather than hack an existing library, I recommend that you allow the R*Tree module to maintain its integer keys and make another (normal, not R*Tree) table in the same SQLite database to keep the list of GUIDs vs. integer keys. Ouch :)

Re: [sqlite] R*Tree virtual table question

On 17 Jan 2012, at 11:01am, g...@novadsp.com wrote: > I've working on a location aware application that uses GUIDs as the primary > key for related tables. The SQLite R*Tree module is the natural choice for > indexing the image location data but there the issue of the integer primary > key

[sqlite] R*Tree virtual table question

I've working on a location aware application that uses GUIDs as the primary key for related tables. The SQLite R*Tree module is the natural choice for indexing the image location data but there the issue of the integer primary key type. Is it possible to change the primary key type? Is it

Re: [sqlite] memory fault in sqlite3_open_v2()

darkelf wrote: > > MSDN says, that GetFullPathNameW() is present since > Windows 95, so i thought function GetFullPathNameW() can be > used when _WIN32_WINNT is not defined. > I'm unable to locate the MSDN documentation that indicates this. > > For now I've just defined _WIN32_WINNT

Re: [sqlite] memory fault in sqlite3_open_v2()

Hello. > I'm using SQLite in my project that compiles by MSVC 6.0 in > Windows XP. I've upgraded SQLite library from 3.7.8 to > 3.7.10 and got a problem. Builds went fine, but when I was > launching my application, I got memory fault. Application > faulted on first call of

Re: [sqlite] sqlite-users Digest, Vol 49, Issue 16

Am 17.01.2012 11:20, schrieb Oliver Peters: Am 17.01.2012 10:50, schrieb YAN HONG YE: how to add average value replace the ? to the end of line of this following database: ID name sex match chinese english phy chem total CY001 cred male 104 112 101 85 99 697 CY002 rose female 87 105 98 119 101

Re: [sqlite] sqlite-users Digest, Vol 49, Issue 16

Am 17.01.2012 10:50, schrieb YAN HONG YE: how to add average value replace the ? to the end of line of this following database: ID namesex match chinese english phy chemtotal CY001 credmale104 112 101 85 99 697 CY002 rosefemale 87

[sqlite] memory fault in sqlite3_open_v2()

Hello. I'm using SQLite in my project that compiles by MSVC 6.0 in Windows XP. I've upgraded SQLite library from 3.7.8 to 3.7.10 and got a problem. Builds went fine, but when I was launching my application, I got memory fault. Application faulted on first call of

Re: [sqlite] sqlite-users Digest, Vol 49, Issue 16

how to add average value replace the ? to the end of line of this following database: ID namesex match chinese english phy chemtotal CY001 credmale104 112 101 85 99 697 CY002 rosefemale 87 105 98 119 101 693

Re: [sqlite] savepoint

Many thanks, it would help. Csaba 2012/1/16 Vivien Malerba > 2012/1/16 Csaba Jeney > > > Is there any way to query the valid savepoints? At least their names? > > Many thanks. > > > > > AFAIK, the only way to do this is to keep track of each begin,