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 th

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 posti

Re: [sqlite] is this possible

From the page https://sqlite.org/lang_createview.html : "The CREATE VIEW command assigns a name to a pre-packaged SELECT statement ..." So, it seems that the command "CREATE VIEW" just creates a name for a SELECT statement, and checks nothing more than syntax. On 28.3.2019 21:21, Mark Wagne

Re: [sqlite] How to refer to `this` table?

Try creating a trigger(https://sqlite.org/lang_createtrigger.html) instead of the constraint "noCircularRef_when the table already exists. On 23.2.2019 8:43, Rocky Ji wrote: If I do CREATE TABLE Sample ( id INTEGER PRIMARY KEY AUTOINCREMENT, parent_id INTEGER, CONSTRAINT p FOREIGN KEY

Re: [sqlite] How to backup a memory database to a memory stream?

Is "sqlite3_serialize" (https://sqlite.org/c3ref/serialize.html) helpful? On 22.2.2019 8:57, heribert wrote: Is there any way to backup a memory database directly to a memory stream? In my case i have to backup a small memory database directly into a byte array, without using any os based temp

Re: [sqlite] why no unique columns on alter table

Probably because altering a table is done by changing the value of column SQL in table 'sqlite_master'. Adding a unique constraint requires value checks. On 12.2.2019 6:15, Mark Wagner wrote: This is mainly for my curiosity. Is there any particular reason that one can't add a unique column on

[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 s

[sqlite] SQLite queries

Hello, This is Amit Golhani from Larsen & Toubro India, currently I am evaluating features of SQLite to meet our product requirements, which are mainly as follows: -database should recover automatically without human intervention in case of abrupt power failure/ crash/ termination of pro

[sqlite] problem compiling std_call dll

n misspelt (I'm looking at that underscore) or you have failed to point it at a library. I'm afraid I'm not fluent in the windows tools to track this down and don't have a system I can follow along with. But on Linux one might use the nm utility to examine a contents of library

Re: [sqlite] Using pragma user_version when doing updates

Richard Hipp writes: > > You can access the user version using "PRAGMA user_version". > Unfortunately, you cannot combine a pragma with a larger query. > Yes, I feared as much. Thanks for the response, Amit ___ sqlite-use

[sqlite] Using pragma user_version when doing updates

SE but it doesn't seem to like the pragma statement in there. Thanks, Amit ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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 mailin

[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 the

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 transaction that does 5

Re: [sqlite] Tracking changes with sha1 hashes

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

[sqlite] Tracking changes with sha1 hashes

can I expect the sha1 hash to stay the same over time? Maybe it would make more sense to hash the data before it goes in the database. But I thought I'd poll for opinions. Amit ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit

[sqlite] Need to Increase sql parameter limit more than 999

than 999 parameters that exceeds SQLite parameter limit. We would appreciate if you would help us customizing the SQLite database parameter limit. Kindly provide the steps to get this done. Thanks, Amit Bhardwaj ___ sqlite-users mailing list sqlite-users@

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

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] 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 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] 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 spre

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

..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

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 dijkstra's

Re: [sqlite] Selective update of a column

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

[sqlite] Selective update of a column

rst: I can have either fixed results or mobile results but not both. I'm pretty sure I'm doing something wrong but haven't been able to find examples which show me how to resolve. Any pointers much appreciated... Regards, Amit Version 3.7.3 on Windows XP [For the time being I h

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 ab

Re: [sqlite] SQL Quick Review/Reference

oks. This makes it > very difficult and frustrating to use as a Reference Book. > > I also purchased "Beginning Database Design - from Novice to > Professional" by Clare Churcher, but found it to much of a beginners > book for my needs. > >

Re: [sqlite] SQL Quick Review/Reference

On Sat, 12 Apr 2008 10:40:43 -0400 "P Kishor" <[EMAIL PROTECTED]> wrote: > On 4/12/08, Amit Uttamchandani <[EMAIL PROTECTED]> wrote: > > Hey everyone, > > > > Just got back into the world of SQL after being away for 5 years. This > > time I

[sqlite] SQL Quick Review/Reference

omething similar for SQL is what I am looking for. I've googled around but I thought why not ask the SQL veterans here? Thanks, Amit ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] problem with undefined reference

e3_errmsg' > CreaDB.c:(.text+0xe3): undefined reference to `sqlite3_step' > CreaDB.c:(.text+0x103): undefined reference to `sqlite3_column_text' > CreaDB.c:(.text+0x12d): undefined reference to `sqlite3_column_count' > CreaDB.c:(.text+0x154): undefined reference to `sqli

Re: [sqlite] Proper use of sqlite-amalgamation.

t; realized that I was simply a gcc command away. I go ahead and compile > > it using: > > There's a link in the download page: > http://www.sqlite.org/download.html > that points to: > http://www.sqlite.org/amalgamation.html &g

Re: [sqlite] Proper use of sqlite-amalgamation.

On Thu, Apr 3, 2008 at 3:24 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote: > On Thu, Apr 3, 2008 at 5:39 PM, Amit <[EMAIL PROTECTED]> wrote: > > > > 1. Is there any documentation that I may have missed that addresses > > the above issue? If not, the

[sqlite] Proper use of sqlite-amalgamation.

pon the above commands. Is this the right way to do it? 3. I am writing a program under python 2.5. And from various readings it seems like sqlite3 is bundled with it? * If so, how is it used? * If not, how do I use the amalgamated version of sqlite with python 2.5? Any comments or sugg

[sqlite] Help needed: using sqlite with j2me (MIDP)

.* classes in a j2me program because the j2me libraries does not support java.sql. If any body has done this then please help me. With Regards Amit Akela ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Use of alloca() in SQLite sources

arguments of a function call, because the stack space reserved by alloca would appear on the stack in the middle of the space for the function arguments. -- Amit Upadhyay - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[sqlite] Recommendation..

hread safe so its fine. TIA and best wishe. -- Amit Upadhyay - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]