Re: [sqlite] extracting domain names from website addresses efficiently

sqlite.org/cgi-bin/mailman/listinfo/sqlite-users I'm with you. This seems like using the wrong tool for the job. Sure it can work but it's probably not the most efficient way. -- Tegmailto:t...@djii.com ___ sqlite-users m

Re: [sqlite] Seeking advice on improving batch sql update performance on zipvfs

all the time. We also YW> created index: >> CREATE INDEX DS_INDEX ON ITEM(DS); YW> There are 30 million records. Zipvfs size of 471mb vs uncompressed db (the YW> one shipped with Android 4.2) size of 1.39gb. YW> Zipvfs db using zlib and aes128, which are default. YW> Thanks

Re: [sqlite] How to get row number of an ID in sorted results

mailing list MK> sqlite-users@mailinglists.sqlite.org MK> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Protecting databases

course can be read and accessed elsewhere. DSL> Are there any other options available for doing this? DSL> Any help appreciated. DSL> Thanks. DSL> Damien. DSL> ___ DSL> sqlite-users mailing list DSL> sqlite-users@mai

Re: [sqlite] Using too much memory to execute an update query

_mes integer DAD> ); //14M rows DAD> CREATE UNIQUE INDEX favorecidos_nis_idx ON favorecidos(nis); DAD> Cheers ! DAD> ___ DAD> sqlite-users mailing list DAD> sqlite-users@mailinglists.sqlite.org DAD> http://mailinglists.sqlite.org/cg

Re: [sqlite] Slow Sqlite3 Select Query while Insert/Update/Delete has no issue

; but I am not able exactly understand the implementation. S> I hope I have been able to describe my whole situation. Running Select S> query is a must for me. Please help. S> Regards S> Shailendra Kumar S> +91-9015602289 S> ___ S> sqlite-users mailing list S> sqlite-users@mailinglists.sqlite.org S> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

ISTS qposn ( KOG> qposn CHAR(64) PRIMARY KEY ON CONFLICT ROLLBACK, KOG> qmaxval INT, KOG> qmove INT, KOG> qminval INT, KOG> qstatus INT KOG> ); KOG> .separator " " KOG> .import am.all qmoves KOG> ALTER TABLE qmoves ADD COLUMN qstatus INT DEFAULT NUL

[sqlite] Using SQLite for storing photo's

When I am going to do that, CW> they will become much bigger.) So I would like to have my photos split out CW> when making the dump. CW> But maybe it will be better to use external blobs. CW> Something to think about. -- Tegmailto:Teg at djii.com

[sqlite] Encrypt the SQL query

bin/mailman/listinfo/sqlite-users -- Tegmailto:Teg at djii.com

[sqlite] Can SQLite be used from DLL

e small demo if you need a code to look at. IK> Thank you. IK> ___ IK> sqlite-users mailing list IK> sqlite-users at mailinglists.sqlite.org IK> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:Teg at djii.com

[sqlite] Storing Images in Blobs - Best Practices

eeded. RJ> Any thoughts are gratefully accepted. RJ> RJ> Joseph Rooney RJ> Team Lead - Mobile Development RJ> CommScope, Inc. RJ> Hickory, NC RJ> 828-315-2920 Ext: 52920 RJ> ___ RJ> sqlite-users mai

[sqlite] problem on Windows using filenames with non-ASCII characters

/Tk suite, have not problem, I wonder whether sqlite3.exe HJ> handles the file name correctly. HJ> Regards, HJ> Holger -- Tegmailto:Teg at djii.com

[sqlite] SQLite crashing

itionalDependencies) IK> Is there an easy way to fix this? IK> Thank you. >> >> >> Regards, >> Clemens >> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqli

[sqlite] SQLite crashing

e each DLL has its own copy of the RTL.I'm not clear how using /MD or /MDd impacts this. I don't use Sqlite the way you're trying to. I static link a copy and the wrapper into each application so there are no DLL boundaries to contend with. Monday, January 25, 2016, 11:30:00 PM, you wrote: IK>

[sqlite] SQLite crashing

ne of code makes it crash. C Monday, January 25, 2016, 1:00:53 PM, you wrote: IK> Hi, Teg, IK> On Mon, Jan 25, 2016 at 11:31 AM, Teg wrote: >> Hello Igor, >> >> MainFrame::~MainFrame() >> { >> delete m_db; // this is where the crash happens >> }

[sqlite] SQLite crashing

Hello J, I don't typically use "new" in my C++ applications other than in startup to allocate things that last the life of the application. So, I don't have any issues with double-freeing. I never manually "new" objects after startup. Instead I use containers to contains my objects and leave the

[sqlite] SQLite crashing

; Moreover I don't understand why am I getting the assertion - there is no >>> MT >>> involved. >>> >>> Can someone shed some lights? >>> >>> Thank you. >>> _______ >>> sqlite-users mailing list >>> sqlite-users at mailinglists.sqlite.org >>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >>> >> >> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users IK> ___ IK> sqlite-users mailing list IK> sqlite-users at mailinglists.sqlite.org IK> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:Teg at djii.com

[sqlite] Performance problems on windows

Hello Jakub, Windows user here. I use Sqlite to contain some fairly bulky data but the tables that store this data are simple and the queries and indexes are also simple. Using a 300 meg test file, I fed data into fresh DB's using different versions of Sqlite including some of the ones you listed

[sqlite] SQLite3 to 64-bit DLL

ers at mailinglists.sqlite.org pac> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:Teg at djii.com

[sqlite] Fwd: Problem with SQLite in C++. DB is BUSY (Multithread)

g for you! However, is reading gonna c> blocked by writing in journal mode? I thought that is the sqlite documents mentioned. >> Date: Tue, 11 Aug 2015 00:41:50 -0400 >> From: Teg at djii.com >> To: chaihua_sina at hotmail.com >> CC: sqlite-users at mailinglists.sql

[sqlite] Fwd: Problem with SQLite in C++. DB is BUSY (Multithread)

ting errors from the first connection. >> >> Please help me to solve this problem. >> >> P.S. Sorry for my bad English >> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users c> c> ___ c> sqlite-users mailing list c> sqlite-users at mailinglists.sqlite.org c> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:Teg at djii.com

[sqlite] Could frequent 'database is locked' errors mean SQLite is not a good fit for my application?

/mailman/listinfo/sqlite-users >> KA> ___ KA> sqlite-users mailing list KA> sqlite-users at mailinglists.sqlite.org KA> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:Teg at djii.com

[sqlite] Sqlite download page links AWOL

associated libraries along >> with the correct interop dlls >> -- >> >> Jeff K. Steinkamp (N7YG) >> Tucson, AZ >> Scud Missile Coordinates >> N32.2319 W110.8477 >> >> < >> https://www.postbox-inc.com/?utm_source=email_medium=siglink_campaign=rea

[sqlite] Sqlite download page links AWOL

Hello 'General, Used to be I could go to the download page: http://www.sqlite.org/download.html Click a link then download a zip file with the current version. What I see now is: Build Product Names ...followed by some text. Source Code Repositories ...with links to other pages that

[sqlite] sqlite3 and Unicode

PH> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:Teg at djii.com

[sqlite] problem compiling std_call dll

erlooking something simple and silly, but just can't figure it out. >> > Any ideas what could be the problem here? >> > >> > >> > RBS >> > ___ >> > sqlite-users mailing list >> > sqlite-users at mailinglists.sqlite.org >> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> BS> ___ BS> sqlite-users mailing list BS> sqlite-users at mailinglists.sqlite.org BS> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto:Teg at djii.com

Re: [sqlite] Uncached performance

Hello Donald, DG> 1) Might there be further performance gains by placing the blobs in a DG> separate table? DG> E.g. DG> CREATE TABLE myBlobs ( DG> idINTEGER PRIMARY KEY REFERENCES global (id), DG> value BLOB DG> ); DG> Then (if you haven't rebuilt a new

[sqlite] Without ROWID and Autoincrement question

Hello General, I was going to say I thought the docs were ambiguous but, on my 3rd reading I see they aren't. Still, I think this statement could be re-written to reduce confusion (at least mine). https://www.sqlite.org/autoinc.html >>Because AUTOINCREMENT keyword changes the behavior

Re: [sqlite] Performing a SELECT on an enormous database...

th databases this big? RA> Thanks! RA> Best, RA> Ross RA> ___ RA> sqlite-users mailing list RA> sqlite-users@sqlite.org RA> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Tegmailto

Re: [sqlite] Please fix the EBCDIC support

enough at >>> the code to see if the big-endian (z/OS) vs. little-endian (Intel) >>> storage of integers would also be a problem. >>> >>> >> We do cross-platform database portability tests between x86, sparc, and >> PPC, to verify that big-endi

Re: [sqlite] UTF support

t; ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> JD> ___ JD> sqlite-users mailing list JD> sqlite-users@sqlite.org JD> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reinstalling My Build Environment

PB> ___ PB> sqlite-users mailing list PB> sqlite-users@sqlite.org PB> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] GUI INfo

nce, MN> Max MN> MN> ___ MN> sqlite-users mailing list MN> sqlite-users@sqlite.org MN> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com __

Re: [sqlite] What if OpenDocument were built atop SQLite?

build better application file formats for future projects. It might be too late in the game but, I would have preferred this to zips for sure. Teg mailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mixing journal modes from different threads

n/mailman/listinfo/sqlite-users >> GI> _______ GI> sqlite-users mailing list GI> sqlite-users@sqlite.org GI> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Questions from a novice - basic browsing of records in a listview.

e columns of the values that were returned. SS> So all you have to do is remember what you asked for. SS> Simon. SS> ___ SS> sqlite-users mailing list SS> sqlite-users@sqlite.org SS> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Load time performance

tended recipient(s). Any review or distribution HR> by others is strictly prohibited. If you are not the intended HR> recipient, please contact the sender and delete all copies. HR> _______ HR> sqlite-users mailing list HR> sqlite-users@sqlite.org HR> http://sqlite.org

Re: [sqlite] Reading compressed database files

d. If you are not the intended HR> recipient, please contact the sender and delete all copies. HR> _______ HR> sqlite-users mailing list HR> sqlite-users@sqlite.org HR> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best

Re: [sqlite] Retrieve a int or a sqlite_int64

harles CS> ___ CS> sqlite-users mailing list CS> sqlite-users@sqlite.org CS> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-user

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> HL> ___ HL> sqlite-users mailing list HL> sqlite-users@sqlit

Re: [sqlite] Long table fails to create with exec sql on windows 8.1

Hello Mark, >>System just stops responding. It's not clear if you're talking about the program or your PC. If the PC is hanging, it's broken and this isn't a software problem (well not a Sqlite problem). Anytime a PC running windows hangs or crashes, you know it's a driver or hardware

Re: [sqlite] Noticed crash on windows

>>Quite unlikely is the prospect for somebody here to say "Yes, we >>routinely see crashes on Windows in the sqlite3_mutex_enter code." >>You are going to have to debug this. This. I run the hell out of Sqlite under 32 and 64 bit windows with no issues. 20-40 GB databases are common with

Re: [sqlite] Windows service with SQLITE

hing to do with opening and accessing the DB. C Sunday, February 16, 2014, 11:45:27 PM, you wrote: tp> Hi Teg, tp> I tried putting delay of 3 seconds and 30 seconds but nothing happens. tp> Still not able to access database and store anything. tp> When i create a file to store data it sto

Re: [sqlite] Windows service with SQLITE

eless. tp> Thanks, tp> Tejas tp> ___ tp> sqlite-users mailing list tp> sqlite-users@sqlite.org tp> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

course, I'm always open to alternative suggestions on how to work around JM> issues like these in a portable and robust way. JM> -- JM> Joe Mistachkin JM> _______ JM> sqlite-users mailing list JM> sqlite-users@sqlite.org JM> http://sqlite.org:8080/cgi-b

Re: [sqlite] How to Troubleshoot Disk I/O Error

OB7L> Dan. AOB7L> ___ AOB7L> sqlite-users mailing list AOB7L> sqlite-users@sqlite.org AOB7L> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users AOB7L> _______ AOB7L>

Re: [sqlite] Application statically linked with sqlite3.6 creates sqlite2.1 files

ite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users JB> ___ JB> sqlite-users mailing list JB> sqlite-users@sqlite.org JB> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] store image file as blob

Best Regards, db> va. db> ___ db> sqlite-users mailing list db> sqlite-users@sqlite.org db> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com __

Re: [sqlite] SQLite and Virtual PC

qlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> >> SC> ___ SC> sqlite-users mailing list SC> sqlite-users@sqlite.org SC>

Re: [sqlite] sqlite3_bind_text truncates strings with "."

> ___ nmr> sqlite-users mailing list nmr> sqlite-users@sqlite.org nmr> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to save live data into sqlite database using c language?

um _protocols { C_PROTOCOL_TCP, C_PROTOCOL_UDP, .. }; CREATE TABLE host ( Src_MAC char(18), Src_IP char(16), Cap_Bytes integer, Protocol integer, ); With a single protocol tag per insert. Then you tag each packet insert with the protocol field. -- Best regards, Teg

Re: [sqlite] Writing in a blob

>>Imagine what could happen if, for example, git where to start using this >>library. Instead of the ".git" directory containing lots and lots of >>separate files, your repository would be a single ".git" file which was >>really an SQLite database accessed through the "sqlite3fs" wrapper. I use

Re: [sqlite] SQLite 3.7.17 preview - 2x faster?

RH> or not it even works for you, is very important to us. Thanks for giving RH> the new code a try. -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Saving ubyte[] zlib data in sqlite and calling it back

ta in jic> SQLite and also call it back. Thoughts? Comments? Jokes? :-) jic> thanks. jic> josé jic> ___ jic> sqlite-users mailing list jic> sqlite-users@sqlite.org jic> http://sql

Re: [sqlite] bug report: out of memory error for most operations on a large database

t; TEMP_STORE ("PRAGMA compile_options;")? CL> Regards, CL> Clemens CL> ___ CL> sqlite-users mailing list CL> sqlite-users@sqlite.org CL> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --

Re: [sqlite] Running on windows 98

t it would not require explicit support and testing GG> of Win9x since its the option being supported rather than the platform GG> support. GG> ___ GG> sqlite-users mailing list GG> sqlite-use

Re: [sqlite] performance regression when using "insert or replace"

35541 if( subjRequiresPage(pPg) ){ >> 35542 rc = subjournalPage(pPg); >>35543 } >> from gdb... >> - (gdb) p *pPg >>$17= {pPage = 0x2b84618, pData = 0x2b83618, pExtra = >> 0x2b84698, pDirty = 0x0, pPager = 0x2b666c8, >> pgno = 6, flags = 6, nRef = 1, pCache = 0x2b667d0, >> pDirtyNext = 0x2b83540, pDirtyPrev = 0x0} >>(gdb) p pageInJournal(pPg) >>$18 = 1 >>(gdb) p >> sqlite3BitvecTest(pPager->aSavepoint[0]->pInSavepoint,6) >>$19 = 0 >> >>- therefore we end up CALLING subjournalPage(pPg) from line 35542, >> causing temp file to be created and lots of small writes to the >> file >> >> >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users DK> ___ DK> sqlite-users mailing list DK> sqlite-users@sqlite.org DK> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Windows (slow) vs. iOS/OSX (fast) Performance

lite.org:8080/cgi-bin/mailman/listinfo/sqlite-users DdR> ___ DdR> sqlite-users mailing list DdR> sqlite-users@sqlite.org DdR> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users DdR> _

Re: [sqlite] VC++ and SQLite

te-users mailing list AO> sqlite-users@sqlite.org AO> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users AO> ___ AO> sqlite-users mailing list AO> sqlite-users@sqlite.org AO> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg

Re: [sqlite] First time poster: need advise

IK> _______ IK> sqlite-users mailing list IK> sqlite-users@sqlite.org IK> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Store error messages in thread local memory

8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > -- >> > > > D. Richard Hipp >> > > > d...@sqlite.org (mailto:d...@sqlite.org) >> > > > ___ >> > > > sqlite-users mailing list >> > > > sqlite-users@sqlite.org (mailto:sqlite-users@sqlite.org) >> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > >> > > >> > > >> > > >> > > >> > > ___ >> > > sqlite-users mailing list >> > > sqlite-users@sqlite.org (mailto:sqlite-users@sqlite.org) >> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > >> > >> > >> > >> > >> > >> > -- >> > D. Richard Hipp >> > d...@sqlite.org (mailto:d...@sqlite.org) >> > ___ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org (mailto:sqlite-users@sqlite.org) >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> >> >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org (mailto:sqlite-users@sqlite.org) >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org (mailto:sqlite-users@sqlite.org) >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> SK> ___ SK> sqlite-users mailing list SK> sqlite-users@sqlite.org SK> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Compile Bug for Windows 8

to compile in C++ mode? SQLite is IT> written in C, where such a cast is not required. Yeah, I'm building under Win8 with no issue. -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.o

Re: [sqlite] SQLITE in a Win7 Service Application

restrictions on the database folders or files. mr> Does anyone know about this and / or has a solution? mr> Kind regards mr> Markus mr> ___ mr> sqlite-users mailing list mr> sqlite-users@sqlite.org mr> http://sqlite.org:80

Re: [sqlite] I consider this a bug. Anyone else?

; sqlite-users mailing list SS> sqlite-users@sqlite.org SS> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with including sqlite3.c into c++ project

AD> Do not use precompiled headers on sqlite3.c This. My Sqlite is in it's own library project so, it can have different precompiled header settings than my other projects. About 80% of my projects use procompiled headers, the other 20 are typically made of code like Sqlite which don't have

Re: [sqlite] intial database creation

Hello Brett, All of my DB's are generated in code. When I version control the code, I'm also version controlling the schema. If my users end up with bad DB's (it's windows, it happens fairly frequently). They just delete them and they're then re-created as needed by the program. I have specific

Re: [sqlite] Visual Studio 2008 Express and sqlite3.c

ot; or "regexp" */ >> int not; /* True if the NOT keyword is present */ >> }; >> >> >> Thanks, >> Nick. >> -- >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org

Re: [sqlite] Could/should Windows build of SQLite use #define WIN32_LEAN_AND_MEAN?

_ JR> sqlite-users mailing list JR> sqlite-users@sqlite.org JR> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sq

Re: [sqlite] VIsual Studio 2005. slow and high CPU in debug

;Is there some option in SQLite to avoid this problem? JP> Thank you very much in advance. JP> ___ JP> sqlite-users mailing list JP> sqlite-users@sqlite.org JP> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Cyrillic support

->UTF8 - insert >>Select - UTF8->UTF16 JCD> There are 16-bit SQLite APIs for that, no conversion needed JCD> actually. But of course it all depends of the wrapper you use, if any. -- Best regards, Tegmailto:t...@djii.com __

Re: [sqlite] Cyrillic support

?? M> Thanks M> ___ M> sqlite-users mailing list M> sqlite-users@sqlite.org M> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com __

Re: [sqlite] Bug hunting in SQLite

_ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> ___ >> sqlite-users mailing list >> sqlite-users@sqli

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

qlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users PL> ___ PL> sqlite-users mailing list PL> sqlite-users@sqlite.org PL> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@

Re: [sqlite] 3.7.9 amalgamation file in VS2005

http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users AN> ___ AN> sqlite-users mailing list AN> sqlite-users@sqlite.org AN> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.7.9 amalgamation file in VS2005

>> >> Alex >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL file size

Hello Richard, Thanks again. Wednesday, November 30, 2011, 5:37:32 PM, you wrote: RH> On Wed, Nov 30, 2011 at 5:31 PM, Teg <t...@djii.com> wrote: >> Since we're on this topic >> >> If I open a 30 GB DB file, then attach a new empty DB and then >>

Re: [sqlite] WAL file size

of course. SS> Simon. SS> ___ SS> sqlite-users mailing list SS> sqlite-users@sqlite.org SS> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users

Re: [sqlite] WAL file size

Hello Richard, That's what I was hoping to hear. Thanks, Wednesday, November 30, 2011, 2:01:46 PM, you wrote: RH> On Wed, Nov 30, 2011 at 1:39 PM, Teg <t...@djii.com> wrote: >> Hello Richard, >> >> Appreciate the reply but, it doesn't address my question (unless I

Re: [sqlite] WAL file size

, November 30, 2011, 1:10:50 PM, you wrote: RH> On Wed, Nov 30, 2011 at 1:04 PM, Teg <t...@djii.com> wrote: >> Hello Richard, >> >> When does the WAL get trimmed down? If my transaction completes, does >> the WAL file get deleted? I've seen the WAL grow to 4 t

Re: [sqlite] WAL file size

>> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> -- Best regards, Tegmailto:t...@djii.com ___

Re: [sqlite] Problems with SQLite when used with MPI

tp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL and local UNC filenames

other process works with database, thus database can be corrupted in PI> many possible ways. PI> Pavel PI> ___ PI> sqlite-users mailing list PI> sqlite-users@sqlite.org PI> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best

Re: [sqlite] does sqlite3_reset have a performance impact onqueries?

Advanced Analytics Directorate BMI> Advanced GEOINT Solutions Operating Unit BMI> Northrop Grumman Information Systems BMI> ___ BMI> sqlite-users mailing list BMI> sqlite-users@sqlite.org BMI> http://sqlite.org:8080/c

Re: [sqlite] core dump happened in sqlite3_step for 30 statements in BEGIN TRANSACTION executing every 10 Millisecond

; #14 0x32f39b88 in clone () from /lib/libc.so.6 CH> ___ CH> sqlite-users mailing list CH> sqlite-users@sqlite.org CH> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using SQLite on Windows 64bit

_ AO> sqlite-users mailing list AO> sqlite-users@sqlite.org AO> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing lis

Re: [sqlite] How about a proper forum rather than an e-mail list

FM> Well, just a thought. FM> FM> FM> /Frank Missel FM> ___ FM> sqlite-users mailing list FM> sqlite-users@sqlite.org FM> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg

Re: [sqlite] Internal v. External BLOBs

ete report is here: >> http://www.sqlite.org/intern-v-extern-blob.html >> >> -- >> D. Richard Hipp >> d...@sqlite.org >> _______ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/

Re: [sqlite] Strategies for protecting sql queries

PI> If someone was ambitious enough they could attach a debugger to your PI> application, extract key used to decrypt the database and obtain all PI> the sensitive information you have. So if you really want to protect PI> your database against those who is able to attach a debugger you PI>

Re: [sqlite] SQLite + unicode

", callback, 0, ); N> this code return char I want use wchar_t* for read unicode. N> Thanks! -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Read only scaling optimization

ing? DK> Thank you in advance, DK> Drew DK> ___ DK> sqlite-users mailing list DK> sqlite-users@sqlite.org DK> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@d

Re: [sqlite] Deep copy of 2 sqlite3*?

://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Field drop work around

Regards, JH> Jack Hughes JH> ___ JH> sqlite-users mailing list JH> sqlite-users@sqlite.org JH> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] SQLite3.dll for Win 64

Hello Everton, EV> Don't have any easy way to make this dll? There's a lot of 64bits systems EV> out there that will need this dll. I just compile it into my program and don't bother with DLL's. I find that DLL's in general make my software less reliable so, I avoid them. Static linking all the

Re: [sqlite] Selected string differs to Inserted one

AL> sqlite-users mailing list AL> sqlite-users@sqlite.org AL> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA bug in 3.7.7 (but fine in 3.7.6.3)

!= SQLITE_OK) GS> printf("Error %d: %s\n", err, errmsg), sqlite3_free(errmsg); GS> } GS> return 0; GS> } GS> ]]] GS> _______ GS> sqlite-users mailing list GS> sqlite-users@sqlite.org GS> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regar

Re: [sqlite] Do I need to migrate to MySQL?

ly? >> >> (The video on that website at 2.04 gives a good idea of what kind of >> functions are being powered by the database). >> >> Thanks, >> Ian DD> _______ DD> sqlite-users mailing list DD> sqlite

Re: [sqlite] Compile error's on Visual Studio 2010

ing .c files JAK> with the C++ compiler, even though-- as this very example points JAK> out-- the languages are different enough that this behavior seems JAK> questionable. -- Best regards, Tegmailto:t

Re: [sqlite] Compile error's on Visual Studio 2010

; warning level? JB> JB> Jan JB> ___ JB> sqlite-users mailing list JB> sqlite-users@sqlite.org JB> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com

Re: [sqlite] how to reuse a prepared statement

I got bit by this the other day. I typically just used "reset" but, if you have a case where you're looping through an insert and you don't always set all values (say a string is empty sometimes so, you forgo the bind), the previous value set will get inserted where you expected blanks to go.

Re: [sqlite] SQLite3 memory leaks in my c++ dll application

gt;> >> Data: <5U/jyx2txHeUQUe/> 35 55 2F 6A 79 78 32 74 78 48 65 55 51 55 65 2F >> >> {7023} normal block at 0x013658D0, 32 bytes long. >> >> Data: 4E 65 74 77 6F 72 6B 53 65 74 74 69 6E 67 33 2E >>

  1   2   3   >