Re: [sqlite] blob + rowID Insert question

, Carlos Ferreira wrote: > In the next line: > > UPDATE myTable SET theBlob = WHERE id = > > The "whatever" is a long string containing the data? The "whatever" should be ? (question mark) - a parameter placeholder ( could be another one). Prepare the statement, b

Re: [sqlite] blob + rowID Insert question

lite] blob + rowID Insert question On 28 Aug 2014, at 7:06pm, Carlos Ferreira wrote: > Is there any way to replace a BLOB for a give ROW ID? Use the UPDATE command: UPDATE myTable SET theBlob = WHERE id = Simon. ___ sqlite-users mailing list

Re: [sqlite] blob + rowID Insert question

2014, at 7:06pm, Carlos Ferreira wrote: > Is there any way to replace a BLOB for a give ROW ID? Use the UPDATE command: UPDATE myTable SET theBlob = WHERE id = Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/

[sqlite] blob + rowID Insert question

Hi All, I have a table with one unique column of the type BLOB. Because I am using the direct SQLite functions to read and write BLOBS, the access is made referencing the ROW IDs. Is there any way to replace a BLOB for a give ROW ID? If I perform DELETE and INSERT I am not sure the R

Re: [sqlite] Sqlite RTree nearest neighbour

I am not an expert in Sqlite R-tree, but it seems that if you want to solve a nearest neighbor you need not only to search the objects in the leaf containing the object you testing, but also some adjacent leaves around. Another option would be to search for objects inside a centered box or sphere

Re: [sqlite] Vacuum command fails

Discussion of SQLite Database Subject: Re: [sqlite] Vacuum command fails On 18 Jul 2014, at 4:11pm, Carlos Ferreira wrote: > I also have a problem with VACCUM. ( both 32 and 64 bits ) > > Whenever I deal with small databases, it works fine, but as soon as > the DB is more than

Re: [sqlite] Vacuum command fails

Hi, I also have a problem with VACCUM. ( both 32 and 64 bits ) Whenever I deal with small databases, it works fine, but as soon as the DB is more than 200 Mb, the vaccum command bails out with code 21. or Any idea ? I can make my own copy and rename ..that is probably what Vaccum does...but

[sqlite] Update a BLOB

... It does not seem reasonable to create a Statement with the BLOB string ... So what is the best way to update a record with a BLOB? Thanks Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Carlos Ferreira Sent

[sqlite] SQLite and BLOBs

Hello, I found this reference in this link: http://stackoverflow.com/questions/676524/how-to-update-piecewise-a-blob-in-sqlite " This is not directly an answer to your question, but I have some experience using random access for (big) blobs in SQLite, and I advise you against using it, if you

Re: [sqlite] slowish R*Tree performance

Hi, I am just a user of binary Sqlite. So, I do not know how much of custom Sqlite tricks can be made with a copy of sqlite source code. However, and if I understood well the problem is like this: 1 - There a data type named IPV6 Address. 2 - there is a table where this data type must be in. (

Re: [sqlite] slowish R*Tree performance

Regarding the R.Tree performance problem, What is the original problem that is causing slow performance in the SQlite R-Tree implementation? Thanks Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: d

Re: [sqlite] 64 bits Dll

Constantine, really useful information. Do you know if the compiled objs that may be available in Delphi are comparable in performance with the ones made by MS VS. I know there is a tool, IMPLIB to import dlls or libs that can be from Microsoft and create Libs to use in Delphi..Not sure how the

Re: [sqlite] 64 bits Dll

Dll On 09.05.2014 13:50, Carlos Ferreira wrote: > XE6 itself seems to native have access to both... FireDAC only, and outdated by 2 months at the day of release. Delphi XE5 SQLite is still at 3.7.17, almost one year behind. DISQLite3 has always been up to date for years and Delphi versions back

Re: [sqlite] 64 bits Dll

:36, Carlos Ferreira wrote: > I am using a win32 DLL built "sqlite-dll-win32-x86-3071700" . the DLL > is from 20-5-2013. > > > I am using it with Delphi, and it works fine for what I need. > > > I need however a 64 bits version of the DLL. I actually have the

Re: [sqlite] 64 bits Dll

Database Subject: Re: [sqlite] 64 bits Dll On 09.05.2014 12:36, Carlos Ferreira wrote: > I am using a win32 DLL built "sqlite-dll-win32-x86-3071700" . the DLL > is from 20-5-2013. > > I am using it with Delphi, and it works fine for what I need. > > I need however

Re: [sqlite] 64 bits Dll

: General Discussion of SQLite Database Subject: Re: [sqlite] 64 bits Dll On Fri, May 9, 2014 at 1:36 PM, Carlos Ferreira wrote: > Can anyone tell me where can I find the 64 bits version of Sqlite.dll, > or can anyone compile it for me? It would work as a small consulting project. > ​I

[sqlite] 64 bits Dll

Hello, I am using a win32 DLL built "sqlite-dll-win32-x86-3071700" . the DLL is from 20-5-2013. I am using it with Delphi, and it works fine for what I need. I need however a 64 bits version of the DLL. I actually have the64 bits 3.7.16 version that I downloaded from the SYNOPSE proj

[sqlite] Eficiency : 1 table vs several tables

Hi All, Thank you all about the help on adding tables. Adding the tables between transactions did help a lot. Speed is now ok. I received a suggestion that in my case is quite valid: My tables have all the same number of columns ( 1 column only.. of BLOBs.) and Simon Slavin sugg

Re: [sqlite] Big number of tables

tables On Fri, Nov 29, 2013 at 2:37 PM, Igor Tandetnik wrote: > On 11/29/2013 8:33 AM, Carlos Ferreira wrote: > >> Any of you know how to speed up the creation of empty tables in SQlite? >> >> If I have to create more than 1000 empty tables to initialize my >> a

[sqlite] Big number of tables

Hello, Any of you know how to speed up the creation of empty tables in SQlite? If I have to create more than 1000 empty tables to initialize my application document it takes a while.. Is there any workaround? Thanks Carlos __