[sqlite] sqlite3_open16_v2 / ticket 2869

2009-09-06 Thread Sherief N. Farouk
Is there any reason not to incorporate the diff posted for ticket 2869 into the main branch and have sqlite3_open16_v2()? - Sherief ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] sqlite3_exec() documentation

2009-06-19 Thread Sherief N. Farouk
The documentation found at http://sqlite.org/c3ref/exec.html is unclear about some parts: is it possible to not request an error message (via passing NULL as the errmsg parameter)? And what are the possible return values? - Sherief ___ sqlite-users

Re: [sqlite] Problems with file locks on USB keys

2009-04-03 Thread Sherief N. Farouk
> Hi - it only happens on Windows systems that are using U3 USB keys. > None of > the queries are intensive - they are pretty simple and shouldn't take > longer > than a few milliseconds. > > On harddisks it *always* works. Never had an issue there. > Like Teg said, you can use procmon in

Re: [sqlite] A bit OT: Good CVS client for Windows

2009-02-26 Thread Sherief N. Farouk
On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote: > Can someone please give me a suggestion for a good client for CVS > that runs > under Windows? > > I have my linux system but figured it would be nice to have a client > in both > places, a belt and suspenders kind of

Re: [sqlite] A bit OT: Good CVS client for Windows

2009-02-26 Thread Sherief N. Farouk
Try TortoiseCVS. - Sherief On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote: > Can someone please give me a suggestion for a good client for CVS > that runs > under Windows? > > I have my linux system but figured it would be nice to have a client > in both > places, a

Re: [sqlite] Error message This program cannot be run in DOS

2009-02-08 Thread Sherief N. Farouk
> Here is what I did > > I downloaded > sqlite-3_6_10.zip 245,575 bytes > which unzipped to > sqlite3.exe501,456 Why not post a cryptographic hash of the exe file you have, and the output of the "ver" command when ran from your "command prompt". - Sherief

Re: [sqlite] codepages

2009-01-24 Thread Sherief N. Farouk
> dear users > I use sqlite for vb6, utf-8 database, > when insert arabic data to database > and search it with 'like' operator > (within % syntax), return all records!!! > Please help me... > thanks > John Smith > ___ Arabic, in general, is one hell of

Re: [sqlite] Transaction within script

2009-01-02 Thread Sherief N. Farouk
> SAVEPOINTs is the way PostgreSQL and MySQL do it, as well as many > other SQL database engines. We want to maximize compatibility. > > We have discussed letting you used named transactions using BEGIN. We > might add that in the future. But for now, SAVEPOINT seems to be the > safest way to

Re: [sqlite] Transaction within script

2009-01-02 Thread Sherief N. Farouk
> Preliminary documentation can be seen at > http://www.sqlite.org/draft/lang_savepoint.html Why savepoints? Why not just add support for named transactions? Is there some semantic difference I'm missing? - Sherief ___ sqlite-users mailing list

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-27 Thread Sherief N. Farouk
> The given code is correct. The lower-case string is a C# alias for the > System.String class. System.Int64 is an opaque 64-bit pointer value. Seems like the grasping deficiencies are on my side :D. > The code so far is correct. What is missing though is the calling > convention, which by

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-27 Thread Sherief N. Farouk
> I am calling now this: > > [DllImport("sqlite3.dll", CharSet = CharSet.Unicode)] > internal static extern System.Int64 sqlite3_open16(string > filename, out IntPtr handle); > > I now finds an entry point, but i returned to the previous error: > An attempt was made to read

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-26 Thread Sherief N. Farouk
> > It throws an exception: unable to find entry point sqlite3_open16 Try opening the DLL with Dependency Walker, make sure the entry point *is* there? - Sherief ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] CMAKE support for sqlite3

2008-11-25 Thread Sherief N. Farouk
> SET( CMAKE_INSTALL_PREFIX "f:/doof" ) This *will* cause problems for some people ;). Otherwise, I love CMake, so I'm all for this. Any chance a stable CMake file would be hosted on sqlite.org? - Sherief ___ sqlite-users mailing list

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-25 Thread Sherief N. Farouk
Does sqlite3_open fail too? - Sherief ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_prepare memory leak

2008-11-16 Thread Sherief N. Farouk
> Hi, > > Sherief, thank you for our kind help. You're welcome :). > I really did use globals. > I found a way to run DumpMemorLeaks after all globals and static > variables are deallocated, I used > _CrtSetDbgFlag(_CRTDBG_ALLOC_MEM_DF | _CRTDBG_LEAK_CHECK_DF); I should've RTFMed harder :(. >

Re: [sqlite] sqlite3_prepare memory leak

2008-11-05 Thread Sherief N. Farouk
> 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 to > use VC++. Maybe it's true that Deleaker just freaks out. I will try to > track it

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

2008-11-05 Thread Sherief N. Farouk
> I found that win function FlushFileBuffers (used by SQLite) slows down > performances, > but still don't have explanation why this funcion on some machines > works 10x slower then on others. > > I have used win xp sp2 on all machines where I have tested the > behaviour. Try using CodeAnalyst,

Re: [sqlite] sqlite3_prepare memory leak - OT

2008-11-04 Thread Sherief N. Farouk
> 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] Slow INSERT on fast machine, fast INSERT on slow machine

2008-11-04 Thread Sherief N. Farouk
> 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

Re: [sqlite] sqlite3_prepare memory leak

2008-11-03 Thread Sherief N. Farouk
> As you can see I use sqlite3_prepare/sqlite3_finalize pairs. My memory > leak checker ( Deleaker : www.deleaker.com ) reports memory leak at > sqlite3_prepare : > > msvcrt.dll!malloc > sqlite3.dll!sqlite3_malloc + 120 bytes > sqlite3.dll!sqlite3_realloc + 27 bytes >

Re: [sqlite] BLOB Incremental IO

2008-10-31 Thread Sherief N. Farouk
> I have a problem with BLOB writing. I need to write > some binary stream into sqlite table. As I understood, incremental > BLOB I/O requires space of constant size to be preallocated > with zeroblob, but I don't know the size of stream in advance. > And sqlite doesn't allow to change the size of

Re: [sqlite] SQLite on Nintndo DS?

2008-10-31 Thread Sherief N. Farouk
> I have the DevKit and all the goodies and am able to make the DS jump > though > hoops. But I always have trouble with SQLite. I'm one of those who gets > the > very irritating huge numbers of compile errors that have something to > do with > compiler version versus SQLite version versus header

Re: [sqlite] SQLite on Nintndo DS?

2008-10-30 Thread Sherief N. Farouk
> Has anyone used SQLite on the NintendoDS? Can it fit? Arm7 and ARM9 and > a > cartridge like an SD card. The database can be static in FLASH. But the > rest? > > -- Charlie Springer > [Sherief N. Farouk] If you have an official devkit, or care to grab a copy of the

Re: [sqlite] SQLITE_STATIC and bind*()

2008-10-13 Thread Sherief N. Farouk
> > Sqlite3_bind_text(Statement, S.c_str(), S.size() + 1, > > SQLITE_[TRANSIENT | STATIC?]); > > Drop +1. It's unlikely that you actually want terminating NUL to be > part > of the string in the database. > Sorry, mixed that one with the nByte parameter of prepare_v2. It's "-1" in code though,

[sqlite] SQLITE_STATIC and bind*()

2008-10-13 Thread Sherief N. Farouk
Does the bind text family attempt to access the data pointed to by the passed parameter after the lifetime of the function call? I have a situation similar to the following: Std::string S("Blah"); foo(S); Rest_of_program(); Where foo() is: Void foo(string& S) { //prepare a statement

Re: [sqlite] Compile SQLite3 for MS Windows Driver Kit user-modeapplication

2008-10-07 Thread Sherief N. Farouk
I agree with Michael. Some of these warnings can be stopped with trivially small code modifications, and they do try to prevent human error. Consider this line (from my 3.5.9 amalgamation): X1 = 365.25*(Y+4716); //X1 is an int Which produces the following warning in VC++2008: warning C4244: '='

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Sherief N. Farouk
> What do you mean by "Mapping". There are several api wrappers for > sqlite written in C++. See > http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers > After checking some of the things on that list, ruling out some for superficial reasons (like thinking that C++ is Java and writingLikeThis),

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Sherief N. Farouk
> Does anyone know of any tools that are either open source or reasonably > priced (less then 600 USD) for mapping SQLite to C++? > > Sam [Sherief N. Farouk] No tools that I know of, but I have a small bunch of classes that I wrote to wrap sqlite3 objects, in order to make some t

Re: [sqlite] prices

2008-09-21 Thread Sherief N. Farouk
se of licence of sqlite server > > kindly send me the detail > > arvind > systime [Sherief N. Farouk] Dear Pointy Haired Boss, Please let Dilbert handle this one instead. Best Regards, - Sherief (I'm sorry. I saw this and I just couldn't resist. I deserve everyt

Re: [sqlite] Vista frustrations

2008-09-17 Thread Sherief N. Farouk
ns very minimal, > but > Vista itself eats every last scrap of physical memory, forcing all > other > apps to the paging file trying to cache the contents of the database. [Sherief N. Farouk] Any chance you could make a small C program to reproduce this case (via procedurally creating

Re: [sqlite] Difference in performance between 32 and 64 bit versions of SQLite?

2008-09-01 Thread Sherief N. Farouk
I can't speak for SQLite, but off of the top of my head, a 64-bit platform will give you enough virtual address space to memory map the files, which usually proves to be a win. I'd say go with the 64-bit systems and as much ram as you can afford. - Sherief > -Original Message- > From:

Re: [sqlite] Hard time with blobs

2008-07-25 Thread Sherief N. Farouk
TECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of Dan > Sent: Friday, July 25, 2008 3:22 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Hard time with blobs > > > On Jul 25, 2008, at 12:05 PM, Sherief N. Farouk wrote: > > > I'm havi

Re: [sqlite] Hard time with blobs

2008-07-24 Thread Sherief N. Farouk
2008, at 10:35 AM, Sherief N. Farouk wrote: > > > I want to use blobs to store binary objects in the database, but > > I'm having > > a hard time understanding how they work. First of all, I don't see > > a way to > > set a blob's size, and sqlite3_blob_write doe

[sqlite] Hard time with blobs

2008-07-24 Thread Sherief N. Farouk
I want to use blobs to store binary objects in the database, but I'm having a hard time understanding how they work. First of all, I don't see a way to set a blob's size, and sqlite3_blob_write doesn't increase the size of the blob, which is putting me in a weird catch-22 situation. What's the

Re: [sqlite] Transaction Files / SQLite?

2008-07-23 Thread Sherief N. Farouk
nnis Cote > Sent: Wednesday, July 23, 2008 10:22 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Transaction Files / SQLite? > > Sherief N. Farouk wrote: > > > > Streams are parallel 'bags of bytes' of a file. As in, you can > > open(&quo

Re: [sqlite] Transaction Files / SQLite?

2008-07-23 Thread Sherief N. Farouk
ade things clearer. - Sherief > -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of Dennis Cote > Sent: Wednesday, July 23, 2008 9:46 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Transaction Files / SQLite? >

Re: [sqlite] Ignoring "The"

2008-07-23 Thread Sherief N. Farouk
Can you define a custom less-than operator for sorting? If this were C++, I'd do std::sort(Result.begin(), Results.end(), MyCustomOperator()); - Sherief > -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of Andrew Gatt > Sent: Wednesday,

[sqlite] Transaction Files / SQLite?

2008-07-23 Thread Sherief N. Farouk
I'm currently trying to port an application that does a lot of work based on two NTFS features: Streams, and Transactional NTFS. Since TxF is a HUGE feature, with a lot of potential pitfalls, I thought I might do this as a layer over SQLite: a db file with one table, multiple rows: one for each

Re: [sqlite] Scour.com invite from harish

2008-07-17 Thread Sherief N. Farouk
or airline points just for searching! Hit the link > below to join for free and we will both get points! > > http://scour.com/invite/harishdixit1/ > > I know you'll like it! > > - harish [Sherief N. Farouk] Are you, seriously: spamming a development mailing list, using your @

Re: [sqlite] problem compiling loadable extensions usingVisualStudio

2008-07-09 Thread Sherief N. Farouk
a > difference > between these two things, but it doesn't matter in this context where > all you want is to get an exported name exactly as it is in your code). > > Igor Tandetnik > [Sherief N. Farouk] The decoration is due to the stdcall convention (APIENTRY). It's in