Re: [sqlite] SQLite build on Risc-V

I'm on a SiFive Unleashed board running Debian Linux on Kernel 4.19. -- Sent from IPhone ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite build on Risc-V

I tried to build SQLite from sources on Risc-V architecture but the ./configure script fails. Replacing config.guess and config.sub with the ones from automake 1.16 package fixes the problem and SQLite builds successfully. Carlos -- *Carlos Eduardo de

[sqlite] CoreData - when database gets closed

Is there a way to know when CoreData closes sqlite files?. I’m using CoreData in an iOS app and I set file attributes for sqlite file to be NSFileProtectionCompleteUnlessOpen which throws away the key to encrypt the file when it’s closed, denying access to it.

[sqlite] SQLite Query truncating String column at 255 chars long

I have a table in a SQLite 3 database file (.db3), which has a TEXT column whose fields often can be 1024 chars long or more. My application connects to this file using SQLite.NET library (from Nuget) and runs a simple "SELECT * FROM tabRxBinder;" command to populate a DataTable object. Inside

Re: [sqlite] sqlite - Delete large table in sqlite

maybe rename and recreate the database with "insert from" the remaining tables would be faster, and give the benefit of a vacuum also? On 09/09/2016 13:14, Венцислав Русев wrote: On 09/09/2016 12:49 PM, Bhavesh Patel wrote: I have a 4GB SQLite database (currently using SQLCipher for

[sqlite] No datasize field - why?

But, with very fast CPUs and RAM memory buffers for the directory entries in the disks, the variable length records would probably result in gain for much less I/O for the data. On 23/04/2016 21:22, Scott Robison wrote: > On Apr 23, 2016 6:21 PM, "Simon Slavin" wrote: >> >> On 24 Apr 2016,

[sqlite] Logically dead code in function sqlite3_index_info

if( pTerm->wtFlags & *TERM_VNULL* ) continue; *-(1)* pIdxCons[j].iColumn = pTerm->u.leftColumn; pIdxCons[j].iTermOffset = i; Best regards. Carlos Tangerino

[sqlite] Using uninitialized value nDummy when calling vdbePmaReaderInit

Bug list return me error, so posting here hoping someone watchs it. A suspicious piece of code. The variable nDummy is not initialized *(1)* in the function but its pointer *(2)* is passed to *vdbePmaReaderInit* that increments *(3)* its value. static int vdbeMergeEngineLevel0( SortSubtask

Re: [sqlite] using a hex integer as input to DateTime

a particular need. Carlos. On 1/15/2015 5:30 AM, Paul Sanderson wrote: Thanks Peter Coding outside of SQLite is easy - it's doing it with just SQLite/SQL that I was after :( Cheers Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http

Re: [sqlite] XML into sqlite

problems I have solved in the past with Access. So far, I have been able to replicate everything. Next step is to venture into XML - sqlite integration...both ways. With some restrictions, it worked well between Access and XML, via Excel. Cheers, CARLOS A. Sent from my iPad > On 11/09/2014, a

[sqlite] XML into sqlite

. Cheers, CARLOS A. Sent from my iPad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Problems uploading CSV into sqlite3 DB

of spaces...odd I know, but it worked! Saludos/Cheers, *CARLOS A. GORRICHO* Managing Partner Heptagon Group S.A.S. cgorri...@heptagongroup.co Cel COL +57 314 771 0660 Cell USA +1 713 574 2242 ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Problems uploading CSV into sqlite3 DB

and didn't work Result was eve weirder, since it create a table using ALL the records as columns headers... Saludos/Cheers, *CARLOS A. GORRICHO* Managing Partner Heptagon Group S.A.S. cgorri...@heptagongroup.co Cel COL +57 314 771 0660 Cell USA +1 713 574 2242 2014-09-03 10:24 GMT-05:00

Re: [sqlite] Problems uploading CSV into sqlite3 DB

ecord-field DB I shared earlier. I would venture to say I did this from the Terminal sqlite version, but I am not certain... Thanks in advance for your comments and guidance. Please let me know if I can do anything to help you in other fronts. Saludos/Cheers, *CARLOS A. GORRIC

[sqlite] Fwd: Problems uploading CSV into sqlite3 DB

mental variable or something like that needs to be modified, but would not venture without guidance. Looking forward to hearing your feedback. Attached the original CSV file and resulting database. Saludos/Cheers, *CARLOS A. GORRICHO* Managing Partner Heptagon Group S.A.S. cgorri...@heptagon

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

w should I serialize it? What kind of encoding? Thanks Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: quinta-feira, 28 de Agosto de 2014 19:08 To: General Discussion of SQLite Database Subject: Re: [sq

Re: [sqlite] blob + rowID Insert question

2014, at 7:06pm, Carlos Ferreira <car...@csiberkeley.com> 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@s

[sqlite] blob + rowID Insert question

the ROW IDS will keep sequential and I cannot call VACCUM for performance reasons in the application. Thanks Carlos ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

Re: [sqlite] Vacuum command fails

is that the working database has much smaller blobs...and proximately the same number of records. Regards. Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: sexta-feira, 18 de Julho de 2014 16:34 To: General

Re: [sqlite] Vacuum command fails

...but using vaccum would be very nice if it would work ok... Thanks Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of RSmith Sent: sexta-feira, 18 de Julho de 2014 15:41 To: General Discussion of SQLite Database Subject: Re

[sqlite] Update a BLOB

and... 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

s raw files to the file system, and merely store a reference to the filename in your database. If your blobs are rather small and guaranteed not to grow, forget my advice. " Do you agree with this information? Regards. Carlos -Original Message- From: sqlite-users-boun...@

Re: [sqlite] slowish R*Tree performance

is the record actually standing in that ordered position...That would be your result!! This can also be done outside Sqlite...but not sure if my understanding of the problem is correct. Regards, Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun

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

Re: [sqlite] 64 bits Dll

they did it in Embarcadero.. Thanks Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Constantine Yannakopoulos Sent: sexta-feira, 9 de Maio de 2014 15:36 To: General Discussion of SQLite Database Subject: Re: [sqlite

Re: [sqlite] 64 bits Dll

Ralf, Thanks for the insigth. Regards. Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ralf Junker Sent: sexta-feira, 9 de Maio de 2014 15:20 To: General Discussion of SQLite Database Subject: Re: [sqlite] 64 bits

Re: [sqlite] 64 bits Dll

bits, and it works perfectly. Regards. Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of RSmith Sent: sexta-feira, 9 de Maio de 2014 14:57 To: sqlite-users@sqlite.org Subject: Re: [sqlite] 64 bits Dll On 2014/05/09 12

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

to be as fast and optimized as possible. Tell me how you want to do this DLL exchange. Thanks Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Constantine Yannakopoulos Sent: sexta-feira, 9 de Maio de 2014 11:57

[sqlite] 64 bits Dll

nks to All. Carlos ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Eficiency : 1 table vs several tables

All Carlos ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Big number of tables

of tables On Fri, Nov 29, 2013 at 2:37 PM, Igor Tandetnik <i...@tandetnik.org> 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

[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

Re: [sqlite] Full covering index without table

Also, You could not rebuild the index from the index, if necessary. Carlos. Em 04/03/2013 12:44, Simon Slavin escreveu: On 4 Mar 2013, at 4:13pm, Eleytherios Stamatogiannakis <est...@gmail.com> wrote: Is there a way in SQLite to have a full covering index on a table without also s

[sqlite] several links of www.sqlite.org point to draft pages

several links of www.sqlite.org are loading draft pages ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] instr function or equivalent

Hi, You could check the sqlite extensions from www.monkeybreadsoftware.de at: http://www.monkeybreadsoftware.de/SQLiteExtension/functions.shtml Best Regards, Carlos. Em 10/09/2012 10:21, Sébastien Roux escreveu: Hi, I'm looking for the[in]famous sqlite "*instr"* function which doe

Re: [sqlite] Encryption using System.Data.SQLite.dll

John, The internal Adobe Air SQLite is built to not accept extensions, so, either the System.Data.SQLite.dll or the SQLite Encryption Extension from hwaci could only be used with a an external native extension application. Carlos. Em 17/08/2012 09:48, John Grasmeder escreveu: Carlos, My

Re: [sqlite] Encryption using System.Data.SQLite.dll

if you really need to use System.Data.SQLite.dll, from Adobe Air, then you need to follow something like to: http://blogs.adobe.com/globalization/invoking-icu-from-adobe-air-applications-part-2-using-flash-builder-4-6/ and call System.Data.SQLite.dll as an external native extension Carlos. Em

[sqlite] sqlite4 in memory databases

Are there any plans to sqlite4 implement these pending feature requests of sqlite3? Dumping to, and restoring from disk an sqlite memory database. Attaching to an sqlite memory database image (for example one fetched from the network). ___

[sqlite] draft status is missing "is recommended."

Status: Version 3.7.12 of SQLite is recommended for all new development. Upgrading from version 3.7.6.3, 3.7.7, 3.7.7.1, 3.7.8, 3.7.9, or 3.7.11 is optional. Upgrading from all other SQLite versions. ___ sqlite-users mailing list

Re: [sqlite] INTEGER PRIMARY KEY and SQLITE_ENABLE_STAT2

00 AND 200 are roughly 1M, and createdAt BETWEEN '2011-08-01' AND '2011-08-02' could be 10M. In a simple case like this it's good to leave the wheel to who knows the db. > > but hay. Who said their could only be one logical approach. > > Alex > > > On 24

Re: [sqlite] INTEGER PRIMARY KEY and SQLITE_ENABLE_STAT2

Don't know how SQLite should behave in this case, but seems logical to me that A and B would force that A is always evaluated, and B is evaluated only if A is true. I would change the order of the two betweens: SELECT itemID FROM t WHERE createdAt BETWEEN '2011-08-01' AND '2011-08-02' AND

Re: [sqlite] Best solution to import big DBF file?

Hi I think you'll find what you need here http://www.vlsoftware.net/ > Hello > > I have a 87MB file in DBF format that I'd like to import into SQLite. > > What is the best tool for this, free or affordable? > > Thank you. > > ___ > sqlite-users mailing

[sqlite] installing sqlite

sqlite offer a very eficient program but I dont understand how to install it in my Windows NT PC. I dont know how to compile a C program and then use it as a shell to run the sqlite commands. Can you help me? -- Carlos Contreras, presidente Club Científico de Peñalolén, Santiago, CHILE http

[sqlite] Documentation typo

, Carlos Ramirez, www.antai-group.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

ld of SQLite and download it > via the teacup command. > > But otherwis this looks weird. Check the downloaded .so with ldd if it > references any Tcl Library (like libtcl8.4 or something). It should not, if > it had been compiled with STUBS enabled. > > Michael > -- C

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

Hi Dan, Sorry, my fault. I'm testing in a 32bits Ubuntu 8.10 system running kernel 2.6.28-15-generic. Thanks. Quoting Dan Kennedy : > On Aug 30, 2009, at 12:23 AM, carlos.tas...@farmerswife.com wrote: > >> Hi Dan, >> >> Yes I can confirm it. As more info here is the

Re: [sqlite] Undefined Symbol: Tcl_CreateObjCommand

Hi Gerry, That's the first thing I tested. I downloaded this file: http://sqlite.org/tclsqlite-3.6.17.so.gz Does anyone else have the same problem? I'm using ActiveTcl 8.5.4. Thanks. Quoting Gerry Snyder <mesmerizer...@gmail.com>: > Carlos Tasada wrote: >> Hi guys, >>

[sqlite] Undefined Symbol: Tcl_CreateObjCommand

Hi guys, I'm trying to use sqlite 3.6.17 from a Tcl script in Linux, but as soon as I do "load libsqlite3.so" I get an error: "undefined symbol: Tcl_CreateObjCommand" Testing the script in Windows works fine. Anyone knows how to solve it? Thanks. -- Carlos Tasada Softwar

Re: [sqlite] Substract and decimal

THANK'S A LOT IGOR Igor Tandetnik escribió: > Carlos Suarez <carlos.sua...@rolsoft.com> > wrote: > >> An date field can be null or not, depending of this the field it >> writes 'without_a_date' or the number of days from a date to another >> *the problem

Re: [sqlite] Substract and decimal

Hello, I need to use a case with that situation: An date field can be null or not, depending of this the field it writes 'without_a_date' or the number of days from a date to another *the problem is only the presentation cause I need the subtract without decimals number* but round doesn't

Re: [sqlite] A question about dates

thanks for answers so quickly, I need to know how I can sum and count the field assoiated by record more especifically this: I got several tables associated ie: client --- buys name idbuy idcli idcli date and I need to count how many buys got every client

[sqlite] A question about dates

Hi, I need to know how I can split a date field with a slash in -, being straight I need to convert the the date format /mm/dd to -mm-dd or something alike because flex builder date format is with slash but sqlite operation results are return with (-) in example:

Re: [sqlite] how to replace the sentence limit

Thanks Igor, I haven't note about the diagram, now I want to ask you help for this: CASE WHEN field1 IS NULL THEN 'SIN CERRAR' ELSE (STRFTIME('%J',field1) - STRFTIME('%J',field2)) END AS DIAS_CERRAR, Igor Tandetnik escribió: > Carlos Suarez <carlos.sua...@rolsoft.com>

[sqlite] how to replace the sentence limit

Hello, my name is Carlos I need to replace de common sentence in hsqldb --LIMIT min rows - max rows with something for delimit a query in sqlite because this is not supported thanks, ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Hi, a question from Colombia

Hi, my name is Carlos Suarez from Colombia, I have a few problems while I migrated from hsql to sqlite and I want to know if you can help me with some of this stuff by this way of mail or have I to quote in somewhere?. thanksfully Carlos Suarez

Re: [sqlite] What is the best way to connect to SQLite from VB/VBA?

With the odbc driver, is ease and faster RB Smissaert <[EMAIL PROTECTED]> wrote: Have spent 2 days looking at all the different wrappers and the one ODBC driver and maybe the best one is the commercial dll from Terra... Still, I would be very interested what opinions are about the best (speed,

[sqlite] problem with sqlite3 in lazarus

Hi, I have sqLite version 3.3.6, and I'm using with lazarus in windows. With sqlite3.exe, I created this table create table product (cod varchar(6), ean varchar(13), desc varchar(30), pvp numeric(10,2)) from lazarus I did 4000 insert, like this: insert into product values

[sqlite] Reducing DB disk access in a high performance server application?

tightly coupled solution – however, using hash maps would be wickly fast! I'm wondering if anyone has advice or concepts I should be considering - or perhaps point out something I've missed? Carlos -- EMAIL: [EMAIL PROTECTED], [EMAIL PROTECTED] WEB: http://www.chessbrain.net AOLIM: carlosjustiniano

[sqlite] sqlite with Visual Basic

Hi! I can use SQLLite with Visual Basic without using other external DLL Any sample of using sqlite.dll API? Thanks Carlos Garcés . - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL