Re: [sqlite] New word to replace "serverless"

I like the slightly opaque "compact". A On Tue, 28 Jan 2020 at 13:31, Donald Shepherd wrote: > > On Wed, 29 Jan 2020 at 12:26 am, Jose Isaias Cabrera > wrote: > > > > > R Smith, on Tuesday, January 28, 2020 06:39 AM, wrote... > > > > > > I do not have a great suggestion to add, but to observe

Re: [sqlite] Things you shouldn't assume when you store names

Ha ha ha - Oh Simon.what *have* you done? [Apologies for the noise - could not resist this one.] On Sat, 9 Nov 2019 at 19:26, Simon Slavin wrote: > > Since I don't see many posts yet this weekend, please excuse one of mine > which isn't exactly on charter. Feel free to argue me out of

[sqlite] Compiling sqlite as as library

Maybe this will help? http://stackoverflow.com/questions/4234767/how-do-i-build-sqlite3-from-command-line On Thu, Jul 2, 2015 at 10:25 AM, Prakash Premkumar wrote: > I tried with the following flags : > > gcc -arch x86_64 -o sqlite3.o sqlite3.c shell.c > > > and > > >> gcc -m32 -o sqlite3.o

[sqlite] problem compiling std_call dll

Bart, you say "don't know anything about C or C++ or compiling C code" Perhaps this will help. The error message (unresolved) external means that the linker is trying to find something (_sqlite3_db_filename in this case) but it cannot. Possible common causes include - it has been misspelt (I'm

[sqlite] another typo in planner.html

Seection 2.0 line 4 SQLite processes this by gather all the output of query and then running ... SQLite processes this by gathering all the output of query and then running ... A ^^^ ___ sqlite-users

[sqlite] Trivial typo in queryplanner.html docs

Hi all, reading through queryplanner.html today I notice a trivial typo in section 1.6, line 5: If there were a third column, it would be used to break ties for the first to columns. If there were a third column, it would be used to break ties for the first tWo columns. ^^^ It doesn't spoil

Re: [sqlite] Programming API vs console

CREATE TABLE playersdrafted(playerid integer, id ineteger, Don't think ineteger is what you really mean.:) Seen it twice now so guessing it's actually in the code On Sat, Apr 27, 2013 at 8:34 AM, Igor Korot wrote: > Simon, > In the other area of the program I have a

Re: [sqlite] Is it possible to check a data type in a query?

Perfect - thank you both.. On Thu, Jul 14, 2011 at 12:15 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 13 Jul 2011, at 1:13pm, Amit Chaudhuri wrote: > > > I have situation where a column may contain prices (REAL) or a string > > meaning "no pric

[sqlite] Is it possible to check a data type in a query?

Hi all, I have situation where a column may contain prices (REAL) or a string meaning "no price for this, sorry." I can handle this in application code but was wondering if I am overlooking a Sqlite feature which might do the same out of the box: perhaps a TYPE( ) or an IsText( ) function..? A

Re: [sqlite] ATTACH DATABASE .tables .schema ?

I'm a huge fan of the command line tool. At work we use it extensively when prototyping. We're probably amongst the less technically sophisticated of users, so the ability to quickly script an approach using a few text files is something we value hugely. It's a great way of weaning people off

Re: [sqlite] In-memory database with persistent storage

n Tue, Mar 22, 2011 at 7:25 AM, Amit Chaudhuri > <amit.k.chaudh...@gmail.com> wrote: > > [Not at all expert in sqlite but here's a practical example of speed up > > using ":memory:" and perhaps a slightly different strategy for getting at > > the persistent data.]

Re: [sqlite] In-memory database with persistent storage

[Not at all expert in sqlite but here's a practical example of speed up using ":memory:" and perhaps a slightly different strategy for getting at the persistent data.] I use sqlite3 with Qt4 / C++ for an application which reads in an undirected graph and then chunks through a version of

Re: [sqlite] Selective update of a column

16 Nov 2010, at 3:29pm, Amit Chaudhuri wrote: > > > The approach I tried was to perform 2 sequential updates using first the > > fixed call source table then the mobile. I tried to restrict the update > to > > rows in target where the class of call (fixed or mobil

[sqlite] Selective update of a column

Hi all, I can't work out how to do something I feel ought to be easy. Attached small file is designed to be .read to provide a test case. Explanation of what I'm trying to follows below. I have two separate but very similar source data sets, one for mobile one for fixed calls of various

Re: [sqlite] Create a GUI for interacting with a test questions sqlite db

Arthur, Nokia's Qt4 may be worth a look. Amit On Mon, Sep 6, 2010 at 7:51 AM, Arthur Avramiea wrote: > > Thank you very much for your answers. I already have mysql, php, c and some > beginner c++ experience. Learning a new language wouldn't be about > difficulty, but