[sqlite] Multi-User design

[Chris Ulliott]

Hi All,
 
When using SQLite3 in a multi user environment is it better to have a
single table per database file or is it better to have just one file
which contains all tables in the database?
 
I am worried about the file locking, I do not want users to have to wait
for a table to become accessible just because another user is updating a
different table within the database.
 
What is the cost of performance if I put the tables into separate
database files?
 
Kind Regards,
 
Chris
 

[sqlite] SPLite3 compiling under MS VC6

[Chris Ulliott]

Hi All,
 
Does anyone have a VC6 project of the splite3 DLL. I would like the
ability to recompile it myself so that I can add my own specific changes
etc.. Also when a new release comes out I would like to take the new
code, do a comparison to my own, add the changes and re-compile again.
 
When I download the code for the DLL and do a compile I get lots of
warnings regarding the size of variables (which maybe ok to ignore but
they annoy me) and also after the DLL is compiled, zero functions are
exported!
 
Any help you could give me on compiling in VC6 would be very much
appreciated.
 
Thank you,
 
Chris
 

Re: [sqlite] SQLite and Windows 2k

[Chris Ulliott]

Andy!
 
FANTASTIC JOB! Thank you! Could you also make the source available
please and tell me what changes you made? In the future if a new version
comes out, it may not include your change and I need it!
 
I would hate to upgrade and loose your change...
 
Thanks again, Great work!
 
Chris
 
>Wahoo! Got it! It was a -mno-cygwin that was the magic. I have uploaded
it to my website. You can get it from
> 
http://squeakycode.net/files/sqlite3.dll
>I noticed the sqlite3.def was also missing sqlite3_changes, so I added
it too.
>Let me know if you have problems.
>-Andy

Re: [sqlite] SQLite and Windows 2k

[Chris Ulliott]

Hi Richard
 
Unfortionatly there is no link for a Compiled Binary (win 32) for
version 2.x on the downloads page otherwise I would be using it.
 
Thanks for replying.
 
Chris
 
 
 
Richard Boehme wrote:
 
The regular sqlite.dll should be the 2.X release, not the 3 release, and
therefore won't export sqlite3_exec, but will export sqlite_exec.

As for the other, I haven't played around with sqlite3 much as I'm in
the middle of a project, but I intend to in a couple of days.


Thank you.

Richard Boehme




Chris Ulliott wrote: 

Hi All,

I have downloaded from the downloads page the DLL (Sqlite.dll) for

Windows. I have written some code using the API and everything was going

great until I needed to do an execute and it came to my attention that

the DLL does not export sqlite3_exec

Does anybody have a Win32 DLL of SQLite 3 that exports all the

documented functions? Am I missing something else?

I also tried using the SQLite3.dll instead but I soon found that there

are NO EXPORTED FUNCTIONS from there whatsoever.

Any help appreciated,

Thanks,

Chris




-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]






-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] SQLite crashes during rapid inserts!

[Chris Ulliott]

Hi all,
 
I am using the SQLite DB with MS VC++ v 6. In the code below you can see
I am looping around a ODBC connection to an access database and I am
inserting those records into my new SQLite database. My problem is
SQLite.dll causes an access violation after inserting about 190 records.
Does anyone have any ideas what I am missing or if this is a bug?
 
Code...
 
 
  nRecord=0;
  while(pRs->EndOfFile == FALSE)
  {
   nRecord++;
 
   // Create Insert Command

   strCmd = _T("INSERT INTO SCHEMATABLES VALUES(");
   for(int nField = 0; nField < pRs->Fields->Count; nField++)
   {
var.lVal = nField;
var.ChangeType(VT_I2, NULL);
strCmd += _T("\"");
strCmd += pRs->Fields->GetItem(var)->Value.bstrVal;
strCmd += _T("\", ");
   }
   strCmd = strCmd.Left(strCmd.GetLength()-2);
   strCmd += _T(");\n");
 
 
   // SQLite .. Insert record into SQLLite Database
   nReturn = procPrepare(pResult, (LPCTSTR)strCmd, -1, &stmt,
&pRemainingSQL);
   nReturn = procStep(stmt);
 
   // MDB
   pRs->MoveNext();
  }
 
  pRs->Close();
 
  nReturn = procClose(pResult);
  str = procErrMsg(pResult);
 
Thank you in advance,
 
Chris
 

[sqlite] SQLite and Windows 2k

[Chris Ulliott]

Hi All,

I have downloaded from the downloads page the DLL (Sqlite.dll) for
Windows. I have written some code using the API and everything was going
great until I needed to do an execute and it came to my attention that
the DLL does not export sqlite3_exec

Does anybody have a Win32 DLL of SQLite 3 that exports all the
documented functions? Am I missing something else?

I also tried using the SQLite3.dll instead but I soon found that there
are NO EXPORTED FUNCTIONS from there whatsoever.

Any help appreciated,

Thanks,

Chris



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]