On 15 August 2018 at 13:57, Wout Mertens wrote:
> For the interested:
>
> In NixOS (http://nixos.org), a very interesting Linux distribution, the
> entire OS (libraries, binaries, shared files, up to and including
> configuration files) is composed out of "build products" that are addressed
> by
;)
And I am stealing it back ... I like your changes that show the computed column
affinity!
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
Hi Ricardo,
On 15 August 2018 at 06:26, Ricardo Lima wrote:
> I built a straightforward program in C. It's just a STACK structure (first
> in, last out) that takes input from the user and stores it into the stack.
> After I close the program, all the data vanishes since I don't have a
>
In case anyone followed this topic, it was noted to me off-list that I
included a mistake in the SQL posted, which might confuse people who try it!
Please see below the corrected version.
Cheers!
--Â Schema Info Views
--
-- This is a set of views that supply queryable Schema information for
On 8/7/18, Dirkjan Ochtman wrote:
>
> If INTEGER PRIMARY KEYs are always NOT NULL, I'd reasonably expect that it
> will be `notnull` even if NOT NULL is not explicitly specified. Is this a
> bug?
I don't think so. INTEGER PRIMARY KEYs have another magic property in
that if you insert a NULL
> I am using a query to check a date field between a range of dates
Can you provide example values of the date in your database?
Are you storing the EXACT date (eg, '2018-02-01 12:21'), or just the date?
> When running this with the ODBC driver it fails to return all the
appropriate record in
Ping -- I thought this might be a bug. Can someone confirm or explain why
it's not?
Regards,
Dirkjan
On Tue, Aug 7, 2018 at 7:34 AM Dirkjan Ochtman wrote:
> Yesterday I started a new project with SQLite. I wanted to create some
> simple integer-based primary keys and used an ORM to generate
On 15 Aug 2018, at 6:26am, Ricardo Lima wrote:
> I don't get any compilation errors and the SQLite source files/header files
> are implemented correctly into the code. I know this because I'm using SQLite
> Studio ( SQLite GUI) and I see all the attributes from the wallet DB, but
> they are
On 8/15/18, Mr Max wrote:
> When running this with the ODBC driver it fails to return all the
> appropriate record in the range. I tried the exact same query in a DB
> Browser for Sqlite and it recovers 127 records only.
What answer do you get when you run your query using the
To whom it may concern,
Whilst using an ODBC driver for SQLite acquired from:
http://www.ch-werner.de/sqliteodbc/
I came across a potential bug in SQLite.
I have an application running VB.NET on a Windows 7 32-bit machine and have
installed the sqliteodbc.exe from the website
I built a straightforward program in C. It's just a STACK structure (first in,
last out) that takes input from the user and stores it into the stack. After I
close the program, all the data vanishes since I don't have a database
implemented into the program. Even so, the program runs fine. It
System.Data.SQLite version 1.0.109.0 (with SQLite 3.24.0) is now available
on the System.Data.SQLite website:
https://system.data.sqlite.org/
Further information about this release can be seen at:
https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki
This release
> On Aug 15, 2018, at 11:55 AM, R Smith wrote:
>
> This has been existing for quite a while in SQLite, and not only this, but
> quite a few schema enumeration functions via the table-valued-function form
> of the pragmas.
FWIW, information_schema would be the relevant ANSI-standard in that
On 2018/08/15 8:03 AM, Domingo Alvarez Duarte wrote:
Hello Richard !
I'm following the changes you are making to a add "alter table rename
column" capability to sqlite and I think that it's a good moment to
add a new system table for the columns (I know that we can somehow get
this info now
single-quotes around the tablename -- it is a string not an identifier ...
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
Simon Slavin wrote:
> On 14 Aug 2018, at 3:09pm, Clemens Ladisch wrote:
>> However, there are other file
>> operations that are properly synchronized, e.g., it is not possible for two
>> NFS clients to create a directory with the same name.
>
> You are correct. But there's still a problem with
You can, since 3.16, get most pragma results as table-valued functions. I
think what you want is something like
SELECT * FROM pragma_table_info("tableName");
On Wed, Aug 15, 2018 at 8:04 AM Domingo Alvarez Duarte
wrote:
> Hello Richard !
>
> I'm following the changes you are making to a add
I know it's a bit of an annoying and thankless task, but visiting the
github issues and PRs every week or so (at least twice a month) and
making sure they progress, is a great way of gaining adoption…
So far I have unfortunately not needed Bedrock myself (it would be
overkill), but I just got a
Ah, to clarify, we're very, very actively developing on Bedrock every
single day. In fact, we're about to roll it out to our new 3-datacenter,
6-server cluster of 384-core, 3TB RAM, 100Gbps fiber-connected machines!
All of Expensify is powered by it, so it's been battle tested with over a
decade
On Tue, Aug 14, 2018 at 4:10 PM Clemens Ladisch wrote:
> So as long as all
> programs that access the database cooperate, they can switch to a different
> locking implementation, such as the unix-dotfile VFS:
>
> https://www.sqlite.org/vfs.html#standard_unix_vfses
>
> Note: this makes all
On Tue, Aug 14, 2018 at 6:28 PM Rowan Worth wrote:
> FWIW in the building I work in we have 20-30 users hitting around a dozen
> SQLite DBs 8 hours a day 5 days a week, with all DBs served over nfs.
Multiple writers? I presume you use WAL mode?
> Erm, I got a bit carried away. My point is,
Hello Richard !
I'm following the changes you are making to a add "alter table rename
column" capability to sqlite and I think that it's a good moment to add
a new system table for the columns (I know that we can somehow get this
info now with "pragmas") this way we can get/use this info
22 matches
Mail list logo