Re: [sqlite] memory fault in sqlite3_open_v2()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/01/12 22:57, darkelf wrote: > I'm compiling for Windows 9X, so compilationcheckdecides > thatthereisno GetFullPathNameW() The best resolution to your issues will be to use Unicows:

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

Have you checked out "Base" from OpenOffice.org? If you want MS Access-like functionality, it might be worth a try. Note that Base uses HSQLDB as it's default backend, but you can replace it with SQLite Please see:

Re: [sqlite] memory fault in sqlite3_open_v2()

Hello, Roger. You wrote Wednesday, January 18, 2012, 10:36:44: >> I'm compiling for Windows 9X, so compilationcheckdecides >> thatthereisno GetFullPathNameW() > The best resolution to your issues will be to use Unicows: >

Re: [sqlite] Minimum RAM requirements

On Wed, Jan 18, 2012 at 2:25 AM, David Henry wrote: > 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,

[sqlite] insert image into db - windows batch

have windows batch working with sqlite, may I insert image into database and than read this images from? L. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] insert image into db - windows batch

On 18 Jan 2012, at 11:00am, Petr Lázňovský wrote: > have windows batch working with sqlite, may I insert image into database and > than read this images from? Convert your image into a BLOB and store it as a BLOB. BLOBs are just runs of bytes -- you can store anything you want as a BLOB.

Re: [sqlite] msize in 3.7.10

On Tue, Jan 17, 2012 at 6:11 PM, Max Vlasov wrote: > 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

Re: [sqlite] insert image into db - windows batch

>> have windows batch working with sqlite, may I insert image into database and >> than read this images from? > Convert your image into a BLOB and store it as a BLOB. BLOBs are just runs > of bytes -- you can store anything you want as a BLOB. What you mean by "Convert image into a BLOB" is

Re: [sqlite] msize in 3.7.10

On Tue, Jan 17, 2012 at 9:11 AM, Max Vlasov wrote: > 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

[sqlite] installation for .NET use

Trying to use the .NET support but not able to see the entry in the GAC. Ran the gacutil and it told me the assembly had been built with a later runtime. I am running windows 7 with all fixes. Anyone have the .net version running? Regards, Major. ___

Re: [sqlite] msize in 3.7.10

On Wed, Jan 18, 2012 at 4:47 PM, Richard Hipp wrote: > Try using the trunk of the SQLite source tree with the SQLITE_WITHOUT_MSIZE > preprocessor macro. > > > Richard, thank, I will try, but I just tried to replace #if !defined(HAVE_MALLOC_USABLE_SIZE) && SQLITE_OS_WIN # define

Re: [sqlite] insert image into db - windows batch

On 18 Jan 2012, at 12:30pm, Petr Lázňovský wrote: >>> have windows batch working with sqlite, may I insert image into database >>> and than read this images from? > >> Convert your image into a BLOB and store it as a BLOB. BLOBs are just runs >> of bytes -- you can store anything you want as

Re: [sqlite] installation for .NET use

It looks like the .net runtime version running in your system is older compared to the version with which the assembly was built (and which you are trying to install in GAC) Regards Taleeb bin Waquar *Hum Mashriq Ke "Miskeenon" Ka Dil Maghrib men Ja Atka Hai!!* On Wed, Jan 18, 2012 at 6:19

Re: [sqlite] installation for .NET use

majorthorb...@mst-it-services.info wrote: > > Ran the gacutil and it told me the assembly had been built with a later > runtime. > Please make sure you downloaded the System.Data.SQLite download package that is appropriate for the version of the .NET Framework (2.0 or 4.0) and processor

Re: [sqlite] memory fault in sqlite3_open_v2()

darkelf wrote: > > As I understand if I'm not defining _WIN32_WINNT, I'm > compiling for Windows 9X > If you do not define _WIN32_WINNT, the resulting DLL will only work (in theory) on Windows 9x. However, this support has not been tested recently. > > But when I run that executable in

Re: [sqlite] msize in 3.7.10

On Wed, Jan 18, 2012 at 4:47 PM, Richard Hipp wrote: > On Tue, Jan 17, 2012 at 9:11 AM, Max Vlasov wrote: > > > Hi, > > I'm using static linking with Delphi and a new function required binding > in > > 3.7.10 - msize (__msize). > > ... > > Try using the

[sqlite] Using last_row_insert() with sqlite3_prepare() and friends.

Using SQLite version 3.7.7.1 (Windows/VS2008). A table has an integer autoincrement primary key, the value of which is being used to feed an R*Tree index. I am attempting to insert data and retrieve the latest row_id() in a compound statement like this using the SQLite C API: "INSERT INTO

Re: [sqlite] Using last_row_insert() with sqlite3_prepare() and friends.

On Jan 18, 2012, at 3:35 PM, g...@novadsp.com wrote: > "INSERT INTO table (columns) VALUES(?,?,?,?); > SELECT last_insert_rowid() FROM table;" These are really two statements, not one. Execute them one after the other and you will get the desired effect.

Re: [sqlite] Using last_row_insert() with sqlite3_prepare() andfriends.

Petite Abeille wrote: > On Jan 18, 2012, at 3:35 PM, g...@novadsp.com wrote: > >> "INSERT INTO table (columns) VALUES(?,?,?,?); >> SELECT last_insert_rowid() FROM table;" > > These are really two statements, not one. Execute them one after the other > and you will get

Re: [sqlite] insert image into db - windows batch

On Jan 18, 2012, at 12:00 PM, Petr Lázňovský wrote: > have windows batch working with sqlite, may I insert image into database and > than read this images from? As pointed out, you might want to use the 'blob' type to store binary data. That said, why bother storing these images inside the

Re: [sqlite] Using last_row_insert() with sqlite3_prepare() and friends.

g...@novadsp.com wrote: > "INSERT INTO table (columns) VALUES(?,?,?,?); SELECT last_insert_rowid() > FROM table;" > > which works in the Sqlite3 console. However when I run this > sqlite3_step() returns SQLITE_DONE. > > sqlite3_prepare(); > sqlite3_bind_xxx(); > sqlite3_step(); > > Can anyone

Re: [sqlite] Using last_row_insert() with sqlite3_prepare() andfriends.

On Jan 18, 2012, at 3:44 PM, Igor Tandetnik wrote: >>> "INSERT INTO table (columns) VALUES(?,?,?,?); >>> SELECT last_insert_rowid() FROM table;" >> >> These are really two statements, not one. Execute them one after the other >> and you will get the desired effect. > > Or just call

Re: [sqlite] insert image into db - windows batch

> On 18 Jan 2012, at 12:30pm, Petr Lázňovský wrote: have windows batch working with sqlite, may I insert image into database and than read this images from? >>> Convert your image into a BLOB and store it as a BLOB. BLOBs are just runs >>> of bytes -- you can store anything you want

Re: [sqlite] insert image into db - windows batch

On 18 Jan 2012, at 3:02pm, Petr Lázňovský wrote: > did you read the subject of my mail? I am use sqlite from Win batch (shell) > scripting by commands like: > > sqlite3.exe main.db "Insert into Table1 values('','','');" > > or > > sqlite3.exe main.db "select * from Table1 where

Re: [sqlite] insert image into db - windows batch

You should be able to do it. We put a shot set of hex data in using a script. You likely want to load your file into a variable of hex (or binary) type, if you don't want to write a script that writes a script. Then insert into your_table (f1, blob) values ( your_f1_value ,

Re: [sqlite] insert image into db - windows batch

Because of packing. The script should be distributable as one .cmd file, the database engine and database itself will be embeded inside od script. Dealing with embeded files in the shell script is not easy thus I want to minimize its number. L. > On Jan 18, 2012, at 12:00 PM, Petr Lázňovský

Re: [sqlite] Using last_row_insert() with sqlite3_prepare() and friends.

Thanks to all. On 18/01/2012 14:53, Petite Abeille wrote: Or just use last_insert_rowid() directly in the next insert statement. That will reuse the rowid of the previous insert for the new one. And both row will end up with the same id, keeping your source table and its R*Tree index in

Re: [sqlite] insert image into db - windows batch

> Sorry, 'windows batch' doesn't mean anything to me. http://en.wikipedia.org/wiki/Batch_file but wikipedia is reasonlessly turned off today ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Using last_row_insert() with sqlite3_prepare() and friends.

On Jan 18, 2012, at 4:16 PM, g...@novadsp.com wrote: >> Or just use last_insert_rowid() directly in the next insert statement. That >> will reuse the rowid of the previous insert for the new one. And both row >> will end up with the same id, keeping your source table and its R*Tree index >>

Re: [sqlite] memory fault in sqlite3_open_v2()

Hello, Joe. You wrote Wednesday, January 18, 2012, 15:15:36: >> As I understand if I'm not defining _WIN32_WINNT, I'm >> compiling for Windows 9X > If you do not define _WIN32_WINNT, the resulting DLL will only > work (in theory) on Windows 9x. However, this support has not > been tested

Re: [sqlite] insert image into db - windows batch

On 18 Jan 2012 at 15:24, Petr Lázňovský wrote: >> Sorry, 'windows batch' doesn't mean anything to me. > > http://en.wikipedia.org/wiki/Batch_file > > but wikipedia is reasonlessly turned off today Looks like you can get round this (at least on OS X / Safari 5.1) by pressing

Re: [sqlite] insert image into db - windows batch

On Jan 18, 2012, at 4:24 PM, Petr Lázňovský wrote: > but wikipedia is reasonlessly turned off today On the contrary, they have pretty good reasons: http://en.wikipedia.org/wiki/Wikipedia:SOPA_initiative/Learn_more https://www.google.com/landing/takeaction/

[sqlite] R*Tree insert error ...

One more oddity. Can anyone help? 1. Create a 2D index as per documentation: "CREATE VIRTUAL TABLE gps_index USING rtree(id,minX, maxX,minY, maxY)" 2. Create a statement using a binding string: "INSERT INTO gps_index VALUES(last_insert_rowid(), ?, ?, ?, ?)" 3. Bind values. Binding indices

[sqlite] R*Tree insert error ...

One more oddity. Can anyone help? 1. Create a 2D index as per documentation: "CREATE VIRTUAL TABLE gps_index USING rtree(id,minX, maxX,minY, maxY)" 2. Create a statement using a binding string: "INSERT INTO gps_index VALUES(last_insert_rowid(), ?, ?, ?, ?)" 3. Bind values. Binding indices

Re: [sqlite] R*Tree insert error ...

On Wed, Jan 18, 2012 at 11:15 AM, g...@novadsp.com wrote: > One more oddity. Can anyone help? > > 1. Create a 2D index as per documentation: > > "CREATE VIRTUAL TABLE gps_index USING rtree(id,minX, maxX,minY, maxY)" > > 2. Create a statement using a binding string: > > "INSERT

[sqlite] multi-readers performance degrading when moving from 1 single connection (serialized) to multiple connections

Hi, Link to my question on StackOverflow.com: http://stackoverflow.com/q/8913873/1156611 Any help would be appreciated, Regards, Oren Bar ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] insert image into db - windows batch

Hello Petr, You could Mime encode them to text, insert as a string. Pull them back out as strings, un-mime them. Should be able to do that from a batch file. I keep a bunch of images in Sqlite DB files. It's reasonably fast and I like having them all in one place. Some of the DB files are > 10

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

I think MyJSQLView should do what you suggest. Most of the commands can be entered via keyboard for add, edit, delete, etc. for data manipulation. Free and open source. http://sourceforge.net/projects/myjsqlview/ To use with SQLite download Xerial JDBC and install in java/lib/ext/ directory.

Re: [sqlite] R*Tree insert error ...

On 18/01/2012 16:41, Richard Hipp wrote: What does sqlite3_errmsg() say? 'SQL logic error or missing database' I should perhaps add this set of inserts is running inside a transaction with a WAL enabled database. There is only one write thread active. All other inserts (save R*Tree) work

Re: [sqlite] R*Tree insert error ...

On 01/19/2012 12:42 AM, g...@novadsp.com wrote: On 18/01/2012 16:41, Richard Hipp wrote: What does sqlite3_errmsg() say? 'SQL logic error or missing database' Are you using sqlite3_prepare() or sqlite3_prepare_v2()? If the former, try switching to prepare_v2() then checking the error

Re: [sqlite] R*Tree insert error ...

Hello Dan Are you using sqlite3_prepare() or sqlite3_prepare_v2()? If the former, try switching to prepare_v2() then checking the error message again. The former. I've switched to V2. One possibility is that you're hitting one of the r-tree tables built-in constraints by specifying a record

Re: [sqlite] R*Tree insert error ...

On 18/01/2012 18:04, Dan Kennedy wrote: One possibility is that you're hitting one of the r-tree tables built-in constraints by specifying a record with (minval > maxval) for one or more of the dimensions. Rearranging the bind parameters for match minx,miny,maxx,maxy layout I now get this

Re: [sqlite] R*Tree insert error ...

The order for RTREEs is min_dimension1,max_dimension1,min_dimension2,max_dimension2... 51.51340259 is definitely greater than -1.86352760 Best regards, Peter From: "g...@novadsp.com" To: sqlite-users@sqlite.org Sent: Wed, January 18, 2012

Re: [sqlite] insert image into db - windows batch

On 18 Jan 2012 at 15:24, Petr Lázňovský wrote: >> Sorry, 'windows batch' doesn't mean anything to me. > > http://en.wikipedia.org/wiki/Batch_file > > but wikipedia is reasonlessly turned off today > > > > ___ > sqlite-users mailing

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

I could not use any of the proffered tools for several reasons. After an inspiration yesterday, I dusted off my C programming skills and started hacking a pseudo-call stack system into SQLite3.c. I've put the statistics below for the top couple of call stacks. Total times _malloc called in

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

On Wed, Jan 18, 2012 at 3:12 PM, John Elrick wrote: > > Total times _malloc called in test: 69,859,114 > > Times calling _malloc: 57,679,282 > sqlite3Parser(10) > sqlite3RunParser(9) > sqlite3Prepare(8) > sqlite3_prepare(7) > sqlite3_exec_inner_loop_invoke_callback(6) >

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

What else could trigger a call to sqlite3ResetInternalSchema()? I'm getting a clear breakpoint tracing back to such innocuous calls as _sqlite3_step. On Wed, Jan 18, 2012 at 3:31 PM, Richard Hipp wrote: > On Wed, Jan 18, 2012 at 3:12 PM, John Elrick

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

FYI, I traced the number of calls to sqlite3ResetInternalSchema() on a smaller set of data. It appears that it isn't the culprit. Total mallocs: 148,156 Total calls to sqlite3ResetInternalSchema(): 63 On Wed, Jan 18, 2012 at 3:41 PM, John Elrick wrote: > What else

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

Whatever is happening, it appears I can only reproduce it under these circumstances. I'll continue digging into the procedure tomorrow to see if I can narrow down where this is coming from. On Wed, Jan 18, 2012 at 3:54 PM, John Elrick wrote: > FYI, I traced the number

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

I made one more stab and narrowed down the mallocs to this call: Count:119,133 = 'sqlite3Parser_lt_YYNSTATEpYYNRULE(12) sqlite3Parser(11) sqlite3RunParser(10) sqlite3Prepare(9) sqlite3_prepare(8) sqlite3_exec_inner_loop_invoke_callback(7) sqlite3_exec_outer_while(6) sqlite3_exec(5)

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

On Wed, Jan 18, 2012 at 4:30 PM, John Elrick wrote: > I made one more stab and narrowed down the mallocs to this call: > > Count:119,133 = 'sqlite3Parser_lt_YYNSTATEpYYNRULE(12) > sqlite3Parser(11) > sqlite3RunParser(10) > sqlite3Prepare(9) > sqlite3_prepare(8) >

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

On Wed, Jan 18, 2012 at 4:32 PM, Richard Hipp wrote: > On Wed, Jan 18, 2012 at 4:30 PM, John Elrick >wrote: > > > I made one more stab and narrowed down the mallocs to this call: > > > > Count:119,133 = 'sqlite3Parser_lt_YYNSTATEpYYNRULE(12) > >

Re: [sqlite] insert image into db - windows batch

Look like script for different platform, but "od" and "tr" are available also for Win so I will try... > On Wed, 18 Jan 2012 13:30:49 +0100, Petr Láz?ovský > wrote: have windows batch working with sqlite, may I insert image into database and than read this images

Re: [sqlite] [sqlite-dev] System.Data.SQLite development

Jeffrey Becker wrote: > > I definitely have Professional. Is there some trick with visual studio to get > it to see the files defined in the targets? > I'm assuming you mean for the projects that use the targets file to define the list of included files. Unfortunately, no. That is a bug in

Re: [sqlite] insert image into db - windows batch

On 18 Jan 2012, at 11:13pm, Petr Lázňovský wrote: > Look like script for different platform, but "od" and "tr" are available also > for Win so I will try... I would probably look for a Windows version of 'hexdump'. Simon. ___ sqlite-users mailing

Re: [sqlite] insert image into db - windows batch

On Thu, 19 Jan 2012 01:16:26 +, Simon Slavin wrote: > >On 18 Jan 2012, at 11:13pm, Petr Láz?ovský wrote: > >> Look like script for different platform, but "od" and "tr" are available >> also for Win so I will try... > >I would probably look for a Windows version of

Re: [sqlite] insert image into db - windows batch

On Wed, Jan 18, 2012 at 8:16 PM, Simon Slavin wrote: > > On 18 Jan 2012, at 11:13pm, Petr Lázňovský wrote: > > > Look like script for different platform, but "od" and "tr" are available > also for Win so I will try... > > I would probably look for a Windows version of

Re: [sqlite] insert image into db - windows batch

On Thu, Jan 19, 2012 at 1:49 AM, Kevin Benson wrote: > On Wed, Jan 18, 2012 at 8:16 PM, Simon Slavin wrote: > >> >> On 18 Jan 2012, at 11:13pm, Petr Lázňovský wrote: >> >> > Look like script for different platform, but "od" and "tr" are >>

[sqlite] SQLite API for counting number of records in a table.

Hi Friends, Is there an SQLite API for counting number of records in a table. Ex: StudentNameRollNo sub1sub2sub3 total avg abcd 188 99 88

Re: [sqlite] SQLite API for counting number of records in a table.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 18/01/12 23:47, bhaskarReddy wrote: > Is there an SQLite API for counting number of records in a table. No, but that is because regular SQL will do the trick: SELECT COUNT(*) FROM table; Roger -BEGIN PGP SIGNATURE- Version: GnuPG