Re: [sqlite] Most appropriate Web based database? (Newbie)
Hi Len, The question you are asking is "loaded". Stay with the ansi SQL statements that SQLite supports and you will be okay. If you need to use the SQLite extensions now, you will have to write a "translator" in future - not too difficult. For an experienced programmer (which you will be if the situation you describe ever comes to pass) the answer is "use SQLite - it is a no brainer" Good Luck! At 10:13 AM 4/6/06 -0700, you wrote: > >Thanks for your reply Richard > >After further Googling and reading the replies I've received here I am >coming around to the idea that SQLite probably is the best choice. > >I would like to know whether - at some point in the future should it be >necessary - I could convert my entire SQLite databases including tables etc >to another RDMS such as MySQL? Is this straightforward or convoluted? > >Regards >Len >-- >View this message in context: http://www.nabble.com/Most-appropriate-Web-based-database-%28Newbie%29-t1404 628.html#a3788822 >Sent from the SQLite forum at Nabble.com. > > Sincerely, Ed Porter
Re: [sqlite] Re: Select with left outer join - Am I going mad or just having a bad day?
Hi Ian, This one has been interesting! I'm trying to repeat the problem with several different databases - so far no luck. I use SQLite 2.8xx (project is already ongoing) and will test when I have time. I will post results if I find anything of value. At 06:41 PM 3/21/06 +, you wrote: > >On 21 Mar 2006, at 18:11, Ed Porter wrote: > >> Hi Ian, >> >> You nee to use a Full Outer Join. I don't know if SQLite has this >> function. >> >> > >Nah, definitely only wanted a left outer, didn't want the results >multiplied up or anything, just wanted every Category and any Cases >if matching the criteria. > >It was solved by moving the where clause up into an AND on the join, >seems that the where clause choking the result set from the outer >join. Never seen this before, but then again I've generally used "old >style" syntax joins (in the where clause), not ANSI, so I'm a bit new >to how the where clause can effect the results of an ANSI join. But >I'm learning! > >Thanks for your response though Ed, much appreciated. > >Regards, >-- >Ian M. Jones >_______ >IMiJ Software >http://www.imijsoft.com >http://www.ianmjones.net (blog) > > > Sincerely, Ed Porter
Re: [sqlite] Storing text in sqlite vs. external flat file
Hi Ken I found that performance began to fail miserably as the blob size increased above 500 bytes (has anyone else experienced this problem?). When I posted the problem, I think that someone stated the docs show the reasonable limit on blobs is 230 bytes. Anyways, I had to store the blobs direct to disk and use SQLite to track the addresses (no different than Oracle, MSSQL, MySQL etc). Please notify if you can get your system to work! At 01:21 PM 9/10/04 -0700, [EMAIL PROTECTED] wrote: >I am looking into using sqlite for storing some data that will be ~100,000 >records in size, where each record will contain text that has an average >size of 40k, but could be > 200k. I will likely need to encrypt (and >potentially compress) the database. > > > >My question is whether to store the text in the database, or to keep a >separate file for the text with seek pointers and lengths in the database. >My preference is for the former, since I wouldn't have to manage a separate >robust encryption/compression/deletion process, but I am concerned about the >perf and size of the insertion stress experiments I've been running, and >I've seen comments on this list suggesting the latter for BLOBs. Are there >specific tuning tweaks I can make to improve my results? > > > >Thanks, > >Ken Cooper > > Sincerely, Ed Porter
Re: [sqlite] ANN: SQLiteDB, a COM wrapper around sqlite has been released
HI George, I have tested the SQLiteDB for Visual Basic. I find it to be excellent - it has raised the standard for VB wrappers exponentially. I will be changing over all our new applications to this product - please keep it standardized as I will be posting references to it all over the 'Net. Again, thanks for developing an excellent product! At 09:23 AM 7/22/04 +0300, George Ionescu wrote: >Hello SQLite users, >and VB sqlite users, > >I have just released SQLiteDB, a COM wrapper around sqlite written in ATL. Go get your copy from http://www.terrainformatica.com/users/george (note that the link will change in a few days to http://www.terrainformatica.com/SQLiteDB). > >You will also get some samples written in VB: SQLiteImport, a tiny database import utility, SQLiteBenchmark - compare SQLiteDB's performance with an Access database (ADO/JET) and SQLiteMultiThread - hammer an sqlite database by reading data from multiple threads. > >Best regards, >George Ionescu Sincerely, Ed Porter
[sqlite] Saving BLOBs in Sqlite
Dear sirs, I am trying to develop techniques to save BLOBs in Sqlite. What is the best way to save jpg(S), bmp(s), etc? Would it be best to use GetBitmapBits ("gdi32" library) and then save to Sqlite as a byte array or is there a more efficient method? I am new to Sqlite but it seems to be an amazing tool! I look forward to any help and I thank you in advance for your input. Sincerely, Ed Porter - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]