[sqlite] Why SQLite does not use a web-based forum?

hi, > > Why SQLite does not utilize a web-based forum for all users > > discuss problems? I think that will be more convenient and can help > > more people. not agree! mailing lists are much more easier to use. Open your email in whatever client and you can see the whole discussions open in

[sqlite] A little light reading

On Sun, Nov 8, 2015 at 15:28:06 -0200, Bernardo Sulzbach wrote : > On Sun, Nov 8, 2015 at 1:25 PM, Nicolas J?ger > wrote: > > > > reminds me when, because of some "idiots database programmers", I got > > (during the same month) > > three cards automatically from the health care system with

[sqlite] A little light reading

hi, > An article by Christopher Null on how database programmers are idiots. > > Come to think of it, if you stare at the above line for long enough you won't > need the article. > But here it is anyway: > > > > Simon. reminds me when, because of some

[sqlite] Alexa has been banished. Was: Mailing list policy change

> Erm ... those pictures are of Angie Varona, a teenager from California. ok, you even know the name... their parents should be punished to let their daughter posting such pictures... stupid parents who don't take care of their children... sry about writting that, but that's exactly how I

[sqlite] Alexa has been banished. Was: Mailing list policy change

damn! I wanted a date! > On 10/29/15, Simon Slavin wrote: > > > > You don't even need to mess with the genuine list server. Just grab all the > > addresses it sends to and use another computer to send messages directly to > > those addresses using the binary-chop thing. > > Dan wrote a

[sqlite] Alexa Phishing

Le Mon, 19 Oct 2015 08:41:28 +0200, "Gert Venter" a ?crit : > I also received an eMail from alexa within 15 minutes after registering. > > GAV > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org >

[sqlite] Simple Math Question

Le Thu, 22 Oct 2015 19:45:09 +, "Rousselot, Richard A" a ?crit : > Doing the following math, why is it that the results are not all returning > "yes"? > > SELECT > (9.2+7.9+0+4.0+2.6+1.3), > case when (9.2+7.9+0+4.0+2.6+1.3)=25.0 then "yes" else "no" > end,

[sqlite] How to know when a sqlite3_stmt has been recompiled ?

hi, Scott Robison wrote: > > 3. Some time passes and some external process may alter the schema. > is it really possible ? if the answer is yes (I thought when a process open a communication with the DB, other processes can't alter the DB), for me that would mean that the design(s) of the

[sqlite] How to know when a sqlite3_stmt has been recompiled ?

Hi gwenn, Maybe you are talking about something I don't understand, or I don't understand what you are talking about... I would like somebody tells if I'm wrong or right, first in your email you have both : > >>rc = sqlite3_prepare_v2(db, "SELECT * FROM test", -1, , NULL); > >>... > >>... >

[sqlite] How to know when a sqlite3_stmt has been recompiled ?

Le Sat, 19 Sep 2015 15:21:44 +0200, Kees Nuyt a ?crit : > On Sat, 19 Sep 2015 11:29:37 +0200, gwenn > wrote: > > >Hello, > >Is there any way to know when a prepared statement is recompiled ? > >For example: > > > >rc = sqlite3_prepare_v2(db, "SELECT * FROM test", -1, , NULL); > >... > >cc =

[sqlite] Handling the whole select query from an index

hi Rob (Willet), May I ask why are you using Perl instead of C/C++ ? I'm not going to start a debate, I'm just curious. regards, Nicolas

[sqlite] I don't understand how to use NOT EXISTS

Hi, @Simon, > >CASE ( SElECT BOOL FROM _TAG_EXISTS_RESULT_ ) WHEN 0 > > CASE takes a value. You can't put a SQLite command in there. > actually, it's working if you put the command between (). I guess it's like the `` on linux (eg), mplayer `ls *.mp3` but maybe,even if it's working, you

[sqlite] I don't understand how to use NOT EXISTS

Hi guys, so there is the two ways I made: FIRST ONE: == ** Create a table wich will store the result of EXISTS, CREATE TABLE _TAG_EXISTS_RESULT_( NAME, BOOL ); ** The next query has to INSERT 'evil little sister' with BOOL to 1 in _TAG_EXISTS_RESULT_ if 'evil little sister' is

[sqlite] I don't understand how to use NOT EXISTS

Hi people! @Ryan, > Fine, but do think of if you ever might want to use the DB via > anything else, or a DB admin program... best is to ensure the DB > schema itself knows the collation and case sensitivity requirements.

[sqlite] I don't understand how to use NOT EXISTS

hi Keith, hi others, > If there should only be one entry for each name (and it is not case > sensitive), I'm using sqlite trough a C++ program wich take care of the case sensitive. In this very case, each entry has to be unique. > your best bet would be to declare that NAME is unique: > >

[sqlite] I don't understand how to use NOT EXISTS

hi, I have a table TAGS with idkey and two colums (NAME, COUNT): id|NAME|COUNT 53|black metal|3 55|occult rock|3 61|satanic smurfs|1 62|beer|0 63|pizza|0 I want to check if some tag exist by checking if `NAME` is recorded in the table or not. If not, I want to add it; INSERT INTO TAGS ( NAME,

[sqlite] I don't understand how to use NOT EXISTS

hi, I have a table TAGS with idkey and two colums (NAME, COUNT): id|NAME|COUNT 53|black metal|3 55|occult rock|3 61|satanic smurfs|1 62|beer|0 63|pizza|0 I want to check if some tag exist by checking if `NAME` is recorded in the table or not. If not, I want to add it; INSERT INTO TAGS ( NAME,

[sqlite] I don't understand why I get "cannot start a transaction within a transaction"

Hi Simon and Stephan, Thx for your answers, I was very busy the last week and I worked on my program only saturday and yesterday. That's why I answering only today, but I wanted to thank you. I had some difficulties to use `sqlite_exec()` because I'm wrapping to C++ all Sqlite3 functions I need

[sqlite] I don't understand why I get "cannot start a transaction within a transaction"

Hi, I'm starting to use transaction in my C++ code to delete some entries (tags) in my db. during execution, the first transaction (each transaction is contained in one string), like : BEGIN TRANSACTION; DELETE FROM TAGS WHERE NAME = 'loki'; DELETE FROM TAGSMAP WHERE COLLECTION_ID = '3' AND

[sqlite] why I don't get an error ?

Hi Simon, > > So you can declare a column as INTEGER and supply the string '1234' > and it will be converted to the number 1234 before it is stored. You > can check this out using > > SELECT x,typeof(x) FROM myTable > > This means that the conversion is done once on storage rather than > each

[sqlite] why I don't get an error ?

ok, thx everyone! especially R. Smith regards, Nicolas

[sqlite] why I don't get an error ?

Hi Darko, Igor and others. so the only reason to define datatype in sqlite is for the size on the disk ? so why not just only using `BLOB` (excepted for `INTEGER PRIMARY KEY`) ? being less persmissive wouldn't make querries run faster ? for example, the comparisons would not have to

[sqlite] why I don't get an error ?

Hi, I have a table built by: CREATE TABLE IF NOT EXISTS TAGS (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, COUNT INTEGER NOT NULL); where `COUNT` is an `INTEGER`. I wanted to increment `COUNT` with that command : UPDATE TAGS SET COUNT = 'COUNT + 1' WHERE ID = '666'; but when I

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

thx Andy, I'll keep that one close. When my program will be ready to perform some tests with UTF8 encoding, I'll try your solution. regards, Nicolas Le Wed, 12 Aug 2015 16:02:54 +, Andy Ling a ?crit : > > Actualy (maybe I wrong) but it leads to the same result in that case > > that using

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

Hi, Actualy (maybe I wrong) but it leads to the same result in that case that using `reinterpret_cast` my problem about doing that is I don't know if it's safe... I mean, should I not get some mess with some char code (UTF8)? I was expecting some people already did a such cast in the past and

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

I may found a solution by using 'reinterpret_cast'. Not sure that is a good solution... nicolas

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

hi John, actualy what you suggest it's the common solution. You missed the fact that here, there is an unsigned... in > http://stackoverflow.com/questions/1195675/convert-a-char-to-stdstring you can read : "It has taken me so long to realize that this constructor absolute refuses to match

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

Hi, I have some basic problem, but I didn't found the solution so far... maybe some people are using C++ and already deal with that problem : conversion from ?const unsigned char*? to non-scalar type ?std::string I got the `const unsigned char*` from `sqlite3_column_text()` and I want to pass

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

Hi, I have some basic problem, but I didn't found the solution so far... maybe some people are using C++ and already deal with that problem : conversion from ?const unsigned char*? to non-scalar type ?std::string I got the `const unsigned char*` from `sqlite3_column_text()` and I want to pass

[sqlite] how to detect when a table is modified ?

Hi Igor, just a thank you. regards, Nicolas J. > On 8/7/2015 9:17 PM, Nicolas J?ger wrote: > > I just have a question about the function : > > > > void *sqlite3_update_hook( > >sqlite3*, > >void(*)(void *,int ,char const *,char const *,sqlite3_int64), > >void* > > ); > > > > what

[sqlite] how to detect when a table is modified ?

I just have a question about the function : void *sqlite3_update_hook( sqlite3*, void(*)(void *,int ,char const *,char const *,sqlite3_int64), void* ); what is the last void* ? is it a pointer to a user data structure ? regards, Nicolas J.

[sqlite] how to detect when a table is modified ?

Hi Roger Binns and R. Smith, > Is the database being modified from within the same process, or from > outside? for that program I consider within the same process. > > The update hook will tell you (most of the time) about changes within > the same connection (ie if you are making the changes):

[sqlite] how to detect when a table is modified ?

Hi, I'm writing a program using sqlite3 and gtk to screen a database, there is a way to get a signal from sqlite3 when something is modified inside a database (values, add/delete row...), in the way to update what the program has to screen ? otherwise, any idea how I can do something similar ?

Re: [sqlite] I got some trouble with sqlite3 and my C++ program

Hi Clemens, I changed my code, now it works fine. thank you, regards, /nicoo On Thu, 15 Jan 2015 14:35:49 +0100 Clemens Ladisch <clem...@ladisch.de> wrote: > Nicolas Jäger wrote: > > do > > { > > rc = sqlite3_step(stmt); > > std::cou

[sqlite] I got some trouble with sqlite3 and my C++ program

Hi, I'm discovering/using sqlite3 since three days, and I got a problem that I don't understand. I have this code : bool DataTable_manager::searchByTags(const std::vector _list) { int rc; sqlite3_stmt *stmt; for (auto & tag : tags_list) { std::cout << tag << std::endl;