On Sunday, 7 Oct 2018 5:25 PM -0400, Keith Medcalf wrote:
>
> Many people do not "do" web forums. I am one of them. If there is not a
> mailing list then it does not exist.
I completely agree. I read and post to the SQLite mailing via Gmane,
and I used to do the same for Fossil. Now that th
On Thursday, 26 Jul 2018 7:58 PM -0400, Richard Hipp wrote:
> On 7/26/18, Tomasz Kot wrote:
>> Hello,
>>
>> Beneath sql shall throw an error on CREATE VIEW statement (as invalid
>> column is specified), but it passes (SQLite 3.23.1).
>
> The error is deferred until you try to use the view. The
On Tuesday, 10 Jul 2018 2:27 PM -0400, Randall Smith wrote:
> My underlying question is "can text-comparing two DB dumps be used
> to determine what has changed?"
I don't know if it will meet your needs, but I've written a script for
my own purposes to compare DB changes. Since it's fairly sho
On Friday, 30 Mar 2018 11:38 AM -0400, Ian Zimmerman wrote:
> On 2018-03-30 11:28, Marcin Ciura wrote:
>
>> { 0x0426, 0x54, 0x63, 0x00, 0x00 }, /* Ц to Tc */
>> { 0x0446, 0x74, 0x63, 0x00, 0x00 }, /* ц to tc */
>>
>> This Cyrillic letter is usually transliterated as Ts. Unless "Tc" is
>>
On Friday, 16 Mar 2018 11:37 AM -0400, Richard Hipp wrote:
> This is a survey, the results of which will help us to make SQLite faster.
>
> How many tables in your schema(s) use AUTOINCREMENT?
0
--
Will
___
sqlite-users mailing list
sqlite-users@maili
On Wednesday, 8 Mar 2017 3:40 PM -0500, 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 arithmet
On Friday, 6 Jan 2017 3:48 PM -0500, Keith Medcalf wrote:
>
> On Friday, 6 January, 2017 12:49, James K. Lowden
> wrote:
>
>> On Fri, 6 Jan 2017 10:23:06 +1100
>> "dandl" wrote:
>>
>> > Unix globbing for Linux is defined here:
>> > http://man7.org/linux/man-pages/man7/glob.7.html. AFAICT Sqli
I don't usually see questions about using SQLite3 from Ruby here, so I
hope this is not out of place.
Ruby is my normal programming language of choice nowadays, and I've
been very happy with the sqlite3 ruby gem to use SQLite3 within my
programs. I'd now like to make use of the SQLite3 session ex
On Friday, 11 Sep 2015 10:12 AM -0400, Valentin Davydov wrote:
> On Thu, Sep 10, 2015 at 01:30:37PM +0200, Eduardo Morras wrote:
>>
>> Use gmake to compile.
>
> It didn't work either. Finally I've just installed some brand new linux
> on a nearby virtual machine, made there make -f Makefile.linux
On Monday, 24 Aug 2015 2:46 AM -0400, Mark Lawrence wrote:
>> It's theoretically possible, but in that case I would be content to
>> force a difference in the title. It should be possible to have the
>> following:
>>
>> 'History of Scotland' | -> 'A. Jones'
>> 'History of Scotland' | -> 'T. Smit
On Saturday, 22 Aug 2015 1:05 PM -0400, R.Smith wrote:
>
>
> On 2015-08-21 11:23 PM, Will Parsons wrote:
>> On 21 Aug 2015, R.Smith wrote:
>>>
>>> On 2015-08-21 04:47 AM, Will Parsons wrote:
>>>> I'm working on a program that involves a catalogue
On 21 Aug 2015, Scott Robison wrote:
> Another consideration: it is possible that two different anonymous books
> are indeed different books. It is also possible a given "author" releases a
> new rewritten book with the same name. I'm thinking of the Hardy Boys
> series in particular from my person
On 21 Aug 2015, 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 Books(id integer primary key,
>>
I'm working on a program that involves a catalogue of books. Part of
the database schema looks like this:
create table Books(id integer primary key,
title text collate nocase not null,
author references Authors(id),
...
u
Richard Hipp wrote:
> On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden
> wrote:
>
>> On Wed, 6 Aug 2014 07:40:43 -0400
>> Richard Hipp wrote:
>>
>> > >
>> > > PS: backward compatibility, no s, no?
>> > >
>> >
>> > A google search shows that you see it both ways - with and without the
>> > "s". I'
mm.w wrote:
>>
Can someone please get this a*h*l* banned?
--
Will
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I have two applications that access the same database and that can run
at the same time. If changes are made to the database by one
application, I would like the other application to update its display
to reflect the change. The total_changes() function only works from a
single connexion so doesn
17 matches
Mail list logo