Re: [sqlite] sqlite3 crashes mysteriously on 3.6.20-1

Can you move project to different hardware? On Mon, Nov 14, 2016 at 3:02 PM, pisymbol . wrote: > On Mon, Nov 14, 2016 at 12:38 PM, pisymbol . wrote: > > > > > > > On Mon, Nov 14, 2016 at 12:14 PM, pisymbol . wrote: > > > >> > >> > >> On Thu, Nov 10, 2016 at 11:52 AM, Richard Hipp wrote: > >>

Re: [sqlite] Autoincrement sequence not updated by UPDATE

Works here; SQLite version 3.13.0 2016-05-18 10:57:30 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> CREATE TABLE foo (bar INTEGER PRIMARY KEY AUTOINCREMENT); sqlite> INSERT INTO foo (bar) VALUES(1234); s

Re: [sqlite] Introducing Bedrock: SQLite for the Enterprise

So am I to understand you just "server-ized" SQLite with Bedrock? Looks rather interesting. I was just talking to my IT manager about how I can take something like a SQLite backup and put it somewhere else so it'll eventually get to tape, but, if I run a node on my local machine, run one on the '

Re: [sqlite] Inserting a new record (anywhere) into a table of ordered records that have an integer auto-increment primary key

What you want to do is called using a linked list. Each record knows what its previous record is. SQLite doesn't exactly have that capability directly. No SQL engine that I know of has the capability. Each row is unaware of any other row in that table. That row is a unique entity to itself, ob

Re: [sqlite] Protecting databases

If you're developing in Windows, you could leave it to the file system, but could be dangerous, and then binds you to using an NTFS based OS. NTFS has the capability of doing file level encryption, and you can flip the flag on the file to have the filesystem encrypt the file. The catch is, the en

Re: [sqlite] Parallel access to read only in memory database

(My two cents) I just setup two brand new machines in our Colo for ESX. Both machines had 256gig of memory. Not unheard of in server situations. ;) On Fri, Oct 7, 2016 at 4:48 PM, Simon Slavin wrote: > > On 7 Oct 2016, at 9:37pm, Daniel Meyer wrote: > > > We have database files that are on the

Re: [sqlite] smartest way to exchange a sqlite3 database with another empty

Are you looking to keep the logs in the same file, or, are you looking to put your log entries in a new file? If you're interested in just keeping a single file, and if you've got access to change your code that is writing to the database, then, what I would do is "create table if not exists Logs

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

The vacuum removes empty pages by rewriting the database ground up. https://www.sqlite.org/lang_vacuum.html "The VACUUM command works by copying the contents of the database into a temporary database file and then overwriting the original with the contents of the temporary file. When overwriting

Re: [sqlite] Potential bug: Database on gvfs mount cannot be committed to

"snapshotable" or not, DBs are accessed from the local file system, not from a network where another OS has control of the file system. On Sun, Sep 18, 2016 at 10:16 AM, Florian Weimer wrote: > * R. Smith: > > > Enterprise DBs have servers on the same machine as the Files they > > access, they d

Re: [sqlite] how is "pragma threads = 4" working

Although programmatically easily done, from the SQLite point of view, what if that query, sans LIMIT, were a subquery, and the limit was put out on the outside? Would the inner query execute, use all the threads, then return just one row on the outer? On Fri, Sep 16, 2016 at 7:29 AM, Richard Hipp

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

I knew I had done this before. I don't know if this is still relevant. Tested in FF38. I'm old skool, don't use CSS all that much, and I don't even know if this is a CSS2 or 3 thing. I typically do back end code, I'm no where near a UI designer or artist. When I do have to make a web UI, I typi

Re: [sqlite] schema_version and Vacuum or Backup API

n Fri, Sep 9, 2016 at 11:33 AM, R Smith wrote: > On 2016/09/08 4:59 PM, Stephen Chrzanowski wrote: > >> >> Is there a way that I can get your sub-query (Reordered to have tables, >> then indexes, then views) to come out as one row? I can then have the >> applicati

Re: [sqlite] schema_version and Vacuum or Backup API

Apparently, no. Error is "cannot create trigger on system table". On Thu, Sep 8, 2016 at 11:19 AM, Stephen Chrzanowski wrote: > Interesting idea. I'll try that on a scratch DB when I get the > chance. (Spent too much time in this thread, rather than doing work I'

Re: [sqlite] schema_version and Vacuum or Backup API

Interesting idea. I'll try that on a scratch DB when I get the chance. (Spent too much time in this thread, rather than doing work I'm being paid to do. heh) On Thu, Sep 8, 2016 at 11:07 AM, Scott Robison wrote: > On Sep 8, 2016 8:16 AM, "Richard Hipp" wrote: >

Re: [sqlite] schema_version and Vacuum or Backup API

easy string comparison, AND have a method to include the resource string to create a new DB (FILE>NEW) in one go. On Thu, Sep 8, 2016 at 10:16 AM, Richard Hipp wrote: > On 9/8/16, Stephen Chrzanowski wrote: > > > > However, the rabbit I was hoping to pull out of the hat was tha

Re: [sqlite] schema_version and Vacuum or Backup API

a SQL statement to update. I still have to come up with a way to effectively alert me that a schema change was done, and I need to come up with a SQL statement to correct the problem. On Thu, Sep 8, 2016 at 8:47 AM, Richard Hipp wrote: > On 9/8/16, Stephen Chrzanowski wrote: > > If

Re: [sqlite] schema_version and Vacuum or Backup API

I build my queries usually via binding within the function I'm calling, which I don't think changes the schema version, since I'm only seeing a bump of +1 at application close during either a vacuum or the backup API call. That said, since I know that the backup API will make the schema version ch

Re: [sqlite] Best way to "split" a large DB into two DBs

What are the business logic reasons you want to split the database? Is your application going to be able to handle dealing with data that'd exist in multiple places? When I know I'm going to be putting large blobs within a database, those blob tables have two fields, one ID, and one for the actua

Re: [sqlite] schema_version and Vacuum or Backup API

So by design then. Alright, thanks. Guess its plan B with user_schema. On Tue, Sep 6, 2016 at 8:04 AM, Clemens Ladisch wrote: > Stephen Chrzanowski wrote: > > [...] I'm relying on the results from "pragma > > schema_version". I've noticed that this bumps up

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

I have my ancient Galaxy S (Original ) Android hanging here on my desk, and I pulled up the draft page, and it looks good. With respect, Dr. Hipp, I really do hope you weren't REALLY pressured into this (And the analogy between the soda-stra

[sqlite] schema_version and Vacuum or Backup API

I'm updating one of my units in Delphi to automatically output the schema of any database I'm attempting to open while in the debugger for two purposes. One reason that when a user does a FILE> NEW, the most recent database is created based on the SQL commands found in sqlite_master, and the schem

Re: [sqlite] Education Opportunity Alert: The SQL Primer

*sits back and waits for the people to cringe about Sequal or Ess-Que-El and smirks* On Thu, Aug 4, 2016 at 11:14 AM, R.A. Nagy wrote: > Hi all, > > Let me begin by thanking everyone for the feedback on the YouTube video > effort! > > For those who would like to revisit our relatively comprehens

Re: [sqlite] In what case will the online backup api hang for acquiring the Btree lock of the destination on-disk file?

Quan; If a single process/thread is dumping to the NFS, it shouldn't matter, especially since the backup routine is one-way, and there are no 'transactions' happening which would cause locking failures. This is more relevant when you have active transactions fighting with the live database where

Re: [sqlite] new version

There isn't really an installation. The DLL would need to be in either your Windows\System32 directory (Or some PATH Windows knows about), or in the same directory as your EXE. The other option, if you're building SQLite into your application, is get the Amalgamation and build your product off th

Re: [sqlite] Query question: order by ascending, return the two largest values in ascending order

Simons + My answer; select * from (SELECT date_time_stamp FROM general ORDER BY date_time_stamp DESC LIMIT 2) a order by date_time_stamp; On Mon, Jul 11, 2016 at 7:33 PM, Simon Slavin wrote: > > On 12 Jul 2016, at 12:25am, Keith Christian > wrote: > > > A table has a column of dates and times

Re: [sqlite] Different error messages for the same syntax error

insert into table test defaults; On Mon, Jul 4, 2016 at 2:21 PM, gwenn wrote: > Hello, > > SQLite version 3.13.0 2016-05-18 10:57:30 > sqlite> create table test (name text default ''); > sqlite> insert into test values (); > Error: near ")": syntax error > sqlite> insert into test values (''),

Re: [sqlite] Locking semantics are broken?

In Mr Smiths examples, one statement effect is a direct result of an action you (subjectively speaking) knowingly did, or did not do, to the car. You did not fuel the car. You did take the wheels off. There by, your car is essentially a hunk of metal taking up space. It doesn't function as desi

Re: [sqlite] unregister

You need to do that via the last link in every message. ( http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users) On Sat, Jun 11, 2016 at 1:44 PM, Gianni Sassanelli wrote: > please un-register this email-address from mailinglist > > thanks > ___

Re: [sqlite] Messages posted on Nabble not getting to list

I'm a big time die hard fan of "text only". I'm an information consumer, and not someone who likes being distracted by meaningless visual effects. My Linux consoles are all (mostly) white on black, my 5-monitor Windows desktop looks like Windows 2000, and my 3-monitor work machine follows that su

Re: [sqlite] Messages posted on Nabble not getting to list

Times have changed, because people get 'bright ideas' that just don't work. I don't want to look at 30 different forums that might claim "The official forum of SQLite" or whatever. Also, I don't have to worry about security different forum services offer. Everything comes right to my email, and

[sqlite] Password Protect SQLite DB

True. Depending on the data sensitivity (Say a phone book) the restriction may be to allow or deny access to modifying phone numbers, changing names, or what have you. It may all be 'public knowledge' within the domain of who has access, so reading the data may not be the security hotspot. But c

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

Just finished listening to it as well. Dr Hipp, I know you don't like to toot your own horn, but, really, I'd really like to hear where and when you're talking to other people about SQLite and your other projects. Really interesting info. On Sat, May 14, 2016 at 5:49 PM, Steve Schow wrote: >

[sqlite] Incremental backup/sync facility?

Gerry; I trashed the email I was going to send. You had the same line of thought as me in regards to chopping the file on a per-day basis, but, what made me trash it was any auto-numbered PKs that would be a hassle in new files, unless that information was put into the new DB upon creation. I ag

[sqlite] Version 3.13.0 coming soon

See in-line; On Wed, May 4, 2016 at 4:39 AM, Wolfgang Enzinger wrote: > > Two more typos (IMHO, I'm not a native English speaker): > > "where not being recognized" -> "were not being recognized" > > "Where" could be right or wrong, but I suspect this is the correct word. WHERE would mean somethi

[sqlite] Working with blob

Semantics and methodology of use aside, SQLite is the same as MySQL, MSSQL, Access, etc, in that it is a tool to store and retrieve bytes in a retrievable way via some kind of structured language. None of mentioned tools actually do any sort of presentation of said data. "From the factory", SQLit

[sqlite] FOREIGN KEY constraint failed

I've never developed for a platform with a small memory footprint (Unless you talk about the Vic20 as being the smallest footprint I've used, but not relevant to SQLite, and my skill was writing text based paint program), but, throwing results like this into memory could cause more issues for devic

[sqlite] Error help

Large CSV? How large? Because the constraint error is probably coming from the browser for an upload constraint on size versus SQLite throwing an error. On Mon, Apr 4, 2016 at 12:26 PM, Daniel Telvock < dtelvock at investigativepost.org> wrote: > I am using the Firefox plugin of SQLite and thi

[sqlite] Reserved column names

AFAIK, SQLite comes from the grass roots of PostgreSQL. Whatever 'standards' it adheres to, SQLite goes by. As a fact, I don't know what those standards are, and I don't care what they are. The documentation on SQLite.org says "This is how you use it", so that's how I'll use it. Besides, SQL-xx

[sqlite] SQLite Pronunciation

Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto: > sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Stephen > Chrzanowski > Sent: Wednesday, March 16, 2016 3:09 PM > To: SQLite mailing list > Subject: Re: [sqlite] SQLite Pronunciation

[sqlite] SQLite Pronunciation

Standards, official, or not, I've always pronounced it as Sequel. Ehm-Ess-Sequel, My-Sequel, Sequel-Lite, etc. IMO, S-Q-L is an acronym, as everyone knows, and since RADAR(1) is also an Acronym, why the fuss? To me, it falls off the tongue easier to say Sequel instead of Ess-Queue-Ell. 1- http:/

[sqlite] "Circular" order by

On Thu, Mar 10, 2016 at 2:16 PM, R Smith wrote: > > I do this kind of thing so often when filling a selection box for instance: > SELECT 'None' > UNION ALL > SELECT City FROM Countrylist WHERE Country = :1 > UNION ALL > SELECT City FROM Countrylist WHERE Country <> :1 ORDER BY City > > Which

[sqlite] CTE for a noob

at is going on here, but practice is whats needed. Thanks again! On Mon, Mar 7, 2016 at 9:56 PM, Igor Tandetnik wrote: > On 3/7/2016 9:47 PM, Stephen Chrzanowski wrote: > >> Currently my application makes two queries to the database. One to get >> the >> list of pr

[sqlite] Creating & Dropping memory databases

Thanks gents. It is all handled internally by SQLite. Good enough. On Mon, Mar 7, 2016 at 9:14 PM, Simon Slavin wrote: > > On 8 Mar 2016, at 2:10am, Stephen Chrzanowski wrote: > > > Out of curiosity, from a memory management standpoint, if I create a > memory > > d

[sqlite] CTE for a noob

I'd like to learn how to use CTEs by example when working on my own project, by mutating it from individual calls into one clean call. I looked at the page (As I said in my previous email/note/post(?)) and just thought I'd put this question out there. Given I have the schema posted here: http://p

[sqlite] Creating & Dropping memory databases

Out of curiosity, from a memory management standpoint, if I create a memory database, populate simple tables and such, to what falls the responsibility with cleaning up the memory used? Will SQLite handle :memory: databases internally, flushing out the tables from memory? Does my application have

[sqlite] ABI report

What does ABI stand for? API I'm assuming Application Programming Interface (As per the site content). On Thu, Feb 25, 2016 at 10:23 AM, Richard Hipp wrote: > On 2/25/16, Ponomarenko Andrey wrote: > > Hello, > > > > I've started to maintain ABI report for the SQLite library here: > > http://ab

[sqlite] Why is a separate journal file needed ?

IMO, all that, plus the fact that you have an easy roll back mechanism. Anything that needs to be put in the database is external to the pristine database. Lock the database with a transaction, fill up the journal, the power goes out, your pristine database isn't touched. Just whatever happens in

[sqlite] Documentation Typo

There'll be fights about that. I'd suggest "a database is used to store". On Tue, Feb 16, 2016 at 11:16 AM, Chris Malumphy wrote: > On https://www.sqlite.org/datatypes.html there is a typographical error. > > In the first paragraph of 1.0 Typelessness > > "A database is suppose to store and ret

[sqlite] SQLite?

You'll need to write your own routines to do that. There is no way to sync directly, such as 1:1 replication. The best you can hope for is to write an api that tells MySQL to do particular updates. If you want two way sync, then your app will not only need to listen for inbound, or at least poll

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

On Mon, Feb 1, 2016 at 11:20 AM, Rowan Worth wrote: > > > I've seen situations > > where files have been deleted in Linux (Not allowed in Windows) and data > > still gets dumped into the now deleted file. > > > ? > This is not an error, this is standard POSIX file semantics - if you have a > file

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

h. I'm pretty firm with my statement of "You pull that plug, all bets are off". All software depends on hardware. You yank that plug, you have an unknown state until you bring it up. Power surges and sags are evil to computer hardware. On Mon, Feb 1, 2016 at 10:14 AM, Howa

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

@Rowan; First off, whether the OS or SQLite is ACID or not, if you pull the plug on your hardware, all bets are off on whether it'll BOOT, let alone recover a single transaction. I get that this could be a useful tool when doing disaster proofing, but, at that stage in the game of bulletproofing,

[sqlite] ​ Use Bash to Store Disc Info in SQLite

On Fri, Jan 29, 2016 at 8:59 PM, Cecil Westerhof wrote: > > > However, I've run into a few problems, so I'm offering my findings and > > fixes. > > > > The first, line 3, you've got a reference to a script that doesn't exist > > AFAIK. You should maybe put a check to see if the file exists first

[sqlite] ​ Use Bash to Store Disc Info in SQLite

nk it'll affect anything in my game, so, not concerned about it, but will most certainly keep that tidbit of info in the back of my head. On Fri, Jan 29, 2016 at 7:25 PM, Simon Slavin wrote: > > On 30 Jan 2016, at 12:14am, Stephen Chrzanowski > wrote: > > > And finally, mayb

[sqlite] ​ Use Bash to Store Disc Info in SQLite

The partition portion failed not because of multiple references to / but multiple references to tempfs. Maybe set the constraint to not only the partition type but also the mount point? On Fri, Jan 29, 2016 at 7:14 PM, Stephen Chrzanowski wrote: > This is going to be useful for me for a cou

[sqlite] ​ Use Bash to Store Disc Info in SQLite

This is going to be useful for me for a couple of reasons. First, I've got a machine at work that mysteriously fills up, and more importantly, I can monitor my Minecraft server at home. ;) However, I've run into a few problems, so I'm offering my findings and fixes. The first, line 3, you've got

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

On Mon, Jan 25, 2016 at 10:08 AM, Matthias-Christian Ott wrote: > > If so, why isn't SQLITE_EXTRA_DURABLE=1 the default? Should correctness > be more important than performance, except when the constraints are such > that correctness has to be sacrificed for performance? > I wouldn't want that,

[sqlite] Where to find the last sqlite3.dll

Check again at http://sqlite.org/download.html I've found that once in a blue moon, a lot of the files go missing, but, they'll come back. Probably due to an update they're doing with the files, or something. Just bad timing. :] On Thu, Jan 21, 2016 at 4:35 AM, Michel LE CLEZIO < michel_le_clez

[sqlite] Database is locked

As with the other suggestions, have a read of https://www.sqlite.org/howtocorrupt.html If you've got to distinct machines/OS's trying to touch the same file, you might be looking at other issues. Also, if you are indeed working over a network, your timeout might be set so low that SQLite just tim

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

On Fri, Jan 8, 2016 at 10:54 AM, R Smith wrote: > > I can't agree more - and to add, while I can sympathize with the point, I > absolutely love SQLite, but the amount of projects I have made without > SQLite far outweighs those containing it (on all platforms). I would like > it to remain optiona

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

Because this list supports many different things, not just SQLite downloaded from sqlite.org, maybe I'm off target with my interpretation of these wishlists. I'm not arguing about pros and cons of shared libraries directly. My comments were made from a tired guy who started the day early, was bus

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

I personally wish the reverse. I wish that these interpreted language engines would incorporate the SQLite code directly into their own existence to avoid having to write wrappers to begin with, except for those wrappers where their method name is "DatabaseOpen" and I prefer "OpenDatabase". SQLit

[sqlite] The database disk image is malformed

Alright, accepted. NFS isn't exactly the proper terminology, however, RFS (Remote File System) might be a better fit for that particular question. Basically, as soon as another OS handles the files directly, you're looking at a possible collision of requests against a SQLite database, which is why

[sqlite] The database disk image is malformed

All of what Richard asked and said, plus, my question of where the file stored in relation to the application? (Network attached storage?) On Tue, Jan 5, 2016 at 10:22 AM, Richard Hipp wrote: > On 1/5/16, Andrew Stewart wrote: > > Hi, > > I am getting the following error on a da

[sqlite] whish list for 2016

a 10gig file and tear the internals of the DB to shreds. On Mon, Jan 4, 2016 at 11:11 AM, Bernardo Sulzbach < mafagafogigante at gmail.com> wrote: > On Mon, Jan 4, 2016 at 1:50 PM, Stephen Chrzanowski > wrote: > > > > I did the test to compare SSD vs 5200rpm and 7200rpm driv

[sqlite] whish list for 2016

I once faked a database, created random data, deleted random data, re-inserted random data of random sizes, got the database to a couple gigs in size, I noticed that the temp file SQLite made when running vacuum accounted for about the same size of what the actual database was. I guess I had the v

[sqlite] whish list for 2016

Two parter; *Part 1;* One thing I would suggest, if you're looking to add and delete columns dynamically is not to worry about the order of the columns in the database, but, have a second table hanging around that remembers the specified order the user wants to see the columns in. Doing your upd

[sqlite] bug when columns are missing in embedded subselect

I work for a flight planning software house, so I had to take a double-look at this. Competition, eh? ;) On Tue, Dec 15, 2015 at 4:14 PM, Richard Hipp wrote: > > > Interesting timing: I was monitoring an inbound flight on flightaware > when this issue report arrived in my inbox. :-) > > -- >

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

Why not a pragma option that toggles the option to the bag populated? If the pragma is not set, things run as expected. If the pragma is set, keep the bag. Another option for those that link directly to the engine is at each violation counter up, and another for each violation counter down, add

[sqlite] [AGAIN] SQLite on network share

Where's the like button when you actually want to use it? On Sun, Nov 15, 2015 at 8:05 PM, James K. Lowden wrote: > On Fri, 13 Nov 2015 13:19:33 -0800 > Roger Binns wrote: > > > On talking to sites that had the competitor devices, we'd find they > > did notice increases in programs crashing and

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

Prior to release or otherwise, it feels that if MSoft were to have skipped the registry and just used the GROUP->KEY=VALUE setup in INI files only, things would be much better as far as cleaning up viruses at LEAST, especially if you start locking down these files at the NTFS level. But then again

[sqlite] [AGAIN] SQLite on network share

I've read through all the other posts on this thread, and I must agree. Your "serverless" configuration can't exist because each client becomes a server, BY DEFINITION, when it starts PROVIDING information to other clients. I've written a book, by now, when this topic comes up. Believe me Alessan

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

Wicked. Congrats! On Tue, Nov 10, 2015 at 2:41 PM, Richard Hipp wrote: > http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/ > > -- > D. Richard Hipp > drh at sqlite.org > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sq

[sqlite] Question about Style

I've tackled this problem a few ways; *Method 1* The one I usually go with (Old habits die hard, and I'm freak'n lazy when it comes to one or two statements in the whole application) is just put the SQL string right into the code. That way it doesn't 'get lost', I don't have to rely on external s

[sqlite] Why SQLite take lower performanceinmulti-threadSELECTing?

@sanhua> If you can, just for testing, use the SQLite backup mechanism to copy the database to memory, then run your transactions off the memory version. This will get rid of disk IO with the exclusion of the OS swapping to memory. This will tell you if you're running into some kind of thread loc

[sqlite] from hfiandor about a unit in spanish

This isn't SQL related, however, being a Delphi developer, I'll help. Not sure if Laz (I've only done a cursory glance at the whole package) will support it, but you might be able to set the forms "ActiveComponent" property to nil. Either that, use the buttons "OnMouseOver" event and find out wha

[sqlite] [sqlite-dev] Proposed new version numbering scheme for SQLite - Feedback requested

I'd add the disclaimer to the page that once 3.2.0 is built, 3.1.x becomes inert and any fixes pertaining to that particular release belongs to the 3.2.* release. "Lawyer speak", I guess one could coin it. What the "Effect Definition" is of what Major and Minor is, I think Richard draft page has

[sqlite] [sqlite-dev] Proposed new version numbering scheme for SQLite - Feedback requested

I'm indifferent, to be quite honest, how the version numbers work and what I download, so long that there is a difference and things become more solid with both enhancements and fixes.. Set the file name and revisions to a date, for all that it matters to me, or just label is as SQLite3.dll/.zip/.

[sqlite] in memory database bug or documentation mismatch

I'm not familiar with this method, but, shouldn't it be file::memory: or something of the sort? On Mon, Oct 5, 2015 at 8:30 AM, Richard Hipp wrote: > On 10/5/15, Jacob wrote: > > Hello, > > > > I have tried to create an in memory database according to the > > documentation on this link > > http

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

buggy, and such. It shouldn't be considered for use in a production environment. On Mon, Oct 5, 2015 at 1:18 AM, Scott Doctor wrote: > > Is there a release date set for sqlite4? > > > Scott Doctor > scott at scottdoctor.com > ------ > > &

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

https://sqlite.org/src4/tree?ci=trunk On Mon, Oct 5, 2015 at 12:02 AM, Jerry wrote: > Seems I could not find its source code ... > https://sqlite.org/src4/doc/trunk/www/index.wiki > > Thanks. > ___ > sqlite-users mailing list > sqlite-users at mailingl

[sqlite] Odd download file names

Yes, I did run [fossil ui], which launched a web browser to localhost/ 127.0.0.1. I didn't know about showsql. That'll absolutely help. On Tue, Sep 29, 2015 at 8:09 PM, Richard Hipp wrote: > On 9/29/15, Stephen Chrzanowski wrote: > > I did use the UI. It temporarily c

[sqlite] Odd download file names

. So hopefully this stuff will keep me awake. heh On Tue, Sep 29, 2015 at 1:07 PM, Richard Hipp wrote: > On 9/29/15, Stephen Chrzanowski wrote: > > Long story story short, "fuel" didn't do what I wanted, so it got > > scrapped. It wouldn't show me a history of what

[sqlite] Odd download file names

is that I can now get rid of the 300+meg of zip files I've been collecting over this past year. :] (Also, I'll be able to get rid of the actual amalgamation source code revision files sitting in my SCM, and not worry about using Bloodshed IDE) On Tue, Sep 29, 2015 at 9:24 AM, Richard

[sqlite] Odd download file names

up with a procedure, I can turn off the script. :] On Tue, Sep 29, 2015 at 3:51 AM, Kees Nuyt wrote: > On Tue, 29 Sep 2015 02:01:03 -0400, Stephen Chrzanowski > wrote: > > > For the past year, I've had a script that runs daily that reads all the > > links off of http://sql

[sqlite] Odd download file names

Fourth question has been answered, but I was looking at the source code to find my answer. Now, to go step back in time :] On Tue, Sep 29, 2015 at 2:01 AM, Stephen Chrzanowski wrote: > For the past year, I've had a script that runs daily that reads all the > links off of http:/

[sqlite] Odd download file names

For the past year, I've had a script that runs daily that reads all the links off of http://sqlite.org/download.html and downloads anything that is missing. It has been a long while since I've looked at this particular section of my NAS, but thought I'd bring my repositories up to snuff, and build

[sqlite] sqlite3 file as database

%E2%80%93Z%29 There are many extensions of the same .. err.. name(?)...value(?)..structure(?) that are completely different things. Look at .DAT files. On Mon, Sep 14, 2015 at 10:31 AM, Stephen Chrzanowski wrote: > That is the default extension for DBaseIII, but I've not heard any win

[sqlite] sqlite3 file as database

That is the default extension for DBaseIII, but I've not heard any windows or linux or mac system of the past 10 years have anything to do with a DBaseIII files. There may be edge cases for old accounting applications, but it is such old technology, I do doubt it is in use for anything of new impo

[sqlite] BEGINNER - Transactions in shell script

As with Rob, this is my final say as well. On Fri, Sep 11, 2015 at 1:38 PM, Petr L?z?ovsk? wrote: > > 1. Security through obscurity is your first mistake. There is no such > thing. > > Interesting It does not exist, but it have article on wikipedia. > Sounds like UFO or Yetti... > "Security

[sqlite] BEGINNER - Transactions in shell script

You'd be surprised by what is out there trying to get into your system. I had port 22 open on my home router to go to a Linux machine so I could SSH into my home network from anywhere in the world, even though I rarely ever leave the 519 area code. One day I went to look at my messages log file a

[sqlite] Insertion into the large DB drastically slows down at some point

I'm with Simon. If you're writing 5 million rows to memory, the OS has to move unused memory out to disk. I'd say write the data to disk (SSD if you can) and check if the data written out is at a consistent speed. On Thu, Aug 27, 2015 at 10:29 PM, Simon Slavin wrote: > > On 28 Aug 2015, at 3:

[sqlite] Why sqlite show qualified column names when selecting from views ?

I'm sure either #1 or #3 happens already. I know I've been nagged about ambiguous field names, but I also know that somewhere I've seen _1 or _2 be appended to field names (That might be just the SQL IDE I use doing that). I can't get on board with #2 because most wrappers only look at the first

[sqlite] order by not working in combination with random()

On Wed, Aug 26, 2015 at 3:00 AM, J Decker wrote: > but, your order by is the only place that uses the date function... it > would have to be reversed as > elect ItemName,SoldDate, date('now','-1 month') as z from > SoldItemDetails order by > SoldDate > which I would think would evalutate to a to

[sqlite] order by not working in combination with random()

Somewhat of a devils advocate here, but I'm not sure one can order based on JUST data. Take the DATE function, for example. If, by your words, ORDER BY should only act on the data, consider this kind of query: select ItemName,SoldDate from SoldItemDetails order by SoldDate wrote: > > ORDER BY s

[sqlite] design problem involving trigger

Another option would be to not use NULL but use an empty string. On Fri, Aug 21, 2015 at 9:17 AM, R.Smith wrote: > > > On 2015-08-21 04:47 AM, Will Parsons wrote: > >> I'm working on a program that involves a catalogue of books. Part of >> the database schema looks like this: >> >> create table

[sqlite] Tables and Columns of Database of Whatsapp

There are a few posts in this mailing list that have people putting up public domain database structures, with data, for different things to track. Google search also has come up with a few out there as well, but, you really got to nail down the query as just searching for "Public domain database"

[sqlite] Mozilla wiki 'avoid SQLite'

I as well disagree that "the higher language, the better". The bloat .NET adds to the application size for both processing, memory and drive usage is astronomical. Its like going back to Visual Basic and including the interpreter in your "compiled" application with your source code basically copy

[sqlite] Mozilla wiki 'avoid SQLite'

nformation contained within is absolutely correct IMO, is that they're targeting mostly the wrong foundation. I know that it is a page of "Things to watch for" but targeting SQLite itself.. well.. I feel that the author is looking through the wrong looking glass. On Sun, Jun 14, 201

[sqlite] Mozilla wiki 'avoid SQLite'

Most of that looks to be more like common sense things rather than SQLite specific, so why they're calling out SQLite, I've no idea. Also, this doc was last modified more than a year ago. Stuff has changed both within FF as well as SQlite since then. I've just deleted the blog I was going to wri

<    1   2   3   4   5   6   >