Thanks for the comments.
I appreciate there are nuances of their differences that are likely obvious to
a developer during development based on the current phrasing, but I'm putting
this forward from a user's perspective.
Depending on the application, an end user likely won't see the error
Hi,
Just a quick request/suggestion.
Currently SQLITE_BUSY events return an error of Database is locked. Is it
possible to change this to Database is busy or something similar?
I ask because when someone then goes googling for SQLite database locked,
they'll end up thinking they're hitting the
had no
foreign keys at all).
Cheers,
Jonathan
On 16 August 2014 20:04, Richard Hipp d...@sqlite.org wrote:
On Sat, Aug 16, 2014 at 2:41 PM, Jonathan Moules
jonathanmou...@warwickshire.gov.uk wrote:
Hi List,
More of a curiosity.
I'm doing some general data munging and set off
Hi List,
More of a curiosity.
I'm doing some general data munging and set off a query that consists
entirely of 37 DROP TABLEs in it. The database it's running against is
a bit less than 1GB made of about 5 million rows, and the tables being
dropped constitute about 99% of the content.
Hi List,
Thanks for the responses.
I don't think TCL will work for me - I want to use less languages, not more.
As to the structure - I am considering using ATTACH as a method, but
haven't gotten to the point where I need to decide which of the three
options (keys in tables, table sets, or
Hi List,
A question and possible suggestion.
Which type of average does avg() calculate? The documentation doesn't say -
https://www.sqlite.org/lang_aggfunc.html
I guess it's the mean, but it could be median or mode, so worth asking.
My suggestion would be to include an explicit statement in
Hi List,
I have a view that works fine as-is, but I want to make it dynamic,
replacing a few values with variables.
SELECT
service,
sum( num ) AS num,
round( ( sum( num ) * 100.0 ) /(
SELECT sum( num )
FROM* [$table_prefix]*_wms__getmap
WHERE time_date
July 2014 14:37, Simon Slavin slav...@bigfraud.org wrote:
On 28 Jul 2014, at 12:41pm, Jonathan Moules
jonathanmou...@warwickshire.gov.uk wrote:
*$table_prefix* which will be a number indicating which table set to look
You can't have variable table names in a prepared statement. The process