Re: [sqlite] fixing time-warp

On Nov 3, 2014, at 7:01 PM, E. Timothy Uy wrote: > Is that a philosophical question? :) No, it’s a persuasion challenge. I’ll propose it in two parts: 1. Why is it a good idea for you, E. Timothy Uy, to dump the SQLite code repo into a Git repo? What does this achieve, that

Re: [sqlite] x64 vs x32 DLL

On Nov 4, 2014, at 5:25 PM, Keith Medcalf wrote: > Assuming that you do rebuild the entire application as 64-bit, it will > consume at least twice the amount of memory as the x86 version and run slower > in user code. [citation needed] On 32-bit Cygwin: $ ls -lh `which

[sqlite] Open DB from stream to use System.IO.Packaging.Package

On Aug 20, 2015, at 5:27 AM, Steffen Mangold wrote: > > What I want is to use the System.IO.Packaging.Package class to build a custom > file format. > Inside this a SQLite DB should be one System.IO.Packaging.PackagePart. It seems to me that SQLite and this .NET hierarchy are both trying to

[sqlite] whish list for 2016

On Dec 24, 2015, at 9:14 AM, Simon Slavin wrote: > > ALTER TABLE DROP COLUMN ... > > ...the way SQLite3 is written makes it difficult or inefficient to implement > them. I wouldn?t mind if SQLite did nothing more than the recommended manual process for emulating the ALTER TABLE affordances

[sqlite] whish list for 2016

On Dec 24, 2015, at 8:26 AM, Bernardo Sulzbach wrote: > > I don't > know if alter table is used at all in production anywhere (why would > it be? the column names and ordering should not be part of the data). Requirements change. In the past dozen years, the database schema I?m working on

[sqlite] whish list for 2016

On Dec 24, 2015, at 11:17 AM, Warren Young wrote: > > BEGIN TRANSACTION; > ALTER TABLE Foo RENAME TO oldFoo; > CREATE TABLE Foo ? a bunch of repeated stuff >? almost identical to the initial >? DBMS creation

[sqlite] whish list for 2016

On Dec 24, 2015, at 7:49 PM, Simon Slavin wrote: > > What makes "ALTER TABLE table-name DROP ?COLUMN" hard is checking the schema > to make sure that nothing in the schema refers to the dropped column. Given that the current alternative to this feature is hand-rolled code like I gave earlier

[sqlite] What software is deployed more than SQLite?

On May 3, 2015, at 6:50 PM, jungle Boogie wrote: > > On 3 May 2015 at 11:18, Richard Hipp wrote: >> Any input you can provide is appreciated! > > Congratulations to you and your team on SQLite's achievement and I > wish you continued success. > > "Most Widely Deployed And Used Database

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

On 12/3/2013 17:29, James K. Lowden wrote: Determinism is a property of a function; there is no such thing as a function that is sometimes deterministic and sometimes not. Unless you're new to this computing thing, you must have noticed that software developers almost never mean the same

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

On 12/5/2013 14:45, Klaas V wrote: Warren wrote 4 dec 2013: | There are tiny corners of the programming world (FP) where this is not the case, but then you get into | questions of purity, and databases are about as far from side-effect-free as you can get. That's a wee bit exaggerated,

Re: [sqlite] Concrete example of corruption

On 12/5/2013 17:00, Scott Robison wrote: Might there be a way to implement a custom VFS for Mac to deal with this? Wouldn't it be a lot simpler to just put the DB file into a Mac package (i.e. directory) so the associated WAL and whatever other files get created in the package, too?

Re: [sqlite] Concrete example of corruption

On 12/5/2013 20:31, Stephen Chrzanowski wrote: @Warren> the package/sandbox idea won't work due to certain constraints the OS puts on the file. Quoting the Apple docs[1] Doug pointed to: "...you can access the document's contents using any appropriate file-system routines." I'd like to see

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

On 12/7/2013 12:15, James K. Lowden wrote: On Wed, 04 Dec 2013 12:04:07 -0700 Warren Young <war...@etr-usa.com> wrote: Determinism is a property of a function; there is no such thing as a function that is sometimes deterministic and sometimes not. databases are about as far from side-

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

On 12/7/2013 12:53, James K. Lowden wrote: On Thu, 05 Dec 2013 17:52:47 -0700 Warren Young <war...@etr-usa.com> wrote: To prove my point, I decided to divide the SQLite commands[1] into those that modify the DB and those that do not: Oh, let me help you out here: these aren't function

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On 5/28/2014 11:20, jose isaias cabrera wrote: I would rather have the speed then the size. Many years ago, I read an article written by a Microsoft employee where they said they built Windows' own binaries optimized for size rather than speed, since in today's L1/L2/L3 world, size *is*

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On 5/28/2014 12:26, Warren Young wrote: On 5/28/2014 11:20, jose isaias cabrera wrote: I would rather have the speed then the size. in today's L1/L2/L3 world, size *is* speed. Also, there is a pretty hard limit on how much micro code optimizations can help a DBMS. It's a fundamentally I

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On 5/28/2014 12:35, Drago, William @ MWG - NARDAEAST wrote: Bigger code gets kicked out of the processor cache faster, so the processor has to go back to main memory more often. Don't modern compilers consider what effects the speed optimizations will have on the pipeline and the cache and

Re: [sqlite] GUI INfo

On 9/10/2014 14:56, Maxine Nietz wrote: I am an experienced Access VBA programmer. I know about the SQLite commands to create and manipulate data in tables and queries. What I want to know is where do I find info on creating a graphical user interface such as menus, forms and reports. What

Re: [sqlite] OSX path

On 6/17/2011 4:50 PM, john darnell wrote: > > I am essentially a Windows programmer Is that also your excuse for top-posting? :) > I will have to take your > word on the use of HFS-style paths vs posix/Unix style paths on Mac > platforms. That would be wise, because Simon is correct. > I will

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

On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A 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 Framework, LINQ, the registry, Access, SQL Server Express?

[sqlite] SQLite Release 3.9.0

On Oct 14, 2015, at 4:48 PM, Craig Maynard wrote: > > I'm not sure what semantic versioning says about this semver.org is not a very long page. Spec point 2 covers this: it does not allow empty X, Y, or Z components. > why not just drop the trailing .0 and call the release 3.9? That seems >

[sqlite] OT: Oracle functions for SQlite

On Sep 13, 2015, at 3:06 AM, Domingo Alvarez Duarte wrote: > > Due the way sqlite manages it's source code (with fossil-scm) I propose to > anyone that has any extension/custom sqlite code fork this project on github: Fossil allows anonymous clones, and the Fossil server on sqlite.org is

[sqlite] sqlite3 file as database

On Sep 14, 2015, at 8:38 AM, Stephen Chrzanowski wrote: > > There are many extensions of the same .. err.. > name(?)...value(?)..structure(?) that are completely different things. It?s fairly bad in the electronics engineering world, where it seems like half the tools use *.sch for schematics

[sqlite] sqlite3 file as database

On Sep 14, 2015, at 1:02 PM, Tim Streater wrote: > > On 14 Sep 2015 at 19:29, Warren Young wrote: > >> We haven?t had to worry about compatibility with >> 3-character file extensions since Windows NT 3.5 and Windows 95, two decades >> ago now. > > Of course

[sqlite] Creating a stable database

On Sep 25, 2015, at 11:59 AM, Richard Hipp wrote: > > On 9/25/15, Aaron Digulla wrote: >> >> I was wondering if it was possible to create the same database (= no binary >> difference) twice with sqlite. > > It works fine to create identical database files when I try it: > > drh at

[sqlite] Windows A and W APIs dual support

On Feb 12, 2016, at 1:49 PM, Clemens Ladisch wrote: > > Olivier Mascia wrote: >> Are there Windows platforms, supported by SQLite source code of course, >> where the 'W' version of the APIs are not available? > > Once upon a time, SQLite supported Windows 95/98/Me. The DOS-based versions of

[sqlite] Windows A and W APIs dual support

On Feb 12, 2016, at 4:42 PM, Scott Robison wrote: > > I find it kind of interesting that Microsoft takes a lot > of (deserved) flack for not adhering to standards, yet UTF-8 came about > specifically because some didn't want to use UCS-2 ?for good reason. UCS-2/UTF-16 isn?t compatible with C

[sqlite] Performance comparison between SQLite and SQL Server?

On Feb 15, 2016, at 1:02 AM, Clemens Ladisch wrote: > > SQLite uses a much simpler locking scheme that can be faster if there > aren't concurrent accesses. SQL Server has higher concurrency. SQLite also doesn?t have the IPC overhead of a client/server DBMS, so if you don?t need concurrency or

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

On Jan 7, 2016, at 5:22 PM, Jim Callahan wrote: > > I believe R has remarkably good interface packages for SQLite That?s the appropriate level: the high-level language's DB access layer should map the low-level C record-at-a-time API to an appropriate language-level abstraction. R almost

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

On Jan 7, 2016, at 6:04 PM, Darren Duncan wrote: > > On 2016-01-07 4:55 PM, Warren Young wrote: >> 2. There is no ?preview? mechanism. > > The current method of binding is correct. All we really need is that the > debug logging layer include both the SQL of the prepared

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

On Jan 8, 2016, at 12:39 AM, Darren Duncan wrote: > > I interpreted your request as if current systems' error outputs at execute > time were printing out the problematic SQL statement with placeholder names > as originally prepared, and you wanted the error outputs to have the > placeholders

[sqlite] hard links and SQLite

On Jan 11, 2016, at 11:25 AM, Felipe Gasper wrote: > > To prevent race conditions where a 2nd process accesses a newly-created > SQLite file before the creator process can set up the schema On POSIX systems, you can securely create a temp file that only your user can see via the

[sqlite] hard links and SQLite

On Jan 11, 2016, at 11:57 AM, Stephan Beal wrote: > > On Mon, Jan 11, 2016 at 7:55 PM, Warren Young wrote: > >> There must be an equivalent of mkstemp() on Windows, doubtless taking 3 >> times as many parameters and with a function name 4 times as long. :) > > sqlit

[sqlite] hard links and SQLite

On Jan 11, 2016, at 11:57 AM, Simon Slavin wrote: > > Just do BEGIN IMMEDIATE immediately after you open the database. Doesn?t that set up a race condition? What prevents the other process from opening the DB and running its own SQL if the OS?s scheduler happens to take the CPU away from the

[sqlite] hard links and SQLite

On Jan 11, 2016, at 12:27 PM, Simon Slavin wrote: > > On 11 Jan 2016, at 7:06pm, Warren Young wrote: > >> On Jan 11, 2016, at 11:57 AM, Simon Slavin wrote: >> >>> Just do BEGIN IMMEDIATE immediately after you open the database. >> >> Doesn?t th

[sqlite] Are there practical limits to a not-so simple schema?

On Jan 13, 2016, at 5:29 AM, Simon Slavin wrote: > > My only concern with what you wrote is that you mention 100 tables. In order > to find the table you specify SQLite has to go through a list of (hashed, I > think) table names, and going through an average of 50 of them per command > can

[sqlite] Are there practical limits to a not-so simple schema?

On Jan 13, 2016, at 1:45 PM, Simon Slavin wrote: > > On 13 Jan 2016, at 7:36pm, Warren Young wrote: > >> Wouldn?t that be log2(100) = 6.6 or log(100 = 4.6 maximum node visits? >> >> Most hash table implementations have logarithmic lookup time, not line

[sqlite] Setting SQLITE_OMIT_FLOATING_POINT has surprising undocumented consequences

For no especially good reason, I decided to turn off all SQLite features I?m not using now and which I have no plans to use in the future. My current DB doesn?t use any FP columns, so I rebuild SQLite with SQLITE_OMIT_FLOATING_POINT and ran ran into a bunch of breakage: 1. The (double) cast on

[sqlite] Setting SQLITE_OMIT_FLOATING_POINT has surprising undocumented consequences

On Jan 15, 2016, at 3:11 AM, Simon Davies wrote: > > On 14 January 2016 at 22:31, Warren Young wrote: >> >> I rebuild SQLite with SQLITE_OMIT_FLOATING_POINT and ran ran into a bunch of >> breakage: > > http://www.sqlite.org/compile.html#omitfeatures > &g

[sqlite] Using sqlite3.exe as a subprocess

On Jan 14, 2016, at 8:53 PM, Matthew Allen wrote: > >p = subprocess.Popen(["sqlite3.exe", "Database.sqlite"], > stdout=subprocess.PIPE) It looks like you?re trying to use both stdin and stdout, but you really only need stdout here, since sqlite3.exe will accept SQL or sqlite3 shell

[sqlite] Find SQLITE_BUSY reason?

On Jan 21, 2016, at 5:25 AM, Daniel Polski wrote: > > Den 2016-01-21 kl. 11:30, skrev Simon Slavin: >> On 21 Jan 2016, at 9:44am, Daniel Polski wrote: > >>> PRAGMA journal_mode = WAL; >> Once the database is in WAL mode that fact is saved in the file. > > We actually can't be sure that the

[sqlite] Find SQLITE_BUSY reason?

On Jan 21, 2016, at 9:01 PM, Rowan Worth wrote: > > On 22 January 2016 at 06:33, Warren Young wrote: > >> get in, get done, and get out, ASAP. > > To a point I agree, but in reality there's a fixed amount of work involved > with each write transaction. I recent

[sqlite] Store the value from a variable into a field in database table

On Jan 22, 2016, at 6:15 AM, Hick Gunter wrote: > > You can either printf() the statement to insert the value into the text Please don?t say such things to newbies. It?s fine for an integer, but he?s going to move on to strings next and then he?ll have a SQL injection vulnerability.

[sqlite] Find SQLITE_BUSY reason?

On Jan 22, 2016, at 11:54 AM, James K. Lowden wrote: > > On Fri, 22 Jan 2016 06:24:08 + > Simon Slavin wrote: > >> This is, of course, all about waiting for a rotating disc to be in >> the right place. > > All true, but I think you're exaggerating if you're implying that's > what the

[sqlite] Bug: Successfully committed transaction rolled back after power failure

On Jan 25, 2016, at 8:47 AM, Richard Hipp wrote: > > The feedback I receive is that most users of SQLite would much rather > avoid the extra directory syncs, even if it means having the last > transaction rollback following a power loss. Why not do the directory fsync in sqlite3_close_v2()? As

[sqlite] DB-Journal

On Mar 2, 2016, at 6:00 PM, Simon Slavin wrote: > > On 2 Mar 2016, at 1:48pm, Itxaso Perez wrote: > >> - How can I 'execute' the DB-Jounal file just to try to 'correct' the >> database before execting NHibernate? > > Having a journal file on disk should not crash your app. It is possible

[sqlite] .DUMP output compatibility

On May 5, 2016, at 4:56 PM, Tony Papadimitriou wrote: > > Windows! So install Cygwin. There may be more to it than the quoting style. I?ve used the following script for moving data the other direction (MySQL to SQLite): https://gist.github.com/esperlu/943776 You might have to create the

[sqlite] SQLite custom function for regular expression using c/c++

On May 12, 2016, at 7:36 AM, Bhagwat Balshetwar wrote: > > Can you provide me link of PCRE support for SQLite. I need to install it on > Linux RHEL ES Release 4 with i686. First Google result for ?sqlite pcre?: https://github.com/ralight/sqlite3-pcre

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

On May 18, 2016, at 4:23 AM, Gerald Bauer wrote: > >> I would be interested what you find wrong about Git and is better in your >> version control system. > > [1] http://www.fossil-scm.org/xfer/doc/trunk/www/fossil-v-git.wiki Also http://fossil-scm.org/xfer/doc/tip/www/quotes.wiki

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

On May 18, 2016, at 4:43 AM, Kees Nuyt wrote: > > On Wed, 18 May 2016 11:39:28 +0200, Cecil Westerhof > wrote: > >> I would be interested what you find wrong about Git and is better in your >> version control system. > > Check the archives of the fossil-users mailing list Links to a few of

[sqlite] Podcast with Dr Hipp: SQLite history,    success and funding

On May 18, 2016, at 11:04 AM, Jonathan Moules wrote: > > I currently use Mercurial where I have a choice. > I don't seem to be able to find much about Fossil v's Mercurial. Best take it up on the Fossil mailing list. > This blog post looked interesting though: >

Re: [sqlite] Help needed for validating SQLite under Linux/Cygwin

On 11/20/2012 06:42, brijesh_philips wrote: I need to validate few tools including Sqlite on Linux environment. Currently i'm using "cygwin" for validating the tools. Don't do that. Cygwin tries hard to be Linux compatible, but there are several cases where Cygwin simply cannot behave like

Re: [sqlite] Bug in Cygwin SQLite: temporary table creation fails

On 12/26/2012 22:19, Daniel Colascione wrote: The reason this operation fails is that SQLite cannot create a temporary file in "C:\Windows", ...unless you run as Admin, which is why you don't hear this complaint come up more often. Thanks for diagnosing this in any case. It's clarified

Re: [sqlite] Bug in Cygwin SQLite: temporary table creation fails

On 12/27/2012 17:43, Daniel Colascione wrote: Yep: there was recently a long thread on the Cygwin mailing list about which mode to use for the official sqlite3 package: Yeah, I know, I was there. (Hello from the Cygwin SQLite package maintainer.) I hope you'll be able to fix this bug. In

Re: [sqlite] Bug in Cygwin SQLite: temporary table creation fails

On 12/27/2012 18:08, Daniel Colascione wrote: Yes, we have to accept the minuses we can't easily fix, but this one, we can can. Porting the Unix-mode temporary file logic to the Windows build seems workable enough. "Who is this 'we,' kemosabe?" You think it's easy, try it. You'll find that

Re: [sqlite] Bug in Cygwin SQLite: temporary table creation fails

On 12/27/2012 21:17, Joe Mistachkin wrote: I just looked at the patch briefly and I'm wondering if we could use the existing GetTempPath[A/W] as another fallback directory? The way I see it is, we are migrating from a hybrid Windows/Cygwin mode toward a purer POSIX style. Eventually, I want

Re: [sqlite] SQLite4 questions

On 3/7/2013 16:14, Richard Hipp wrote: On Thu, Mar 7, 2013 at 6:10 PM, Jeff Archer

Re: [sqlite] Cygwin compilation error

On 4/17/2013 08:06, Fulvio Esposito wrote: I'm trying to use sqlite (tried 3.6 and the latest) in a project using cygwin I just released SQLite 3.7.16.2-1 to the Cygwin repo mirrors a few days ago. If your mirror of choice is in sync, you can download it now. Is there some reason you can't

Re: [sqlite] Compiling libtclsqlite3.so on Cygwin

On 5/13/2013 16:36, Keith Christian wrote: gcc -o libtclsqlite3.so -shared tea/generic/tclsqlite3.c -lpthread -ldl -ltcl Don't build it that way. It appears that the TEA build system sees Cygwin and thinks "oh, this is Windows, so it must be VC++ or MinGW". That prevents it from linking to

Re: [sqlite] Compiling libtclsqlite3.so on Cygwin

On 5/14/2013 09:14, Keith Christian wrote: couldn't load file "./tclsqlite3.o": Exec format error From the Tcl manual: http://tmml.sourceforge.net/doc/tcl/load.html "...such as a .so file under Solaris or a DLL under Windows." Not *.o! My Tcl is awfully rusty, but I managed to get it to

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

On 6/4/2013 09:22, Philip Goetz wrote: Is it caused by using a 32-bit sqlite3? > How does a 32-bit app access a 5G file? According to https://www.sqlite.org/limits.html, SQLite doesn't really have a 32-bit limit. It's not trying to load all 5 GiB into RAM at once. It manipulates the DB

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

On 6/5/2013 11:25, Philip Goetz wrote: I suspect it's intercepting calls to the filesystem. Yes, the Cygwin DLL does translate POSIX paths to Windows paths internally. Then it calls the native APIs for you to give you the POSIX effect you asked for via the DLL. Part of the fun here is

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

On 6/6/2013 21:56, Philip Goetz wrote: I think the problem is that the Cygwin distribution has the wrong version of SQLite, one built for unix. Nope. And even if true, it wouldn't be the right explanation. There are two major ways to build SQLite on Cygwin: 1. By default, building SQLite

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

On 6/9/2013 07:42, Philip Goetz wrote: /path/to/sqlite3.exe db.sqlite on the command line just hangs. It sounds like you're trying to do that from Cygwin's mintty shell. The Windows Console infrastructure isn't particularly robust, so when a third-party program like mintty tries to run a

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

On 6/9/2013 05:21, Stephen Chrzanowski wrote: Warren, when you say "we may be switching the official builds back to Unix mode soon", you're referring only to the Cygwin builds, correct? Of course. The Win32 versions will still be generated as is? I only maintain the Cygwin packages. I

Re: [sqlite] Minimizing Internal Function Calls in SQLite

On 7/30/2013 06:11, Richard Hipp wrote: Wow. What embedded system is it that doesn't support a call stack that is *only* 35 levels deep? The 12-bit PIC microcontrollers are limited to 2-level stacks, and many of the smaller 14-bit PICs are limited to 8-level stacks. Not that I expect that

Re: [sqlite] Bug report: Sqlite seg fault, probably after database gets corrupt

On 8/1/2013 12:20, Brian Vincent wrote: Let me first say that we sometimes see databases that go corrupt. I haven't pinpointed the cause yet, This may be enlightening: "How to Corrupt an SQLite Database File" https://www.sqlite.org/howtocorrupt.html

Re: [sqlite] Version 3.8.1 beta

On 9/30/2013 07:39, Richard Hipp wrote: SQLite version 3.8.1 will be published before too much longer, probably. You can find beta versions at http://www.sqlite.org/download.html Comments, criticisms, and third-party testing of this beta is appreciated. It can't build a shared library (DLL)

Re: [sqlite] Version 3.8.1 beta

On Oct 1, 2013, at 7:49 PM, Joe Mistachkin <sql...@mistachkin.com> wrote: > Warren Young wrote: >> >> It can't build a shared library (DLL) on Cygwin any more: >> >> ./libtool --mode=link gcc -g -O2 -DSQLITE_OS_WIN=1 -I. -I./src >> -I./ext/rtree

Re: [sqlite] Version 3.8.1 beta

On 10/2/2013 03:34, Jan Nijtmans wrote: This patch appears to work Confirmed. Thanks! (but maybe -no-undefined should come in through @LDFLAGS@ No. The flag is for libtool, not for gcc, which is the program libtool calls on to do the linking on Cygwin. It will cause the link step to

Re: [sqlite] 3.8.1

On 10/4/2013 12:32, Peter Haworth wrote: I've seen emntion of version 3.8.1 of sqlite - is there a document somwhere that describes the changes? https://www.sqlite.org/draft/releaselog/current.html You could have found that link yourself from the SQLite download page, right next to the link

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

On 5/1/2012 2:06 PM, peter korinis wrote: Is SQLite the wrong tool for this project? Probably. SQLite is a data storage tool. With enough SQL cleverness, you can turn it into a data *reduction* tool. But a data analysis tool? No, not without marrying it to a real programming language.

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

On 5/3/2012 11:59 AM, peter korinis wrote: is R a good query tool? It's a programming language. It can do anything within your power to persuade the interpreter. One of the fundamental data types in R is the data frame, which is roughly equivalent to a SQLite table. This is an R

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

On 8/3/2012 1:26 PM, Tobias Giesen wrote: SQLite version 3.7.12 2012-05-14 01:41:23 Apple's version is 3.7.12 2012-04-03 19:43:07. Well, that's the problem, then, isn't it? SQLite 3.7.12 shipped on May 14. Apple must have shipped a pre-release version of SQLite 3.7.12, with the bug Dan

Re: [sqlite] 64-bit SQLite3.exe

On Aug 10, 2016, at 6:03 AM, Keith Medcalf wrote: > >> Even on a 64-bit processor, there’s usually no reason to run 64-bit >> Windows unless you have more than 4 GB of RAM, a threshold we didn’t pass >> very long ago. > > Yes, please remember to keep the "addressable memory

Re: [sqlite] 64-bit SQLite3.exe

On Aug 10, 2016, at 6:32 PM, Keith Medcalf wrote: >> You must be talking about PAE, which is an unmitigated hack, in the >> dirtiest sense of that word > > It is not a hack. It is how things work. I do not see where you get the > idea that it is a hack. Because I know

Re: [sqlite] 64-bit SQLite3.exe

On Aug 11, 2016, at 3:19 PM, Scott Robison wrote: > > I think you guys are just talking past each other. Well, at least one of us isn’t communicating clearly, that’s certain. I just don’t yet know if it’s me, him, or both of us. :) > Windows versions that > support

Re: [sqlite] 64-bit SQLite3.exe

On Aug 9, 2016, at 9:30 PM, Rousselot, Richard A wrote: > > I could spend a few hours figuring this out and be fine but it will be > painful for me. Or you can spend many hours waiting for someone to build it for you. How many hours are you willing to

Re: [sqlite] 64-bit SQLite3.exe

On Aug 9, 2016, at 11:39 PM, Rousselot, Richard A wrote: > compiling a 64-bit binary is not a useful skill It keeps me fed pretty well. :) > Your 32-bit Mac is not windows machine What, you think Intel only made Core Solos for Apple? > How long do I have

Re: [sqlite] 64-bit SQLite3.exe

On Aug 11, 2016, at 7:50 PM, Scott Robison wrote: > >> It’d be a lot of work just to avoid rebuilding for 64-bit, but maybe it >> would be an interesting project for someone. Like a master’s university >> project, maybe. >> > > At first I thought to myself that a

Re: [sqlite] 64-bit SQLite3.exe

On Aug 10, 2016, at 3:22 AM, J Decker wrote: > > I'd think many of you would know 64 bit > mode has more general purpose registers to carry values and the default > calling ABI is improved to be more of a register centric model. SQLite is largely I/O bound.

Re: [sqlite] IS read data from sqlite cost too much time more than few tens or hundred Mega Bytes

On Aug 2, 2016, at 9:04 PM, 梨田 <1565050...@qq.com> wrote: > > I find when the data in database is larger than tens of mega bytes，it spends > more than 5~10s time to read it. If the time required to run a given SELECT call increases linearly as a function of the database size, you’re probably

Re: [sqlite] Simple web query tool

On Feb 1, 2017, at 11:45 AM, Brian Curley wrote: > > internal file shares are all that's needed to > connect to a distributed file. …as long as your networked file system does locking properly: https://www.sqlite.org/lockingv3.html#how_to_corrupt

Re: [sqlite] Bulk Insert in Sqlite3

On Feb 6, 2017, at 10:36 PM, Niti Agarwal wrote: > I read about SQLITE_MAX_SQL_LENGTH, If this is why you’re making many transactions, there’s no requirement that all of the SQL that’s part of a single transaction be in a single SQL string given to the DB. You can

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

On Feb 3, 2017, at 9:15 AM, Simon Slavin wrote: > > My solicitors will be in the post. How much does it cost to mail a lawyer where you are? Do they charge by weight or unusual shape? ___ sqlite-users mailing list

Re: [sqlite] DELETE when DB is full

On Jan 31, 2017, at 2:03 PM, Ward WIllats wrote: > > the delete sometimes (very rarely) fails with a 13 "disk or database full" > error. I assume because the purger is late to the party and it needs pages in > the WAL to be able to rollback if necessary. Is there an

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On Jan 26, 2017, at 8:40 AM, Clyde Eisenbeis wrote: > > When I tried entering: > > sqlite3_bind_ > > the compiler starts complaining. What I wrote was "sqlite3_bind_*()” which you were expected to understand as a reference to the 15 functions beginning with “sqlite3_bind_”

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On Jan 25, 2017, at 8:33 AM, Clyde Eisenbeis wrote: > > The use of .Parameters in OLE DB fixes this problem. Is there an > equivalent for SQLite? You’re looking for prepared statements with parameters: https://sqlite.org/c3ref/stmt.html

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On Jan 25, 2017, at 8:50 AM, Clyde Eisenbeis wrote: > > Are there code examples similar to the following (OLE DB)? Code examples? Maybe, but the second link I gave you is pretty clear. The bits you want are even in bold text. > stCmdString += " AND " + stLikeFieldName + "

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On Jan 27, 2017, at 1:09 PM, Clyde Eisenbeis wrote: > > The SQLite websites would be more useful with examples. Certainly. No question. The thing is, I think most of us are primarily grateful that SQLite *exists* and that it works as well as it does. Given a choice of

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

On Jan 27, 2017, at 12:09 PM, John McKown wrote: > > On Fri, Jan 27, 2017 at 12:58 PM, Antonio Carlos Jorge Patricio < > antonio...@gmail.com> wrote: > >> In my tests, they got almost all chopped at 255 chars long >> > ​I'm guessing this is a problem with

Re: [sqlite] Thread safety of serialized mode

Taking it off-list, since there is zero remaining connection to SQLite now: > On Feb 16, 2017, at 2:49 PM, Tim Streater wrote: > > On 16 Feb 2017 at 18:30, James K. Lowden wrote: > >> On Tue, 14 Feb 2017 17:05:30 -0800 >> Darren Duncan

Re: [sqlite] SQLite Options

On Feb 17, 2017, at 7:32 AM, R Smith wrote: > > You can even checkout the latest commits via SVN There’s a Subversion mirror of the official Fossil code repository for SQLite? I tried to search the web for it, but since Subversion uses SQLite internally to manage its own

Re: [sqlite] Thread safety of serialized mode

On Feb 15, 2017, at 4:40 AM, Darren Duncan wrote: > > On 2017-02-15 2:40 AM, Clemens Ladisch wrote: >> Cecil Westerhof wrote: >> >> And just like with assembly code, you also have to count the time spent >> writing it, and debugging the result. > > Also, its a long

Re: [sqlite] Thread safety of serialized mode

On Feb 15, 2017, at 5:03 AM, a...@zator.com wrote: > > I suppose someday, programming languages can do an analogous translation in > our limited but safe, sequential programs. Not as long as we require side effects to achieve anything of practical value. Any form of I/O is a “side effect” by

Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

On Aug 17, 2016, at 10:38 PM, Keith Medcalf wrote: > > Same code, same compile options, same compiler version > options -s -O3 -pipe -march=native -mtune=native -falign-functions=16 > -falign-loops=16 -flto Ah, good, actual science this time instead of apples-to-oranges.

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

On Sep 25, 2016, at 4:50 AM, Cecil Westerhof wrote: > > 2016-09-22 21:04 GMT+02:00 Richard Hipp : > >> Our current schedule for the next SQLite release (3.15.0) is for >> 2016-10-14. >> >> Your beta-tests are appreciated. > > ​What can I do to beta

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

On Sep 7, 2016, at 11:02 AM, Richard Hipp wrote: > > On 9/7/16, dmp wrote: > >> The draft site looks and works fine, is fast for loads, doesn't >> seem to require scripting, GOOD! > > Sorry to disappoint, but some pages (ex: >

Re: [sqlite] .mode column .width .separator

On Oct 14, 2016, at 1:27 PM, Don V Nielsen wrote: > > I can read C, but I don't know how to compile it. https://www.sqlite.org/howtocompile.html Once you get SQLite to build, make the suggested change and say “make” again. The sqlite3 program will be rebuilt, since

Re: [sqlite] freebsd 11 SQLite build: readline/readline.h file not found

On Oct 16, 2016, at 12:45 AM, jungle Boogie wrote: > > I just re-installed freebsd 11 on a machine of mine and as usual, I > build sqlite from source. However, I see this: > sqlite3/src/shell.c:66:11: fatal error: 'readline/readline.h' file not found Did you ./configure

  1   2   3   4   >