Re: [sqlite] SEE encryption password

Here is a suggestion. You can select between decimal and hexadecimal output. https://nousrandom.net/randominteger/index.html - Scott Doctor sc...@scottdoctor.com - On 5/6/2019 13:20, Jens Alfke wrote: On May 5, 2019, at 11:04 PM

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

. - Scott Doctor sc...@scottdoctor.com - On 12/21/2018 13:02, Larry Brasfield wrote: Zydeholic wrote: ➢ I compile and get one error: Severity    Code    Description    Project    File    Line    Suppression State Error    LNK2001    unresolved

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

Click the link. https://sqlite.org/download.html Download the amalgamation zip file. Unzip to your files directory. Should be two files. sqlite.c and sqlite.h Add #include "sqlite.h" to your file. Compile. ----- Scott Doctor sc...@scott

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Why not just add the amalgmation to your source then do C function calss. I do not get why you would use a dll when you can just link in the amalgamtion into your program and have full access to the latest version. - Scott Doctor sc...@scottdoctor.com

Re: [sqlite] Strange Corruption Issue

SSD's have a limited number of write cycles. You may have a failing SSD. Those are still, IMO, another 5-10 years before they solve the write lifetime reliabilty issue. - Scott Doctor sc...@scottdoctor.com - On 6/18/2018 20:15, Patrick Herbst

Re: [sqlite] sqlite.org website is now HTTPS-only

Just out of curiosity, is the sqlite website using nginx or apache as the server? - Scott Doctor sc...@scottdoctor.com - ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] Move to Github!!?

What fossil needs is for the UI to perform ALL normal common functions (new, commit, clone,...) WITHOUT having to open a command line window. That is imo the main limitation. - Scott Doctor sc...@scottdoctor.com

Re: [sqlite] random value get re-generated too often in SQLite

Is it possible that the first call to random is cached and the cached value is being returned in subsequent calls? - Scott Doctor sc...@scottdoctor.com - On 12/8/2017 12:09, John McKown wrote: On Fri, Dec 8, 2017 at 12:54 PM, John Mount <

Re: [sqlite] Problem with mailing list

gt;sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users - - - - Scott Doctor sc...@scottdoctor.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.

Re: [sqlite] Convert mysql to sqlite

. Then I imported the csv into the new sqlite database. Everything seems to have transferred properly that way and all the garbage from years gone by is scrubbed. - Scott Doctor sc...@scottdoctor.com - On 9/10/2016 14:39, Simon Slavin wrote

[sqlite] Convert mysql to sqlite

, procedures, or foreign keys. Tables are normal structure with a pk field and some text and integer fields in each table. Anyone know of a utility to directly convert from MySQL to sqlite? -- - Scott Doctor sc...@scottdoctor.com

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

phones I tried, along with large desktop monitors. You can see how it works here> https://nousrandom.net/index.html ----- Scott Doctor sc...@scottdoctor.com - On 9/5/2016 13:55, Richard Hipp wrote: Most of the world views the internet on their ph

[sqlite] json arrays

Regarding json format, assume a list of numbers as a json array. Should numbers in a json array have quotes around the numbers? For example: {"result":["1.23","2.34","3.45"]} or {"result":[1.23,2.34,3.45]}

[sqlite] SELECT ... FOR UPDATE

and destroy any of those statements from mysql when converting it to sqlite. Scott Doctor sc...@scottdoctor.com -- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

[sqlite] Article about pointer abuse in SQLite

/21/2016 21:31, J Decker wrote: > On Mon, Mar 21, 2016 at 8:40 PM, Scott Doctor > wrote: >> you are missing >> >> using System; > whatever. It still fails because it says the variable is > uninitilalized. THe only thing that doesn't is actually running it. > &g

[sqlite] Article about pointer abuse in SQLite

you are missing using System; Scott Doctor scott at scottdoctor.com -- On 3/21/2016 5:21 PM, J Decker wrote: > So far I just see analysis tools fail for the same sorts of valid code... > > this is a bit of C# but the same idea causes the same warnings and

[sqlite] hard links and SQLite

> _______ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users TOCTTOU? What is that? -- - Scott Doctor scott at scottdoctor.com

[sqlite] website documentation wording

Simply "Intel decided". using 'have', 'has', 'has been', 'have been' can almost always be dropped entirely or replaced with 'is', 'was', 'were' depending on tense. -------- Scott Doctor scott at scottdoctor.com -- On 12/4/2015 9:13 AM, Simon Slavin wrote: >

[sqlite] Simple Math Question

17 -> 0x10001 mantissa -1 -> 0xf exponent ( or however many bits the exponent is represented by exact ---- Scott Doctor scott at scottdoctor.com On 10/23/2015 12:46 AM, Keith Medcalf wrote: > You are thinking (and typing) in base 10. Computers use this new-fangled >

[sqlite] Simple Math Question

. Scott Doctor scott at scottdoctor.com On 10/23/2015 12:14 AM, Dominique Devienne wrote: > On Thu, Oct 22, 2015 at 11:55 PM, Igor Tandetnik > wrote: > >> On 10/22/2015 4:25 PM, Rousselot, Richard A wrote: >> >>> FWIW, MySQL and Oracle both return all yes for th

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

tests. with the optimizer, the resulting compiled code was identical either way.. Scott Doctor scott at scottdoctor.com On 10/22/2015 2:01 AM, Marco Turco wrote: > Hi all, > > I'm trying to generate the sqlite3 library but there is no way with > Embercadero C++ 7.00.

[sqlite] Form-Feed (0x0C) is not a space character in JSON

. Scott Doctor scott at scottdoctor.com -- On 10/16/2015 7:46 AM, Graham Holden wrote: > I've not seen the RFC but you say "JSON only has 5 whitespace characters" and > then list only 4, and your patched array only has four 1's. Have you missed > one, or is t

[sqlite] What's the status of SQLite4? Where can I find its source code?

.. Scott Doctor scott at scottdoctor.com On 10/5/2015 3:30 AM, Richard Hipp wrote: > Jerry & Scott: What are you hoping to achieve with SQLite4 that you > cannot do with SQLite3? > > On 10/5/15, Stephen Chrzanowski wrote: >> There was a thread sometime last year about thi

[sqlite] What's the status of SQLite4? Where can I find its source code?

Is there a release date set for sqlite4? Scott Doctor scott at scottdoctor.com -- On 10/4/2015 9:14 PM, Stephen Chrzanowski wrote: > https://sqlite.org/src4/tree?ci=trunk > > On Mon, Oct 5, 2015 at 12:02 AM, Jerry wrote: > >> Seems I could not fi

[sqlite] Using collation instead a virtual table

field of study. By using proper number of significant digits throughout your calculations, the result will be more correct than not doing so. ---- Scott Doctor scott at scottdoctor.com -- On 9/9/2015 11:47 AM, R.Smith wrote: > > > On 2015-09-09 05:19

[sqlite] Version Control

Slightly off topic, but I am looking at version control systems. SQLite looks like it is using Fossil. How does Fossil compare to using Git, Mercurial, or Subversion? - Scott Doctor scott at scottdoctor.com -

[sqlite] FTS5

Is FTS5 fully tested and part of the current version, or is it still experimental? Scott Doctor scott at scottdoctor.com --

[sqlite] Proper way to abort

Sheesh, how did I miss that. Guess I need new glasses. Thats exactly what I was looking for. Scott Doctor scott at scottdoctor.com -- On 8/24/2015 9:39 AM, Jean-Christophe Deschamps wrote: > >> >> I have some queries that may take 5-15 seco

[sqlite] Proper way to abort

a query, or other operation during execution that will not cause any issues? By issues I mean files not being closed, or memory not being free'd and such because the operation was aborted and did not have finish normall, but I can continue normally after the abort.. Scott Doctor

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

that handles setting up and changes. Or you can connect directly to your SQLite database and it will handle making all the changes for you. Scott Doctor scott at scottdoctor.com -- On 8/21/2015 11:54 AM, Scott Doctor wrote: > > ---- > Scott Docto

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

Scott Doctor scott at scottdoctor.com -- On 8/21/2015 10:37 AM, sqlite-mail wrote: > Thanks for your attention! > > Only to remark on this I tested on postgresql and somehow it knows how deal > with it ! "so few (none?)" > > Cheers ! >

[sqlite] Compile warnings

but is an error in the coding. I would prefer code that can be compiled with all warnings turned on that gives no warnings than have a potential problem because of a glitch in the code. Scott Doctor scott at scottdoctor.com On 8/20/2015 9:32 AM, Scott Hess wrote: > Yeah, we

[sqlite] pragma temp_store_directory is deprecated, what is the alternative?

directory on the programs directory. Scott Doctor scott at scottdoctor.com --

[sqlite] CSV excel import

A trick that works great most of the time with ODS is when exporting to CSV select the option to quote all fields. One problem with CSV is that many exports quote strings but not numbers. If everything is quoted then it is much simpler to process. But would need at least several options on

[sqlite] VFS for an MCU internal flash

/docs/latest/common.services.fs.fatfs.access_example.sam4s_xplained/html/files.html Scott Doctor scott at scottdoctor.com -- On 7/13/2015 12:29 PM, Jim Callahan wrote: > At a minimum SQLite needs a C complier (or cross-compiler) for the CPU. > > The stora

[sqlite] Tables and Columns of Database of Whatsapp

. Forinstance, they are from the same family, or work at thesame company. Reverse engineering an applications databaseprobably introduces much more complexity than should beintroduced if the students do not already understand SQL. Scott Doctor scott at scottdoctor.com --

[sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue

em may be that you are passing invalid UTF-8 to SQLite which may be causing the inability to open the file. the invalid characters are 0x3f ox3f which is not a valid UTF-8 sequence. ---- Scott Doctor scott at scottdoctor.com --

[sqlite] sqlite error code 1034

cycles it is possible that the memory is near the end of its life and needs to be replaced. Scott Doctor scott at scottdoctor.com On 6/23/2015 1:09 AM, Simon Slavin wrote: > On 23 Jun 2015, at 6:01am, Mayank Kumar (mayankum) > wrote: > >> Do you think

[sqlite] Mozilla wiki 'avoid SQLite'

roduct? > And just for the record, C# does not compile into byte code. I suggest you > check your facts. Quite believable. Which is why Microsoft software is so efficient, fast, small, and lacking of bugs. Scott Doctor scott at scottdoctor.com --

[sqlite] Mozilla wiki 'avoid SQLite'

yte resource hogs. I agree that C compilers are able to optimize assembler code to a level that hand-coded assembler probably could not achieve. The problem is that higher level languages are not compiling to assembler, but compiling to the language below it. ---- Scott Doctor sc

[sqlite] User-defined types -- in Andl

. The trick is being able to find that one word quickly and getting "All" the needed information in a concise deliberate fashion. - Scott Doctor scott at scottdoctor.com - On 6/7/2015 10:28 PM, david at andl.org wrote: > Thanks for pointing

[sqlite] User-defined types -- in Andl

So we are supposed to learn this new language by osmosis? Scott Doctor scott at scottdoctor.com On 6/7/2015 11:00 AM, Simon Slavin wrote: > On 7 Jun 2015, at 6:51pm, Scott Doctor wrote: > >> Do you have a PDF that explains the language? > There are plenty of blo

[sqlite] User-defined types -- in Andl

o is handed the database code without any documentation, to be able to decipher the program. (remember the Y2K bug). As you develop your language, consider if someone without having read the manual, but has a background in programming, could decipher a program written in your language. --

[sqlite] User-defined types

Just write your program in C. Use the C syntax to do whatever you want and you have full control over the minutiae. Scott Doctor scott at scottdoctor.com -- > On 6/4/15, Darko Volaric wrote: >> What is motivating this for me is that I generate ma

[sqlite] AUTOINC vs. UUIDs

centralized input. A second field, such as salesman ID, would need to squashed into that invoices PK number to guarantee a uniqueness to the number, assuming every salesman has a unique ID. Scott Doctor scott at scottdoctor.com On 5/20/2015 3:08 PM, Steven M. McNeese wrote: >

[sqlite] AUTOINC vs. UUIDs

. Scott Doctor scott at scottdoctor.com On 5/20/2015 2:38 PM, Jean-Christophe Deschamps wrote: > At 23:24 20/05/2015, you wrote: > >> On Wed, May 20, 2015 at 2:20 PM, Steven M. McNeese >> wrote: >> > Often times people will use GUIDs as primary keys when different

[sqlite] AUTOINC vs. UUIDs

Given a field that is a primary key with auto-increment, does sqlite store an integer that gets incremented, or does it look at the last row and increment its value? Scott Doctor scott at scottdoctor.com On 5/20/2015 11:05 AM, Simon Slavin wrote: > Posting this not becaus

[sqlite] Please confirm what I THINK I know about blobs

should be descriptive of its contents. If you cannot describe the contents in a word, then that row should have at least a simple text column so a description can tag the blob. Scott Doctor scott at scottdoctor.com On 5/9/2015 4:18 AM, William Drago wrote: > On 5/9/2015 6:40

[sqlite] Multiple Prepared Statements

then loop until I am done then finalize the 3 statements. That sure saves much overhead from preparing and finalizing 3*n*x times. Scott Doctor scott at scottdoctor.com -- On 5/8/2015 3:20 PM, Richard Hipp wrote: > On 5/8/15, Scott Doctor wrote: >> Can

[sqlite] Multiple Prepared Statements

Can I prepare multiple statements then implement them in arbitrary order (based on some logic)? Or do the statements need to be prepared, stepped, finalized serially? Scott Doctor scott at scottdoctor.com --

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

That will be the day I can hit print on my computer and a Roast Beef Sandwich, with lettuce, tomato, onion, cheddar, and a smear of mustard on Marble Rye comes out my printer, all while driving my flying car (it is 2015, where is my flying car?) Scott Doctor scott

[sqlite] Multiple instances of the same program accessing the same db file

. Scott Doctor scott at scottdoctor.com --

[sqlite] What software is deployed more than SQLite?

You could just use all caps and scream the headline, then you do not need to worry what should be capitalized. - Scott Doctor scott at scottdoctor.com - On 5/4/2015 10:01 AM, Tim Streater wrote: > On 04 May 2015 at 17:31, jungle Boogie wrote: > &

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

for me that the open source, free stuff did not. The day I can open source my rent, groceries, car repairs, is when everything else can be free. - Scott Doctor scott at scottdoctor.com - On 5/4/2015 9:15 AM, Gerald Bauer wrote: > Hello, >

[sqlite] Multiple instances of the same program accessing the same db file

more, Scott Doctor scott at scottdoctor.com

[sqlite] What software is deployed more than SQLite?

Apple products use SQLite. Scott Doctor scott at scottdoctor.com On 5/3/2015 1:32 PM, Richard Hipp wrote: > On 5/3/15, Richard Hipp wrote: >> I'm trying to update the "Most Deployed Database" page >> (https://www.sqlite.org/mostdeployed.html) in the SQLit

[sqlite] Multiple instances of the same program accessing the same db file

that will work most of the time, but have a potential collision scenario. Such is why so many applications have the occasional crash or corruption. Scott Doctor scott at scottdoctor.com On 5/3/2015 12:54 PM, James K. Lowden wrote: > On Sat, 02 May 2015 19:24:19 -0700 > Scott

[sqlite] Multiple instances of the same program accessing the same db file

whether I should implement my own locking logic in my program. - Scott Doctor scott at scottdoctor.com - On 5/2/2015 6:10 PM, Scott Robison wrote: > Since I'm not clear on whether your two or more > processes are running on the same machine accessing a

[sqlite] Multiple instances of the same program accessing the same db file

is also trying to access the database at the same time). - Scott Doctor scott at scottdoctor.com -

[sqlite] Multiple instances of the same program accessing the same db file

Is the PRAGMA value the retry interval, or the timeout where it aborts and reports a failure? Scott Doctor scott at scottdoctor.com -- On 5/2/2015 5:08 PM, Simon Slavin wrote: > On 3 May 2015, at 12:55am, J Decker wrote: > >> Yes, it really requires o

[sqlite] Multiple instances of the same program accessing the same db file

programs accessing the same sqlite database file at the same time where both programs will be reading/writing to the database? Or do I need to implement or more complex strategy for accessing the sqlite file? -- - Scott Doctor scott at scottdoctor.com -

[sqlite] dropping a constraint

The page I was referring to in the documentation is http://www.sqlite.org/lang.html - Scott Doctor scott at scottdoctor.com - On 5/1/2015 12:10 AM, Clemens Ladisch wrote: > Scott Doctor wrote: >> I noticed that the sqlite documentation does

[sqlite] dropping a constraint

I noticed that the sqlite documentation does not show the CONSTRAINT keyword, but it looks as though sqlite accepts the keyword. Also it appears that sqlite does not support DROP CONSTRAINT, but does support DROP VIEW and other similar. Is this correct? -- Scott Doctor scott

[sqlite] Segfault during FTS index creation from huge data

This makes my head spin. ridiculous that an over commit even exists. any slight performance gain is totally nullified by a crashing program. - Scott Doctor scott at scottdoctor.com - On 4/30/2015 11:47 AM, Scott Robison wrote: > On Thu, Apr 30, 2

[sqlite] Segfault during FTS index creation from huge data

. Scott Doctor scott at scottdoctor.com -- On 4/28/2015 6:29 AM, Artem wrote: > No, I'm sure that is not a problem in my software, it exactly > error of the SQLite library. My software is very simple - it creates > simple connection to the database with connection string lik

[sqlite] Thoughts on storing arrays of complex numbers

to access your data by some rules, which seems to indicate a straight forward table of numbers. Write them out on a sheet of paper like you would do in a math class. The structure of the table will become self evident. Scott Doctor scott at scottdoctor.com On 4/24/2015 6:37 AM, Drago