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

2010-09-06 Thread Amit Chaudhuri
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 about time :). I am also co

[sqlite] Selective update of a column

2010-11-17 Thread Amit Chaudhuri
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 sub-typ

Re: [sqlite] Selective update of a column

2010-11-18 Thread Amit Chaudhuri
Simon - thanks v. much. Makes complete sense now - and it does precisely what I wanted. :) {Appreciate the tip on the index - performance hasn't been an issue yet but I'm sure I'll end up using it.} On Wed, Nov 17, 2010 at 12:51 PM, Simon Slavin wrote: > > On 16 Nov

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

2011-03-22 Thread Amit Chaudhuri
[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 dijkstra's

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

2011-03-23 Thread Amit Chaudhuri
..representation of a decent sized real world network.. On Tue, Mar 22, 2011 at 10:59 AM, Bart Smissaert wrote: > > through a version of dijkstra's routing algorithm > > Just out of interest, what data is this working on? > > RBS > > On Tue, Mar 22, 2011 at 7:2

[sqlite] Tracking changes with sha1 hashes

2013-02-01 Thread Amit Chaudhuri
Hi all, I want to finger print my data in a manner similar to that used with git. They compute a sha1 hash of a collection of code expressed as text and use that as a unique label for that code. I was just about to write something similar into a C application to compare two sqlite3 databases. Bu

Re: [sqlite] Tracking changes with sha1 hashes

2013-02-01 Thread Amit Chaudhuri
Excellent - thanks for the answer and the extra tip. Good idea.. On Fri, Feb 1, 2013 at 3:38 PM, Igor Tandetnik wrote: > On 2/1/2013 10:21 AM, Amit Chaudhuri wrote: > >> If I only issue select queries on my two input databases, can I expect the >> sha1 hash to stay

Re: [sqlite] Programming API vs console

2013-04-27 Thread Amit Chaudhuri
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 transaction that does 5

[sqlite] Trivial typo in queryplanner.html docs

2013-05-14 Thread Amit Chaudhuri
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 the

[sqlite] another typo in planner.html

2013-05-14 Thread Amit Chaudhuri
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 mailin

Re: [sqlite] Command history not working in sqlite3 tool for MAC OS

2012-05-10 Thread Amit Chaudhuri
My Mac is running system provided sqlite3 (3.6.12) and up arrow returns last command as expected. Did you install 3.7.11 your self, if so I wonder if you missed a component (e.g. one which provides the cmd line functionality). On Fri, May 11, 2012 at 6:33 AM, Neo Anderson wrote: > > The UP/DOWN

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

2011-06-14 Thread Amit Chaudhuri
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 spre

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

2011-07-14 Thread Amit Chaudhuri
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] Is it possible to check a data type in a query?

2011-07-15 Thread Amit Chaudhuri
Perfect - thank you both.. On Thu, Jul 14, 2011 at 12:15 PM, Simon Slavin 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 price for this, sorry." I can handle t

[sqlite] Compiling sqlite as as library

2015-07-02 Thread Amit Chaudhuri
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 s

[sqlite] problem compiling std_call dll

2015-03-01 Thread Amit Chaudhuri
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 l

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

2019-11-12 Thread Amit Chaudhuri
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 posti

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

2020-01-28 Thread Amit Chaudhuri
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 th