On 13 Mar 2020, at 09:35, Peter da Silva wrote:
> What do you mean there have been "just a few threads" in the mailing list?
> I can barely keep up with it.
As a lurker I can say that this mailing list suits just fine. Another forum
means another username/password I have to manage. On a list, t
On 30 Jan 2020, at 15:34, kuppappa wrote:
> Regards,
> Kuppappa
> Mobile: +91 8050095558
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
You do that yoursel
On 27 Jan 2020, at 22:18, 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 like the natural term to use, as it
> seems to mean "without a server".
>
>
On 12 Jan 2020, at 22:25, Tom Browder wrote:
> On Sun, Jan 12, 2020 at 14:05 Keith Medcalf wrote:
>
>> On Sunday, 12 January, 2020 09:03, Tom Browder
>> wrote:
>> >Am I missing something? I thought every column has to have a type?
>>
>> Close, but no banana. Every value has a type. A column m
On 10 Jan 2020, at 18:55, Keith Medcalf wrote:
> On Friday, 10 January, 2020 11:44, Tim Streater wrote:
>
>>On 10 Jan 2020, at 18:03, Richard Hipp wrote:
>
>>> On 1/10/20, Dominique Devienne wrote:
>>>> There's no way at all, to know the length
On 10 Jan 2020, at 18:03, Richard Hipp wrote:
> On 1/10/20, Dominique Devienne wrote:
>>
>> There's no way at all, to know the length of a text column with embedded
>> NULLs?
>>
>
> You can find the true length of a string in bytes from C-code using
> the sqlite3_column_bytes() interface. But I
On 08 Jan 2020, at 16:13, R Smith wrote:
> Hopefully the last of the silly questions...
>
> The word "TO" is given as an SQLite Keyword, but I cannot find any
> reference to it being used anywhere in the SQL used by SQLite.
>
> The search doesn't help (because the word TO is everywhere in text),
On 03 Jan 2020, at 22:08, sky5walk wrote:
> Querying the config state is helpful for a dll wrapped database, ...
What's one of them?
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org
On 21 Dec 2019, at 21:42, Michael Walker (barrucadu)
wrote:
> I'm not sure the attachment to my first email got through ...
Correct. The list strips them.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http:/
On 10 Dec 2019, at 21:42, Simon Slavin wrote:
> On 10 Dec 2019, at 9:35pm, Doug wrote:
>
>> For column "xxx" what will the full column name be? "foo.xxx"?
>
> For column "xxx" in table "foo", yes.
>
> However, that's only if you've used "PRAGMA full_column_names". And that
> PRAGMA is now depre
On 08 Dec 2019, at 21:55, Simon Slavin wrote:
> On 8 Dec 2019, at 7:51pm, Yongheng Chen wrote:
>
>> The bug exists in "SQLite version 3.31.0 2019-12-08 00:06:39” and before.
>
> SQLite version 3.28.0 2019-04-15 14:49:49
> Enter ".help" for usage hints.
> Connected to a transient in-memory databa
At various times in various threads on this list it has been stated that the
column name in a result set is not guaranteed unless one uses AS. IOW, one
should say
select abc as abc from mytable where i=23;
rather than just:
select abc from mytable where i=23;
I'm trying to find where on t
On 15 Nov 2019, at 20:13, Winfried wrote:
> I have a big CSV file that's encoded in Latin1 (cp1252), while SQLite stores
> strings as Unicode.
>
> Neither Google nor ".help" helped to find if SQLite offers a switch to
> convert Latin1 to UTF-8 on the fly before running the ".import" command.
>
>
On 11 Oct 2019, at 16:56, Brannon King wrote:
> I agree that Mailman is archaic. I worry about the security on it. I don't
> enjoy using 3rd-party mirrors for searching it. I'd like to propose that we
> upgrade to something more modern and secure like Sympa or mlmmj, or even a
> more drastic syst
On 07 Oct 2019, at 17:19, Keith Medcalf wrote:
> On Monday, 7 October, 2019 07:17, Jose Isaias Cabrera
> wrote:
>
>>I have to ask this question: Why is it that the date function does not
>>take a '4/5/2019' and returns '2019-04-05'?
>
> Because it does not. Humans read things in big endian o
On 15 Aug 2019, at 18:13, James K. Lowden wrote:
> On Tue, 13 Aug 2019 16:47:43 -0400
> Richard Hipp wrote:
>
>> On 8/13/19, Jose Isaias Cabrera wrote:
>> >
>> > I see all of you smart programmers using this
>> > non-column matching behavior, and I ask myself why?
>>
>> Because that's the way
On 12 Aug 2019, at 13:51, dboland9 wrote:
> I'm doing an app. that has multiple tables in sqlite. When the app. is run
> for the first time, or the tables are lost/damaged, it will create the
> database and all tables. My question is if there is a best way to create 5
> tables?
>
> I can put al
On 12 Aug 2019, at 14:30, J Decker wrote:
> On Mon, Aug 12, 2019 at 5:42 AM Simon Slavin wrote:
>
>> On 12 Aug 2019, at 1:27pm, Tim Streater wrote:
>>
>> > I don't expect to do that with SQL. My "seconds since the epoch" is
>> based on conver
On 12 Aug 2019, at 12:41, Thomas Kurz wrote:
> The problem is not only about storing an arbitrary integer or float number. A
> date is much more, it has timezone information with it, and I would like to
> see a DATE column handle this in a proper and well-defined way, just as a
> calendar (CalDAV
On 12 Aug 2019, at 00:43, Keith Medcalf wrote:
> On Sunday, 11 August, 2019 16:02, Richard Damon
> wrote:
>
>>On 8/11/19 4:21 PM, Thomas Kurz wrote:
>
I do understand the value of having date/time types in SQLite, but
it is not easy to do while retaining backward compatibility.
>
> I
On 24 May 2019, at 13:35, Jose Isaias Cabrera wrote:
> Alessandro Merolli, on Friday, May 24, 2019 07:39 AM, wrote...
>
>> Great! Now use SQLite API and add a new user defined function for
>> your used case.
>> I suppose that SQlite should always follow a well-defined pattern: in
>> this case as
On 13 May 2019, at 09:19, Christof Arnosti
wrote:
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Do that yourself at the link above.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http
On 05 May 2019, at 10:14, Michaël Doukan wrote:
> Thanks
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
You have to do that yourself using the link in each
On 04 May 2019, at 18:49, Richard Hipp wrote:
> On 5/4/19, Manuel Rigger wrote:
>> Consider the following example:
>>
>> CREATE TABLE t1 (c0, c1 REAL, PRIMARY KEY (c1, c0));
>> INSERT INTO t1(c1) VALUES (0X7ff);;
>> SELECT ALL * FROM t1 WHERE c1 = 5.76460752303423e+17;
>>
>> I would
On 04 May 2019, at 09:35, Olivier Mascia wrote:
>> Le 2 mai 2019 à 22:01, Thomas Kurz a écrit :
>>
>> I think "week of the month" is not a standard value. As with week of the
>> year, is week #1 the week in which the month starts, the first complete week
>> within the month, or the first week
On 15 Apr 2019, at 11:02, Simon Slavin wrote:
> On 15 Apr 2019, at 10:36am, Lullaby Dayal wrote:
>
>> Thank you very much for your response. The link seems to be helpful. But I
>> fail to run the .selftest command from my sqlite3 prompt. I got the error:
>> unknown command or invalid arguments e
On 03 Apr 2019, at 11:52, Tom Browder wrote:
> After coming back to SQLite from a long absence, I was surprised that
> setting things like .mode and .headers in a database didn't stay that way
> after exiting the file.
>
> Then I remembered something about a resource file and found .sqliterc on a
On 23 Mar 2019, at 16:06, Peng Yu wrote:
> I see a variety of extensions for sqlite3 database files, such as .db,
> .db3, .sqlite3 and .sq3. Is there a most commonly used/accepted
> convention for the extension? Thanks.
I use none at all. No extension is actually needed.
--
Cheers -- Tim
_
On 20 Mar 2019, at 00:35, Simon Davies wrote:
> On Tue, 19 Mar 2019 at 15:07, Tim Streater wrote:
>>
>> My use case is a mixture of these. My need is to copy a row from a table in
>> one db (db1) to a table with identical schema in another db (db2). The
>> complica
On 19 Mar 2019, at 13:46, R Smith wrote:
> Three ways in SQL to create and fill a table with data from another:
>
> 1. CREATE ... AS
> Example:
> CREATE TABLE newTable AS SELECT a,b,c FROM oldTable;
> 2. CREATE TABLE + INSERT
> Example:
> CREATE TABLE newTable(a INT, b REAL, c TEXT);
> INSERT IN
On 11 Mar 2019, at 20:21, Simon Slavin wrote:
> On 11 Mar 2019, at 7:30pm, Tim Streater wrote:
>
>> What is the maximum size in bytes that a result set may be? And what happens
>> if that size were to be exceeded?
>
> [The following is simplified for clarity. I disc
What is the maximum size in bytes that a result set may be? And what happens if
that size were to be exceeded?
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinf
On 23 Feb 2019, at 19:30, Simon Slavin wrote:
> On 23 Feb 2019, at 6:41pm, Tim Streater wrote:
>
>> The PHP interface to SQLite doesn't appear to give me access to the extended
>> codes, unfortunately.
>
> I used to do SQLite from PHP myself. Hold on ...
>
On 23 Feb 2019, at 18:10, Simon Slavin wrote:
> On 23 Feb 2019, at 5:55pm, Tim Streater wrote:
>
>> I have a hosted web site using the SQLite functions from PHP. The page where
>> PHP is used was failing, and on investigation this is because an SQLite
>> function calle
(sorry for the duplicate - vibrating finger).
I have a hosted web site using the SQLite functions from PHP. The page where
PHP is used was failing, and on investigation this is because an SQLite
function called from within PHP is now returning:
Code: 10 (SQLITE_IOERR)
Msg: disk I/O error
I wi
I have a hosted web site using the SQLite functions from PHP. The page where
PHP is used was failing, and on investigation this
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bi
On 13 Feb 2019, at 15:23, David Raymond wrote:
> On a humor tangent, am I the only person who has ever named a savepoint
> "theHounds" for the sole purpose of being able to run the statement:
>
> release theHounds;
welease Bwian;
--
Cheers -- Tim
___
On 05 Feb 2019, at 13:08, Scott wrote:
> I have a Comment table with the fields: CommentID, Summary, Comment, Pages,
> TimeStamp, Hyperlink. The TimeStamp field is setup as a Time(8), time with 8
> characters only. Not every comment in this table requires a timestamp, so it
> should remain null.
On 02 Feb 2019, at 22:19, Gerlando Falauto wrote:
> What I'm now trying to do is filter on source1 and by range of timestamp.
> Results should be naturally ordered by source1, source2,ts.
Not unless you use an ORDER BY.
--
Cheers -- Tim
___
sqlite
On 14 Jan 2019, at 18:54, Simon Slavin wrote:
> SQLite's own busy_timeout routine (the one you get if you don't supply your
> own) uses exponential backoff. It first sleeps for a very small amount of
> time, then checks the lock. If access is still prevented it sleeps longer,
> then checks again.
On 06 Jan 2019, at 13:11, Daniel Kraft wrote:
> Since it seems that the mailing list swallowed my attached example code,
> I've put it on Github as well:
Attachments are explicitly disallowed on this list.
--
Cheers -- Tim
___
sqlite-users mailing
On 17 Dec 2018, at 21:50, Thomas Kurz wrote:
> Can someone explain to me why it has been defined this way? Having 1 bit sign,
> 11 bit exponent, and 52 bit mantissa, I would have stored the (in the meantime
> well known) number 211496.26 as 21149626E-2, i.e. I would have stored a 52 bit
> integer
On 17 Dec 2018, at 04:32, D Burgess wrote:
>> Banks still use, as they have for a very long time, Binary Coded
>> Decimal, or some equivalent that does not suffer from a loss of
>> accuracy, so all this foofaraw to do with floating point representation
>> of various amounts of currency does not a
On 22 Oct 2018, at 20:08, thomgrayr...@printeasy.net wrote:
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Go to that web site, which is shown in every mail you have received from this
list.
--
Cheers -- Tim
___
sqlite-u
On 20 Oct 2018, at 17:05, "p...@geniais.com" wrote:
> I'm using a C compiled program to write exclusively to a database, and a php
> script for reading only (that communicates via socket).
> I know I can use sqlite3_open_v2() with SQLITE_OPEN_READONLY in C, but there
> is a way to open a database
On 19 Oct 2018, at 17:33, Simon Slavin wrote:
> On 19 Oct 2018, at 3:43pm, Tim Streater wrote:
>
>> is it OK to generate the myid and goodtext parts using the usual string
>> methods from my host language, leaving only badtext as a bound variable, so
>> that my prepa
Suppose I have an SQL statement like this:
select somecol from mytable where myid=3 and badtext="usertext" and
goodtext="somegoodtext"
Suppose further that the values of myid and goodtext are generated by reliably
me whereas badtext is supplied externally. If I want to use a prepared
statement
On 10 Oct 2018, at 18:10, Warren Young wrote:
> On Oct 10, 2018, at 10:39 AM, Eric wrote:
>>
>> * mailing lists come to me, I don't have to go and get them
>
> So do Fossil email alerts.
So there's an unecessary email I've just received telling me to go to the
forum. I hate emails like that.
On 07 Oct 2018, at 00:18, Warren Young wrote:
> On Oct 6, 2018, at 2:21 PM, Simon Slavin wrote:
>>
>> Excel ate the financial business world because companies use Excel to solve
>> a simple problem, then add a feature, then add another feature, and keep
>> going until they have some crawling c
On 06 Oct 2018, at 17:23, Warren Young wrote:
> I guess neither of you read the article, because the point of the original
> question isn’t to get recommendations for yet another spreadsheet program,
> it’s to get a program that lets us get away from spreadsheets-as-databases,
> because when such
On 01 Oct 2018, at 21:02, Fabrice Fontaine wrote:
> Please find attached a patch fixing this issue. As this is my first
> contibution to sqlite, please excuse me if I made any mistakes.
Don't send attachment (not allowed), include it inline.
--
Cheers -- Tim
On 07 Sep 2018, at 20:20, Richard Hipp wrote:
> On 9/7/18, Firecore wrote:
>>
>> It's easily reproduced with the sqlite3 client and db file available here
>> (https://www.dropbox.com/s/l1xofadq7vi5vjj/lock_issue.db?dl=0):
>
> I cannot reproduce it. It always runs instantly for me. I also ran
>
On 28 Aug 2018, at 15:36, Keith Medcalf wrote:
> On Tuesday, 28 August, 2018 07:50, Tim Streater wrote:
>>How does it know not to do that if I want to send some binary data to a Text
>>column?
>
> Simply because you do not request that those things be done.
>
> So,
What is actually the difference between a column declared as TEXT and one
declared as BLOB in an SQLite database? What does SQLite do to textual data
that I ask it to put into a TEXT column? How does it know not to do that if I
want to send some binary data to a Text column?
The reason I'm inte
On 17 Aug 2018, at 01:24, Casey Rodarmor wrote:
> I wrote an erroneous update statement:
>
> ```
> UPDATE foo SET bar = x'01234';
> ```
>
> The error message was:
>
> ```
> unrecognized token: "x'01234'
> ```
>
> I know now that the problem was that the blob's length was not a
> multiple of two.
On 11 Aug 2018, at 17:51, Lars Frederiksen wrote:
> Is this an error of my windows 10 cmd prompt or is it a general problem that
> the sqlite3 console is not able to show unicode in the cmd-window.??
>
> No problem writing to the database and show (greek) unicode characters in
> the cmd prompt as
On 01 Aug 2018, at 21:06, Warren Young wrote:
> On Aug 1, 2018, at 1:52 PM, Tim Streater wrote:
>>
>> I don't use the pragma since, officially, they are unsupported.
>
> “Unsupported” how? It’s documented and part of the SQLite file header, which
> is quite stable
On 01 Aug 2018, at 20:40, Warren Young wrote:
> On Aug 1, 2018, at 7:34 AM, Simon White
> wrote:
>>
>> I would like to suggest the addition of the "If not exists" to the Add
>> Column feature of SQLite.
>
> I maintain an application that’s been through dozens of schema changes over
> its nearl
On 01 Aug 2018, at 14:34, Simon White wrote:
> I would like to suggest the addition of the "If not exists" to the Add
> Column feature of SQLite. There are quite common situations where
> ensuring a column exists is important so that an update to remote
> devices will not fail but it is not s
On 29 Jun 2018, at 17:46, Bob Friesenhahn wrote:
> On Fri, 29 Jun 2018, danap wrote:
>>
>> Unless your trying to create a generic user interface.
>>
>> I have spent the last month trying to solve affinity with the columns.
>> The only way it seems to me to guarantee to solve the issue is to test
On 28 Jun 2018, at 12:48, Scott Robertson wrote:
> SQLite is supposed to autoincrement by default when a column is defined
> as "INTEGER PRIMARY KEY" according to everything I've read. But I've
> only gotten this to work if I let SQLite create its own PK column. If I
> have an explicit PK column,
On 13 Jun 2018, at 12:22, Richard Hipp wrote:
> Unfortunately, I'm going to need to shut down this mailing list due to
> robot harassment. I am working to come up with a fix or an
> alternative now. Your suggestions are welcomed.
Perhaps another subscription mechanism is needed, if that is the
On 11 Jun 2018, at 09:07, Peter Nacken wrote:
> I try to insert email addresses into a table and get an error with addresses
> they have a single quotation mark ( na'm...@domain.ltd ).
>
> Sorry I'm facing this problem for weeks, I can't find a solution.
>
> Is there a known workaround for it ?
On 06 Jun 2018, at 17:06, Sabrina Abdul Jalil wrote:
> I am on MAC OS Sierra VER 10.12.06. How to download SQLite?
It's already installed on your computer.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http:/
On 17 May 2018, at 23:13, Keith Medcalf wrote:
> select col1, col2 from mytable order by cast(body_size as float);
Thank you. That's much better (although abs(body_size) worked too).
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mai
My db has a table with a column defined thus:
body_size text default '0.0'
whose purpose is to hold the size of the item that the row represents. All rows
contain a value but as a string to one decimal place, not a number. So the
column contains strings such as '0.0', '3.7', '22.9', etc. All
On 13 May 2018, at 17:01, Dennis Clarke wrote:
> On 05/13/2018 11:57 AM, Kevin O'Gorman wrote:
> Also is that a single socket machine with a single big memory bank or
> is it NUMA and multiple sockets or is it just a single motherboard unit?
And I'd be curious to know whether memory is interlea
On 12 Apr 2018, at 21:34, Simon Slavin wrote:
> On 12 Apr 2018, at 8:00pm, Warren Young wrote:
>
>> Also: http://valgrind.org/docs/manual/faq.html#faq.pronounce
>
> I didn't know that. So they want it to be pronounced like 'lint'.
> Interesting.
That they want it pronounced that way is a matte
On 22 Mar 2018, at 14:05, Ron Watkins wrote:
> The file that I use ".import" on contains records like this:
> '2018-03-22 07:01:01'|2533268
> I had assumed the value was being treated as a datetime, but it looks like it
> may be treated as a string?
>
> Im a bit confused because the column defi
On 18 Mar 2018, at 21:48, Jonathan Moules wrote:
> CREATE TABLE lookups (
> url_id INTEGER REFERENCES urls (url_id),
> retrieval_datetime DATETIME,
> error_code INTEGER,
> is_generic_flag BOOLEAN -- about one in 100 will have this
> flagged
>
On 26 Jan 2018, at 18:12, Keith Medcalf wrote:
> Actually, EOF (0xFF) *is* part of a text file, and is the byte in an ASCII
> byte-stream that indicates end-of-file.
First I've heard of that. Which systems did that then? EOF is normally
indicated by the file system, not by file data.
--
Chee
On 22 Jan 2018, at 21:21, Nnaemeka R Egudu wrote:
> Please unsubscribe me from this mailing list.
> Thanks.
Do it yourself using this URL:
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Cheers -- Tim
___
sqlite-users
On 22 Dec 2017, at 09:57, Hick Gunter wrote:
> The problem lies in your reliance on unspecified behaviour. Unspecified
> behaviour is allowed to change.
>
> I am sure you have read (and ignored) the following guarantee taken from
> http://sqlite.org/c3ref/column_name.html :
My questions are thes
On 22 Nov 2017, at 19:49, "Niall O'Reilly" wrote:
> On 21 Nov 2017, at 16:27, Drago, William @ CSG - NARDA-MITEQ wrote:
>
>> Please, not a forum. The email list is instant, dynamic, and convenient. I
>> don't think checking into a forum to stay current with the brisk activity
>> here is very pra
On 13 Nov 2017, at 21:54, Balaji Ramanathan wrote:
> Is there a third party free tool like MS Access that would allow me to
> connect to a SQLite db in the back-end and enable me to create a custom
> front-end to it with forms and reports? All my searches for this kind of
> tool only lead me
On 02 Nov 2017, at 12:23, Rajat Pal wrote:
> In SQLite database, All the values of datetime fields are saved as text
> without any format check. We can save any text value in the datetime column.
> This behavior is creating problem for us because for different regional
> settings, datetime value
On 11 Oct 2017, at 18:53, R Smith wrote:
> Yes. When you concatenate/add a string and integer together some SQL
> engines will try to give a sensible result, so that '5' + 3 will yield 8
> because 3 is INT and it reckons that '5' probably meant 5 since it is
> added to another INT and the 5 do
On 27 Aug 2017, at 15:35, Papa wrote:
> First and foremost, I'd like to thank everybody for your replies.
> Although I have sound knowledge and understanding of C++ [ that can be
> debatable ] and still remember a little how C works, I have no Idea how
> to utilize the API of SQLitle3. Therefor
On 5 Aug 2017, at 9:35, Edmondo Borasio wrote:
> $results = $db->query("SELECT MAX(ID) FROM Table")->fetchArray();
> $Highest_ID = $results['ID'];
> var_dump($Highest_ID);
>
> I get NULL
Try:
$results = $db->query("SELECT MAX(ID) as mx FROM Table")->fetchArray();
$Highest_ID = $res
On 21 Jul 2017, at 11:14, Rowan Worth wrote:
> On 21 July 2017 at 17:50, Tim Streater wrote:
>
>>$sql = "UPDATE Movies SET name = '$newname' where id=$newid";
>>
>> Personally I don't like forcing PHP to scan strings so I tend to use
On 21 Jul 2017 at 10:04, Edmondo Borasio wrote:
> Hi Tim.
>
> It *almost* works..
>
>$DbItemNameTest = "new name";
>$hIdTest = "1";
>
>$db->exec ('UPDATE Anagrafica SET name = \'' . $DbItemNameTest .
> '\' WHERE hospital_ID="1"'); //IT WORKS
> $db->exec ('UPDATE Anagrafica
On 21 Jul 2017 at 09:58, Simon Slavin wrote:
> On 21 Jul 2017, at 7:33am, Edmondo Borasio wrote:
>
>> $db->exec('UPDATE Movies SET name = "new movie" WHERE ID="4"');
>
> Those are the wrong quotes. SQLite requires single quotes around literal
> strings, and expects no quote around numbers. An
On 21 Jul 2017 at 07:33, Edmondo Borasio wrote:
> I am updating a record of a SQLite database as follows:
>
> $db->exec('UPDATE Movies SET name = "new movie" WHERE ID="4"');
>
> but instead of using name and ID I want to use some variables, $NewItemName
> and $hId.
>
> Entering the variables as
On 29 Jun 2017 at 08:01, Eric Grange wrote:
>> The sender, however, could be lying, and this needs to be considered
>
> This is an orthogonal problem: if the sender is sending you data that is
> not what it should be, then he could just as well be sending you
> well-encoded and well-formed but in
On 28 Jun 2017 at 14:20, Rowan Worth wrote:
> On 27 June 2017 at 18:42, Eric Grange wrote:
>
>> So while in theory all the scenarios you describe are interesting, in
>> practice seeing an utf-8 BOM provides an extremely
>> high likeliness that a file will indeed be utf-8. Not always, but a memor
On 19 Jun 2017, at 12:2, Keith Medcalf wrote:
> insert into filters (absid, filter_name, enabled, filter_order)
> values (null, 'Untitled filter', 0, coalesce((select max(filter_order) from
> filters)+1,1))
>
> If you want the filter_order by filter_name then you would need:
>
> insert into filt
I want to insert a new row in my table, and while doing so setting a column to
one more than the maximum value of that column, thus:
insert into filters (absid, filter_name, enabled, filter_order) values
(null, 'Untitled filter', 0, max(filter_order)+1)
However I get "Error: no such column:
On 11 May 2017, at 23:35, Simon Slavin wrote:
> It’s the word 'remote' which is not clearly explained. In the SQLite
> documentation, the word 'remote' means you’re accessing it using a networking
> API not a file system API. It’s the network storage APIs which tend to do
> locking badly.
Loca
On 3 May 2017, at 18:16, Olivier Mascia wrote:
> Would there be a cheap way for SQLite to log some more user-realm context
> about these?
> Maybe simply emitting a second call to the log function right after these
> messages code 284 where the third parameter (msg) would simply point at the
> pre
On 15 Apr 2017 at 22:17, Simon Slavin wrote:
> On 15 Apr 2017, at 9:14pm, petern wrote:
>
>> Yes, please include it in the FAQ
>
> It’s not a FAQ. Not on this list, at least. I would argue against it.
Well he meant on the sqlite website. And if it's not a FAQ then it's
nonetheless useful in
On 06 Apr 2017 at 19:54, Jens Alfke wrote:
> PS: Tim, for some reason your mail client (iLetter) is sending replies without
> an In-Reply-To header, which breaks up the threading (at least in my mail
> client) making it very hard to follow. There’s probably not a way for you to
> change that, bu
On 06 Apr 2017 at 16:10, Simon Slavin wrote:
> On 6 Apr 2017, at 4:04pm, Tim Streater wrote:
>
>> On 06 Apr 2017 at 15:33, Simon Slavin wrote:
>>
>>> After touching, try opening the file and issuing a CREATE TABLE command.
>>> See whether it works or giv
On 06 Apr 2017 at 15:33, Simon Slavin wrote:
> On 6 Apr 2017, at 2:44pm, Tim Streater wrote:
>
>> That would appear not to be the case. Under OS X 10.9.5, I touched a
>> non-existent file and then using sqlite3.app did:
>>
>> .schema<-
On 06 Apr 2017 at 13:19, Simon Slavin wrote:
> On 6 Apr 2017, at 12:11pm, Tim Streater wrote:
>
>> When my app starts, I check that the file in question actually *is* a
>> database by doing some simple steps like open, selects from important tables,
>> and a read/wri
On 06 Apr 2017 at 11:28, Clemens Ladisch wrote:
> dave boland wrote:
>> Being a little paranoid, I like to insure that the db file exists
>
> SQLite automatically creates an empty DB if you try to open
> a nonexistent file, so you do not actually need to do anything.
>
>> and what state it is in
On 08 Mar 2017 at 20:40, Paul Sanderson wrote:
> The vast majority of dates I see in SQLite databases are unix epoch integer
> times (seconds since 1/1/1980) with unix milli seconds a close second.
> Efficient to store, sort and do date arithmetic on but need to be converted
> to display.
This
On 16 Feb 2017 at 18:30, James K. Lowden wrote:
> On Tue, 14 Feb 2017 17:05:30 -0800
> Darren Duncan wrote:
>
>> There is nothing inherently wrong with threads in principle
>
> What's inherently wrong with threads in principle is that there is no
> logic that describes them, and consequently no
On 30 Nov 2016 at 14:42, Werner Kleiner wrote:
> Hello,
> there is a small application which uses MYSQL db and can also switch to sqlite
> In MySQL a table "prices" has a column "basicprice" which is decimal(7,4)
> I can store a price in form 1.500 there.
> Same table and same columns in sqlite
On 29 Sep 2016 at 14:14, Paul Sanderson wrote:
> I have a table with dates in different formats, either 10 digit or 13
> digit unix dates
>
> 1234345087123
> 1234567890
> 1432101234
> 1456754323012
Are these strings or numbers? What is your SQL to get these into the table and
what is the schem
On 06 Sep 2016 at 11:02, Eric Grange wrote:
> Well, I guess I am in the minority using a tabbed browser then :)
>
> In tabbed browsers, all browser tabs share the same window width, and it is
> quite impractical to resize the browser every time you switch a tab.
Yes, I do the same. I have three
1 - 100 of 282 matches
Mail list logo