Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

> On Mar 13, 2020, at 10:22 AM, Richard Hipp wrote: > > On 3/13/20, Huỳnh Trần Khanh wrote: >> [On a mailing nlist] I can >> filter the posts, sort them, search through them, archive them, >> forward them to a friend, &c. > > You can do all of that with the SQLite Forum. Remember, all content

Re: [sqlite] COALESCE() does not short-circuit sometimes

> On Mar 11, 2020, at 2:16 PM, Justin Ng wrote: > > They generally do short-circuit but there are edge cases where they don't. It > isn't entirely intuitive to me what the conditions are, though. > "ABS(-9223372036854775808)" is a constant expression, and as such, it makes sense that it is

Re: [sqlite] New word to replace "serverless"

I often describe it as “self contained.” -j Sent from my iPhone > On Jan 27, 2020, at 4:19 PM, Richard Hipp wrote: > > For many years I have described SQLite as being "serverless", as a way > to distinguish it from the more traditional client/server design of > RDBMSes. "Serverless" seemed

Re: [sqlite] Rounding Error

> On Nov 4, 2019, at 2:59 AM, Jay Kreibich wrote: > > >> On Nov 4, 2019, at 2:41 AM, Adrian Sherwin wrote: >> >> Hi, >> >> I would like to report the following as a bug in SQLITE: >> >> The SQLITE "round" function fails to ro

Re: [sqlite] Rounding Error

> On Nov 4, 2019, at 2:41 AM, Adrian Sherwin wrote: > > Hi, > > I would like to report the following as a bug in SQLITE: > > The SQLITE "round" function fails to round between 4.1 and 4.6% of numbers > correctly to x decimal places when held as x+1 decimal places. > > The simplest example I h

Re: [sqlite] Lookup join

> On Oct 1, 2019, at 1:05 PM, Richard Hipp wrote: > Alas, SQLite's query planner is not perfect. ...files bug report... “lacking perfection.” ;-) -j ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.or

Re: [sqlite] Incorrect query result

Alas, the mailing list does not allow attachments. -j > On Aug 14, 2019, at 8:24 AM, Eric Boudaillier > wrote: > > Hi, > > I am experiencing incorrect query result with SQLite 3.25.2 and 3.28. > Attached are the database and a Tcl script running 3 queries. > The database and the queries ha

Re: [sqlite] A license plate of NULL

There are similar stories from many years back about someone that got the vanity plate “MISSING”. -j > On Aug 12, 2019, at 12:09 PM, Simon Slavin wrote: > > Some interesting things are emerging from this year's DEF CON. This one is > related to an issue we've often discussed here. I hope

Re: [sqlite] Question about floating point

> On Dec 17, 2018, at 1:12 PM, Keith Medcalf wrote: > > > The "nearest" representation of 211496.26 is 211496.260931323. The > two representable IEEE-754 double precision floating point numbers bounding > 211496.26 are: > > 211496.260931323 > 211496.25802094 > > The

Re: [sqlite] Question about floating point

> On Dec 15, 2018, at 12:49 AM, Frank Millman wrote: > > Hi all > > I know that floating point is not precise and not suitable for financial > uses. Even so, I am curious about the following - > > SQLite version 3.26.0 2018-12-01 12:34:55 > Enter ".help" for usage hints. > Connected to a tran

Re: [sqlite] Strange query results.

> On Nov 29, 2018, at 7:45 AM, Maurice van der Stee wrote: > > This reproduces the issue for me: > > create table config (config_package integer, config_flags integer); > insert into config (config_package, config_flags) values (1, 2); > insert into config (config_package, config_flags) values

Re: [sqlite] Creating and dropping tables with multiple connections

> On Nov 20, 2018, at 10:27 AM, Simon Slavin wrote: > On 20 Nov 2018, at 3:34pm, Albert Banaszkiewicz > wrote: > >> ExecuteInTransaction(writeDb1, KCreateTable); > > I can't answer your question but the above line shows a misunderstanding of > SQL. Transactions are for commands which modify

Re: [sqlite] HELP!

> On Nov 11, 2018, at 1:24 AM, Clemens Ladisch wrote: > > It's not; SQLite is file based. The only way to share this would be to > make a file share in the company-wide network, i.e., to make the file > \\COMPANYSERVER\SomeShare\MyLittleDB.sqlite directly accessible from > everywhere. (This is

Re: [sqlite] minor nit pick of "When To Use"

> On Nov 11, 2018, at 7:38 AM, Dennis Clarke wrote: > > On 11/11/18 8:25 AM, J. King wrote: >> On November 11, 2018 8:04:51 AM EST, Dennis Clarke >> wrote: >>> >>> this : https://www.sqlite.org/whentouse.html > >> he.net is Hurricane Electric, an Internet backbone. > > An IX ? HE is not a

Re: [sqlite] clarification of the .binary option of the sqlite3 command shell program.

> On Oct 19, 2018, at 3:30 AM, Graham Hardman wrote: > > Hi, > > I am curious about what this option does. It is not discussed in the > documentation and my own testing with the shell program has not aided my > understanding. A simple example would be nice. It controls how data is output to

Re: [sqlite] CAST AS STRING always returns 0 for STRING columns

> On Sep 4, 2018, at 9:30 AM, Ben Caine wrote: > > CAST AS STRING always returns 0 for columns that are already of STRING type. “STRING” is not a known type affinity. Use “TEXT” https://www.sqlite.org/lang_expr.html#castexpr > > Steps to r

Re: [sqlite] How to find records in a table which are not in a second table?

> On Aug 28, 2018, at 1:22 PM, David Raymond wrote: > > Embarrassing confession time: I didn't think you could use "using" to do this > while selecting "a.*" > > https://www.sqlite.org/lang_select.html > "For each pair of columns identified by a USING clause, the column from the > right-hand

Re: [sqlite] How to find records in a table which are not in a second table?

> On Aug 28, 2018, at 11:30 AM, Joe wrote: > > A (perhaps silly ) beginners question: > My sqlite database contains several tables, two of them, table A and table B, > have text colums called 'nam'. The tables have about 2 millions lines. > What's the most efficient way to select all lines fro

Re: [sqlite] Any ideas on how long it takes to drop a large table...rather an important question now...

> On Jul 16, 2018, at 3:01 PM, rob.sql...@robertwillett.com wrote: > > Hi, > > We're doing a massive tidy on our database which is approx 50GB. > > One table is approx 49GB of that 50GB which we need to delete as we have > recorded the information in a far better format thats approx 99% more

Re: [sqlite] Return a column's contents to the free list

> On Jun 9, 2018, at 10:16 AM, Ben Asher wrote: > > To further clarify on VACUUM, we actually want to actively avoid this > because it's expensive, and we'd be running these on small devices like > iPhones and iPads with large-ish DBs. If a full VACUUM is not feasible, you can simply copy the t

Re: [sqlite] Return a column's contents to the free list

e the whole row record is deleted and it tends to free up bigger chunks. But clearing the data out of a column only clears values in the middle of row records, so it is unlikely to free up pages by itself. -j > Ben > > On Sat, Jun 9, 2018 at 10:01 AM Jay Kreibich wrote: > &g

Re: [sqlite] Return a column's contents to the free list

> On Jun 9, 2018, at 9:52 AM, Ben Asher wrote: > > Hi! I've read a lot of discussion about the constraints related to why > SQLite doesn't have destructive column commands (MODIFY, RENAME, DROP, > etc.). Despite that, we still have situations where our data model changes, > and a column becomes

Re: [sqlite] random rows

I’m not entirely sure your solution will have an even distribution. It depends a lot on how many times random() is called (once per row vs once per sort operation), and how the sort algorithm works. I might do this instead: SELECT * FROM (SELECT random(), t.* FROM t) ORDER BY 1 LIMIT 200; As

Re: [sqlite] Resources for learning SQLite

th SQLite. Does anyone have any recommendations for > books or online resources? > > I'm particularly interested in resources that use C#. > > I've been working with "Using SQLite" by Jay A. Kreibich, and it's very > useful, but if there's something more advanced

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

Pretty much every table of every database, with the obvious exceptions like virtual tables. -j > On Mar 16, 2018, at 10:37 AM, Richard Hipp wrote: > > This is a survey, the results of which will help us to make SQLite faster. > > How many tables in your schema(s) use AUTOINCREMENT? > > I

Re: [sqlite] Indexing multiple values per row

> On Mar 15, 2018, at 12:33 PM, Jens Alfke wrote: > > I'm wondering what the best way is to efficiently search for data values that > can appear multiple times in a table row. SQLite indexes, even expression > indexes, don't directly work for this because they obviously only index one > value

Re: [sqlite] Is it a bug or "as designed"?

> On Mar 9, 2018, at 1:42 PM, Simon Slavin wrote: > > "replace" means "delete the original row, then insert a new one”. More properly, it means “delete any and all rows that might cause any conflict with inserting the new row.” There really isn’t a concept of an “original” row, it just happ

Re: [sqlite] Is it a bug or "as designed"?

Foreign keys enforcement can get tricky depending on the enforcement policy, transactions, and a lot of things. I don’t have enough experience to comment on that fully. I will say this, however, because it is a common mistake with a lot of different aspects of database behavior: “I

Re: [sqlite] Move to Github!!?

> On Dec 25, 2017, at 12:24 PM, J. King wrote: > > SQLite source is managed in a Fossil (not Git) repository, which is software > itself designed by Dr. Hipp and based on SQLite. GitHub would be an entirely > inappropriate venue. > > SQLite is also not open source software in the convention

Re: [sqlite] Why Unicode is difficult

present 0.1 And the fact there are so many interpretations of “number representation” aught to give a clue about how complex something “so simple” can be. -j > >> >> On Mon, Dec 4, 2017 at 11:07 AM, Igor Korot wrote: >> >>> Hi, >>> >>> On Mon, De

Re: [sqlite] Why Unicode is difficult

Next, we can talk about how dates and times are simple and straight-forward. -j > On Dec 4, 2017, at 7:08 AM, Simon Slavin wrote: > > Every so often someone asks on this list for Unicode to be handled properly. > I did it myself. Then other people have to explain how hard this is. So

Re: [sqlite] Article on AUTOINC vs. UUIDs

There are some minor points, but I agree that it basically boils down to “serial IDs break security-by-obscurity.” That’s true, but…. -j > On Nov 30, 2017, at 9:00 AM, Keith Medcalf wrote: > > > Well, in my opinion the guy is an idiot. The way to avoid the issues he is > describing a

Re: [sqlite] SQLite's Results Are Expired While Schema Is Changed !

On Aug 18, 2017, at 7:37 AM, Clemens Ladisch wrote: > Jay Kreibich wrote: >> On Aug 18, 2017, at 5:33 AM, Clemens Ladisch wrote: >>> sanhua.zh wrote: >>>> 1. Conn A: Open, PRAGMA journal_mode=WAL >>>> 2.ConnB: Open, PRAGMA journal_mode=WAL >>>

Re: [sqlite] SQLite's Results Are Expired While Schema Is Changed !

say, make sure you’re using sqlite3_prepare*_v2() or _v3(). If a statement is prepared with these newer versions, it will handle most expiration situations automatically by re-preparing the statement. Generally speaking, if you do get an SQLITE_SCHEMA error, you need to rollback the current tran

Re: [sqlite] SQLite's Results Are Expired While Schema Is Changed !

ond connection started its transaction before > the first connection committed its own, so it still sees the old state > of the database. Unlike most RDBMS environments, SQLite handles DDL as part of normal transactions. I don’t think this situation would be a problem, and would be handled by

Re: [sqlite] group_concat() reverses order given where clause?

simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/ > GraphicsMagick Maintainer,http://www.GraphicsMagick.org/ > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Jay A. Kreibi

Re: [sqlite] (no subject)

nged records. > > Thanks for any insights. > Ron Arts > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "In

Re: [sqlite] How does one block a reader connection?

he UNIX world. If you keep track of which line number you’re on, you can retry or re-pickup if a reader process needs to restart, plus the file provides a log of all messages. Simple, easy, and straight forward. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence i

Re: [sqlite] More built-in functions for basic math

portant, and we should raise the >>> bar of the minimum number of built-in functions, starting with the >>> official >>> shell. >>> >>> [1] https://www.sqlite.org/contrib/download/extension-functions.c?get=25 >>> _

[sqlite] Simple web query tool

? Or do I dust off the PHP tutorials and spend an afternoon throwing something together? -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel unco

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Jay Weinstein > > Sent: Friday, 9 December, 2016 11:50 > > To: SQLite mailing list > > Subject: Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The > > database

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

cked. But, when I to do this using a java app using the following the code doesn't work. Basically, config.setBusyTimeout() doesn't seem to be working as I anticipated -- see below. Can you advise? Thanks, Jay Class.forName("org.sqlite.JDBC"); String s = "jdbc:sqli

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

Hi, Is it correct to say busy timeout will work for two separate processes and I don't have use fork in C/C++ or ProcessBuilder in java to execute one as a child and a parent? Thanks, Jay On Wed, Dec 7, 2016 at 11:02 AM, R Smith wrote: > Yes, multiple access is a feature, a basic n

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

t.html > > and > http://www.sqlite.org/tclsqlite.html > see the section: The "timeout" method > > > > On 2016/12/07 8:54 PM, Jay Weinstein wrote: > >> Hi, >> >> I’m running two programs, one written in java and one written in C,

[sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

java app launches the c program with ProcessBuilder. Is there away for two process to read and write a sqlite database? Thanks, Jay ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/lis

Re: [sqlite] multiple processes working on one database file

On Wed, Oct 5, 2016 at 11:53 AM, Simon Slavin wrote: > > On 5 Oct 2016, at 4:30pm, Jens Alfke wrote: > > > I did find that SQLite’s own locking was less effective/fair than using > a mutex, and in situations with a lot of write contention could lead to > starvation and timeouts. It’s possible I

Re: [sqlite] Order of fields for insert

All I/O is done via page sized blocks. So the minimum amount of data to be fetched will always be a page. The bigger issue is, as you said, when you need to follow a chain of pages to get a small value at the end. -j On Thu, Oct 6, 2016 at 9:53 AM, Paul Sanderson wrote: > > Long columns, esp

Re: [sqlite] Order of fields for insert

On Thu, Oct 6, 2016 at 9:25 AM, Hick Gunter wrote: > SQLite compresses rows before storing and decompresses rows before > returning fields. BLOB fields are the most time consuming to process and so > should be placed at the end of the row. Often used fields - i.e. (foreign) > key fields - should

Re: [sqlite] Why so much I/O ? Can sqlite be improved ?

erformance ? > > The data is public available just in case it can be useful to perform tests. > > Cheers ! > > -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has

Re: [sqlite] Exec vs Prepare, step, finalize.

On Aug 11, 2016, at 12:53 AM, Michael Falconer wrote: > Thanks Jay, > > excellent response. I'll ask for clarity on one statement though. > > That’s the basic theory, but even knowing that, most people get it wrong. >> In short, if you’re using string manipulati

Re: [sqlite] Exec vs Prepare, step, finalize.

. I wondered what the > view of the SQLite dev crew was. and if there were any plans in the future > to drop the exec function? In light of the teams focus on backward > compatibility I suspect there are no such plans but I thought I'd ask > anyway just to be sure. Thanks in advance fo

Re: [sqlite] SQLite Logo

The current SQLite logo is several years old. The Apache Foundation's vertical feather logo is very new (less than a year, IIRC). Perviously the ASF logo was a horizontal feather. So the correct question is, "Why is the Apache logo basically the same as the SQLite logo?" -j On Tue, Jul 5, 2

[sqlite] Multiple in-memory database table query

qlite> select * from db3.sqlite_master; sqlite> You can see that even though I?ve opened the same ?file:data.db?mode=memory? database more than once, it is actually three distinct databases. I?m pretty sure that when mode=memory, the path/filename are ignored. -j -- Jay A. Kreibich

[sqlite] Multiple in-memory database table query

On Apr 20, 2016, at 3:22 AM, Dominique Devienne wrote: > On Wed, Apr 20, 2016 at 4:40 AM, Jay Kreibich wrote: >> >> On Apr 19, 2016, at 1:34 PM, Jarred Ford wrote: >> >>> Is it possible to create multiple in-memory databases and be able to >> access tab

[sqlite] Multiple in-memory database table query

esults in a new temporary database. Note that to run a query across databases (regardless of the type of database), the additional databases must be opened with ATTACH. You cannot run queries across databases if you use sqlite3_open*() for anything except the first database. -j -- Jay A. Kre

[sqlite] Working with booleans

gt; Integer 1 and 0 will be the most compact representation in the file format. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson

[sqlite] Last time analyze was ran

since the last run, which is likely a more useful metric. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson

[sqlite] In-Memory DB cache_size

ram cache of a In-Memory DB > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is

[sqlite] SQLite Pronunciation

> sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is import

[sqlite] Recover corrupt database

result will still be > corrupted. > ( I don't know what the corruption is) > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --

[sqlite] website documentation wording

QLite". I >>> personally would write "a SQL" because it is "sequel" to me. When did >>> SQL--sequel become SQL--ess queue ell? I always remember it as being >>> sequel, and it rolls off the tongue easier. And as sequel, it would be >> "

[sqlite] website documentation wording

gue easier. And as sequel, it would be "a > SQLite". > > Happy Holidays, all. > dvn > -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

On Nov 10, 2015, at 6:38 PM, Richard Hipp wrote: > On 11/10/15, Jay Kreibich wrote: >> >> I want to be a Certified SQLite Professional. >> > > The inventors and developers of the SQLite database engine to all to > whom these presents may come, Greetings:

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

to lack of unique implementations. As you said, there was concern that without independent implementations, aspects specific to SQLite would ?leak? into the standards and commonly used APIs, so the standard was killed. The official working group notes are here: http://www.w3.org/TR/webdatabase/

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

> On Nov 10, 2015, at 2:45 PM, Warren Young wrote: > >> On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A > centurylink.com> wrote: >> >> What no love for their own Access DB? > > This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet, DAO, > RDO, ADO, ADO.NET, ADO Entity Fram

[sqlite] Simple Math Question

al amount of software was written in assembly or with very crude compilers. With modern, RISC-ish systems, it is often almost as fast to do such things in application code, especially with a good compiler that can optimize the lower-level instructions for a specific core design. -j -- Jay A.

[sqlite] Simple Math Question

h systems) also had BCD instructions. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson

[sqlite] busy_timeout() not working always?

de is NORMAL, synchronous is FULL and threading mode is > SERIALIZED. > > Thank you in advance. > -- > Constantine. > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/list

[sqlite] This mailing list seems to be public

ite: http://www.sqlite.org/support.html#mailinglists -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson

[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

Nicolas there are other people who also receive this mail. if you have code that will help someone else. Please post the information Mr Hipp requested. Jay On Tue, Apr 28, 2015 at 5:08 PM, Nicolas Boullis wrote: > Hi, > > On Mon, Apr 20, 2015 at 06:25:21AM -0400, Richard H

[sqlite] building SQLite DLL with Visual C++

Bill & Steve Thanks guys I am trying to learn and make some progress with the information you both provided. On Mon, Apr 27, 2015 at 9:57 AM, Steven M. McNeese < steven.mcneese at freedomparkdfw.com> wrote: > Jay, > > I don't do VB.Net development but it should be v

[sqlite] building SQLite DLL with Visual C++

ot; and an ERROR "Selecting Objects of type 'Table' is not supported. Then we get to the next part of the problem. I am in my late 70's and have not done any SQL for over 15 years ( I was pretty good at one time.) Where do I go from here. Jay On Sat, Apr 25, 2015 at 5:12

[sqlite] building SQLite DLL with Visual C++

Hi Bill I have been trying for 2 days and I am totally lost. I have NuGet Package Manager. I don't know how to use it. >From the PM> System.Data.SQLiteI get an error. Can you be a little more specific. Jay On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG -

[sqlite] building SQLite DLL with Visual C++

Thanks Bill I got in a hurry and was trying to follow the book. I have never used C++ so the subject line is wrong. I am now looking into NuGet and will get back if I need more help (and I am sure I will.) Jay On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ < William.Drago

[sqlite] building SQLite DLL with Visual C++

Thanks Adam I will take a look Jay On Thu, Apr 23, 2015 at 4:19 PM, Adam Devita wrote: > Good day, > I don't work in VB, so I can't help you in specifics on that. A quick > search on a search engine pops up some videos on how to use sqlite in > a Visual Basic project.

[sqlite] building SQLite DLL with Visual C++

Thanks Igor the only response I got to the first message was "it has been bounced" On Wed, Apr 22, 2015 at 9:51 AM, Igor Tandetnik wrote: > On 4/21/2015 11:01 AM, Jay Smith wrote: > >> Before I sent the last message I had signed up to become a user. >> My previo

[sqlite] building SQLite DLL with Visual C++

2015 at 9:51 AM, Igor Tandetnik > wrote: > > On 4/21/2015 11:01 AM, Jay Smith wrote: > >> > >> Before I sent the last message I had signed up to become a user. > >> My previous message was bounced. WHY > &

[sqlite] building SQLite DLL with Visual C++

am attempting to run " LIB /DEF:sqlite3.def " I get error This error "LIB is not recognized as an internal or external command." What am I doing wrong? On Mon, Apr 20, 2015 at 10:21 AM, Jay Smith wrote: > I am new to SQLite. I have a book I am learning from and I am

[sqlite] building SQLite DLL with Visual C++

mand." What am I doing wrong? Jay

[sqlite] "=" should not be a word character

e problem you describe has much > more to do with the command-line editing library than it does with > SQLite, does it not? Assuming there is a bug in the third-pary > command-line editing library, what could SQLite do about it? > Also, don?t use double quotes for strings. SQL specifie

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

the FTS extensions implement searches. Consider providing a virtual table specific MATCH function, over-ride use on your table with xFindFunction(), and rewrite statements using MATCH rather than LIKE. See the FTS modules as examples. You might want to start here: https://www.sqlite.org/fts3.html

[sqlite] Why bind indexes start from 1 and column indexes start from 0?

> > On Mon, Mar 2, 2015 at 1:23 AM, Jay Kreibich wrote: >> >> On Mar 1, 2015, at 5:33 PM, Richard Hipp wrote: >> >>> On 3/1/15, Paolo Bolzoni wrote: >>>> Dear everyone, >>>> >>>> I find strange and confusing that bind ind

[sqlite] Why bind indexes start from 1 and column indexes start from 0?

to use C conventions. I know they?re very easy to confuse (I still do it myself), but I can kind of see why we ended up there, even if it isn?t a very strong reason. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have

[sqlite] read uncommitted data consistency

not using a shared cache (or when not using the same connection for reads and writes). Basically the connection context that created the transaction will see the actions it has performed, while all other connections will not see the changes until the transaction is committed (which, of course, is

[sqlite] Appropriate Uses For SQLite

consider VDBE instructions to be an IR. I?ve often wondering how difficult it would be to put a new front-end on SQLite to parse Tutorial D (or some other ?true relational? language) and generate VDBE instructions. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

That’s where the magic happens anyways. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable.&qu

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

5:27 PM, Janke, Julian > wrote: > >> So my question is, if there is any additional information, how to write a >> VFS? >> Or does anyone have a clue how to start best? >> > > This book: > > http://www.amazon.de/Using-SQLite-Jay-Kreibich-ebook/dp/B0

Re: [sqlite] TEMP tables with the same name as of main tables

iscussion to programmers that reference function variables using the same name as an existing global variable. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to

Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

d > be useless if they were not redefinable. > I think the OP interpreted the lack of a match() or regexp() function on the lang_corefunc.html page as meaning they could not be defined/redefined. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwe

Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

can be redefined. They can all be (re)defined, some just happen to have default functions: https://www.sqlite.org/lang_expr.html#like -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong

Re: [sqlite] Error: database disk image is malformed

give this error. If you’re using a newer version of SQLite to dump/load the files, there will be no error. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency

Re: [sqlite] VACUUM requires 6.7 times space ?

On Jan 5, 2015, at 5:03 PM, Eduardo Morras wrote: > On Mon, 5 Jan 2015 14:42:28 -0600 > Jay Kreibich wrote: > >> >> >> On Jan 5, 2015, at 12:25 PM, Jim Wilcoxson wrote: >> >>> Simon - instead of using vacuum, it's much faster to create a ne

Re: [sqlite] VACUUM requires 6.7 times space ?

I still think it would be a useful, low-cost feature. http://www.mail-archive.com/sqlite-users@sqlite.org/msg50941.html -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has

Re: [sqlite] VACUUM requires 6.7 times space ?

tables and an index. //... >>> Probably running out of space wherever temp files are created. >> > > I ran into this a while ago- used pragma temp_store_directory Which is, for good or bad, depreciated. Not sure why. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H &

Re: [sqlite] Virtual table implementation details

new schema with sqlite3_declare_vtab? > > Thank you for your help > Alessandro > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/lis

Re: [sqlite] Views as Virtual Tables -- Command line vs. Called Interface

/SQLAlchemy/SQLite list. > > Why does Python get to see the innards of a View; when the query just > involves columns (in a view) that flow straight through from the base table > (as opposed to being joined from some other table)? > > Jim > >> >> Simon. >>

Re: [sqlite] Bug in division?

nt values, then sure. But if you want integers, they store larger precise numbers, and are usually much smaller on disk. In short, the same as any other engineering decision: use the right tool for the job. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence

Re: [sqlite] Bug in division?

l, how many *whole* times does four go into two? -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncom

Re: [sqlite] select 1 where 1 - 1;

On May 5, 2014, at 6:16 PM, Scott Robison wrote: > On Mon, May 5, 2014 at 4:15 PM, Jay Kreibich wrote: > >> So far this whole discussion seems to boiled down to the fact that SQLite >> doesn’t have a native Boolean type. That’s it. No, it doesn’t. Once we >> acce

Re: [sqlite] select 1 where 1 - 1;

ent? What do you expect the opposite of NULL to be? http://en.wikipedia.org/wiki/Three-valued_logic#Kleene_logic Yes, three-valued logic is confusing to people that try to think of it in terms of “Boolean logic with special rules,” but it is all quite formal and clearly defined… it just isn’t B

  1   2   3   4   5   6   7   8   9   10   >