Re: [sqlite] sqlite3_prepare memory leak

> Looks like the problem is from your app indeed. Again, what does > _CrtDumpMemoryLeaks() say? I really don't see any way to use _CrtDumpMemoryLeaks(). It always shows hundreds of blocks even if I'm sure that nothing was allocated (no malloc or new). I know that this is not a place to learn how

Re: [sqlite] Is there Roadmap

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Avinash Mittal wrote: > Is there any roadmap made for SQLite? What specifically do you find missing? > I couldn't found any specific things on wiki or any othere site. You can track the changes to the code, wiki and tickets here:

[sqlite] Is there Roadmap

Hi All, Is there any roadmap made for SQLite? I couldn't found any specific things on wiki or any othere site. Thanks & Regards Avinash ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3 hangs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Muratet wrote: > I built sqlite > from the aggregate code but my python project hangs. There is a specific mailing list for Python with SQLite - see http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite > So, I tried to >

Re: [sqlite] Verifying install

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Muratet wrote: >> [EMAIL PROTECTED] src]# ldd /usr/local/bin/sqlite3 >> linux-gate.so.1 => (0xe000) >> libdl.so.2 => /lib/libdl.so.2 (0x00c5a000) >> libc.so.6 => /lib/tls/libc.so.6 (0x00af3000) >> /lib/ld-linux.so.2

Re: [sqlite] Sqlite concurrency problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul Clarke wrote: > So one can share one open raw database connection across multiple threads can > you? That is true in theory but there are some issues in practise. For example there is currently no thread safe way to get error messages (being

Re: [sqlite] Verifying install

On Nov 4, 2008, at 4:55 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Michael Muratet wrote: >>> The image in the directory is version 3.6.4, but the image that gets >>> installed is 3.3.6. How can that be? > > Best guess is that the shell binary is from 3.6.4 but

[sqlite] sqlite3 hangs

Greetings I have been trying to get sqlite-3.6.4 to work for a python project I'm building on a Dell eight-core running RedHat ES3. I built sqlite from the aggregate code but my python project hangs. So, I tried to use it from the command line and noticed that the version was 3.3.6. It

Re: [sqlite] VFS implementation guidance

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brown, Daniel wrote: > Is it possible to change the VFS SQLite is using while SQLite is > running? You can call sqlite3_vfs_register/unregister at any point. Note that SQLite does no inuse tracking so it will happily let you unregister a VFS

Re: [sqlite] Verifying install

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Muratet wrote: >> The image in the directory is version 3.6.4, but the image that gets >> installed is 3.3.6. How can that be? Best guess is that the shell binary is from 3.6.4 but the shared libraries it picks up are 3.3.6. Run `ldd

Re: [sqlite] No module named sqlite3

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > unable to import Sqlite API: No module named sqlite3 You are missing the module that binds Python to SQLite. It comes as standard with Python but is only built if SQLite is already on the machine. Chances are you can

Re: [sqlite] VFS implementation guidance

I would start with an existing VFS implementation and modify it to use the primitives available to you. I started with the OS_WIN and modified it. That will probably be easier than starting from scratch. You can switch VFSs with each open. You can use a different one for each DB open if you

Re: [sqlite] VFS implementation guidance

Thanks for the pointers Roger and the example tests. Is it possible to change the VFS SQLite is using while SQLite is running? I'm looking at creating two different VFS implementations and it would be great to be able to switch between implementations as required, I'd be looking to switch VFS

Re: [sqlite] offical full list of valid data types?

"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I found an offical mention here: > http://www.sqlite.org/datatype3.html > > but seems not a "full list", because it only mention some > "Affinity". I want a full list of ALL VALID data types that sqlite > really support

Re: [sqlite] JOIN problem (works in postgres)

Ludvig Strigeus <[EMAIL PROTECTED]> wrote: > The following query does not work in Sqlite: > > SELECT i.user, ia.key, ia.value > FROM invite AS i > JOIN (invite AS j JOIN users AS u ON j.user = u.id AND > u.canonical_username='ludde') ON i.parent = j.id > LEFT JOIN inviteattr as ia ON

Re: [sqlite] offical full list of valid data types?

"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I found an offical mention here: > http://www.sqlite.org/datatype3.html > > but seems not a "full list", because it only mention some > "Affinity". I want a full list of ALL VALID data types that sqlite > really support

Re: [sqlite] offical full list of valid data types?

灵感之源 <[EMAIL PROTECTED]> writes: > > Hi, > > I found an offical mention here: http://www.sqlite.org/datatype3.html > > but seems not a "full list", because it only mention some "Affinity". I > want a full list of ALL VALID data types that sqlite really support, here > is my result,

Re: [sqlite] Problem with dates

If anyone is interested in knowing how to do this please let me know Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: [EMAIL PROTECTED] -Original Message- From: "Timothy A. Sawyer" <[EMAIL PROTECTED]> Date: Tue, 4

Re: [sqlite] VFS implementation guidance

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brown, Daniel wrote: > Are there any guides to implementing a VFS (sqlite3_vfs) for SQLite? A > good practices guide would be as useful. I already have an existing > file system API/library for the target system so I guess it is mostly > just

Re: [sqlite] Problem with dates

Thanks. Changing the date format when exporting from Access seems to have done the trick. Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

[sqlite] VFS implementation guidance

Good morning list, Are there any guides to implementing a VFS (sqlite3_vfs) for SQLite? A good practices guide would be as useful. I already have an existing file system API/library for the target system so I guess it is mostly just matching up the API with the VFS implementation via some

Re: [sqlite] sqlite3_prepare memory leak - OT

> SQLite also does some "interesting" things with pointers. There are > a few areas of the code where an array of memory is allocated and > then the pointer is backed up a record (under-running the allocated > space) > to make the array 1-based rather than 0-based. All of the access is >

Re: [sqlite] sqlite3_prepare memory leak

On Mon, Nov 03, 2008 at 10:07:46AM -0500, Sherief N. Farouk scratched on the wall: > 99% of the time the leaks are due to API abuse. Post a small sample app > (that build and runs) exhibiting the behavior, if possible. What does > _CrtDumpMemoryLeaks() say? SQLite also does some "interesting"

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

> The problem is that I'm getting better performance on AMD machine with > ATA disk, > but 10 times slower on DualCore machine with SATA disk (both disks are > at 7200 rpm)... > I don't understand the source of this behaviour... OS? Tried VSTS profiler, VTune or the free CodeAnalyst to look at

[sqlite] JOIN problem (works in postgres)

Hello, The following query does not work in Sqlite: SELECT i.user, ia.key, ia.value FROM invite AS i JOIN (invite AS j JOIN users AS u ON j.user = u.id AND u.canonical_username='ludde') ON i.parent = j.id LEFT JOIN inviteattr as ia ON ia.invite = i.id; It complains about "no such

Re: [sqlite] simple? query problem

May be: select B.* from B left join A on a.id = b.id where A.id is null ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

Thank you, but I am aware of transaction, and I explicitly need to perform inserts out of transaction... The problem is that I'm getting better performance on AMD machine with ATA disk, but 10 times slower on DualCore machine with SATA disk (both disks are at 7200 rpm)... I don't understand

[sqlite] No module named sqlite3

Hi I am trying to install LEMON(LHC Era Monitering tool). It is a monitering toll for very large clusters, but I am doing it on experimental basis. It uses sqlite for querying. After installation of LEMON rpms, I have to run a command to create schema for database. # lemon-admin --backend=flat

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

First, wrap your inserts into a BEGIN...COMMIT transaction. Expect the machine with the fastest disk rotation to perform the inserts fastest. Darko Filipovic wrote: > Hello, > > I'm having following situation: > Table: > CREATE TABLE TEST_TABLE ( > COL1 INTEGER(20) NOT NULL, > COL2

Re: [sqlite] offical full list of valid data types?

Sqlite does not have those types, it establishes type according to data, influenced by the affinity (numeric, string...). The declared type can be anything chosen by the application. The affinity is established by the declared type. Read the Sqlite documentation to get an understanding of the

Re: [sqlite] offical full list of valid data types?

thanks guys, I got it. I am making a data convert function for my free tool, so I need an official list, I mean the sqlite engine, not other wrappers. just curious abou it. 2008/11/4, Brad Stiles <[EMAIL PROTECTED]>: > > >I found that the ado.net provider for sqlite support some types that

Re: [sqlite] offical full list of valid data types?

>I found that the ado.net provider for sqlite support some types that do > not really match the substrings here > http://sqlite.phxsoftware.com/forums/t/31.aspx That wrapper does some mapping between a type that's declared in the table definition, and the types used in .NET programs. So, if

Re: [sqlite] Sqlite concurrency problem

Thanks I think that may be the problem. So one can share one open raw database connection across multiple threads can you? I had (wrongly) assumed that one had to open one such connection for each thread Many thanks Paul Clarke Project LastMile IT Location: Level B offices, Hatfield CFC

Re: [sqlite] offical full list of valid data types?

On Tue, 4 Nov 2008 18:42:31 +0800, <[EMAIL PROTECTED]> wrote : >Hi, > > I found that the ado.net provider for sqlite support > some types that do not really match the substrings here > http://sqlite.phxsoftware.com/forums/t/31.aspx > >any idea? I can only repeat what I said about _native_

[sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

Hello, I'm having following situation: Table: CREATE TABLE TEST_TABLE ( COL1 INTEGER(20) NOT NULL, COL2 INTEGER(20) NOT NULL, COL3 REAL(30,10), COL4 REAL(30,10), COL5 REAL(30,10), COL6 REAL(30,10), COL7 REAL(30,10), COL8 REAL(30,10), COL9 REAL(30,10), COL10

Re: [sqlite] Verifying install

On Nov 2, 2008, at 2:07 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Michael Muratet wrote: >> Can someone please tell me where I could start looking for the >> problem? > > You seem to be mixing system supplied SQLite libraries, your own > compiled ones and

Re: [sqlite] offical full list of valid data types?

Hi, I found that the ado.net provider for sqlite support some types that do not really match the substrings here http://sqlite.phxsoftware.com/forums/t/31.aspx any idea? COUNTER DbType.Int64 AUTOINCREMENT DbType.Int64 IDENTITY DbType.Int64 LONG DbType.Int64 TINYINT DbType.Byte INTEGER

Re: [sqlite] offical full list of valid data types?

On Tue, 4 Nov 2008 10:24:18 +0800, <[EMAIL PROTECTED]> wrote : >Hi, > >I found an offical mention here: http://www.sqlite.org/datatype3.html It is all on that page. Datatypes are dynamic. In general, the value inserted determines the type, not the column definition. >but seems not a "full

Re: [sqlite] sqlite3_prepare memory leak

I figured up, that in my main app, when I don't make nested queries no memory leaks. In simple app no matter id I use nested or strait queries memory does not leak. For example: sprintf( lpbuf, "SELECT tagList FROM overlay WHERE modalityID=%d " "AND

Re: [sqlite] sqlite3_prepare memory leak

Hi, I have written simple app that does the same query on the same database and I have no memory leaks !?! I build two apps with similar options (f.e. multithreaded debug dll) but my main app is written in winapi and "simple" app as console app. I have really no idea what can make these two act