-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 24/09/13 16:37, Neville Dastur wrote:
> That's a very interesting concept.
I've been doing it since 2004, and support all versions of Python from 2.3
onwards including 3.x.
> Are you using http://www.cython.org/ or something else to "create" the
>
That's a very interesting concept.
Are you using http://www.cython.org/ or something else to "create" the library
wrapper
Neville
On 24 Sep 2013, at 22:39, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 24/09/13 12:56, Neville Dastur wrote:
>> Searching around on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 24/09/13 12:56, Neville Dastur wrote:
> Searching around on Google it seems that namespacing in c / obj-c is
> not possible for the sqlite3 library.
There is another approach that I use. I produce a Python C extension.
The final shared library wit
>From time to time, with a database already loaded with hundreds records, I
need to change a column name, or move a field from one table to another
table(sometimes even another database). I use python to code with my
database. With python if you want to refactor your code there is a lot of
tools to
It is using the country table and aliasing it to languages ...
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of John Drescher
> Sent: Tuesday, 24 September, 2013 10:50
> To: General Discussion of SQLite Database
> Subjec
Okay, so it's already namespaced with a prefix which I can replace. Thank you
On 24 Sep 2013, at 21:27, Richard Hipp wrote:
> On Tue, Sep 24, 2013 at 3:56 PM, Neville Dastur
> wrote:
>
>> Hi
>>
>> I am hoping someone can help with this one. I am aware that some might
>> consider it a C issue
On Tue, Sep 24, 2013 at 3:56 PM, Neville Dastur wrote:
> Hi
>
> I am hoping someone can help with this one. I am aware that some might
> consider it a C issue more than sqlite3, but C doesn't handle this well and
> so I am looking for specific sqlite3 info.
>
> I am looking to create my own sqlite
Hi
I am hoping someone can help with this one. I am aware that some might consider
it a C issue more than sqlite3, but C doesn't handle this well and so I am
looking for specific sqlite3 info.
I am looking to create my own sqlite3 Appcelerator module. Appcelerator at
present already uses sqlit
On Mon, Sep 23, 2013 at 12:19 PM, Jean-Marie CUAZ wrote:
> Hello,
>
> Thanks to SQlite developement team for this wonderfull library
>
> We have been hit today by the following :
>
> package require sqlite3
>
> sqlite3 db1 test
>
> db1 eval {CREATE TABLE T1 (A PRIMARY KEY, B, C, D UNIQUE DEFAULT
On Mon, Sep 23, 2013 at 11:19 PM, Aryc wrote:
> All;
> I'm trying to use SQlite as a transfer medium between my PHP world and my
> Python world.
> in PHP i can read and write just fine. but when i try to read the database
> from a python program i get the dreaded "file is encrypted or not a
> dat
On Tue, Sep 24, 2013 at 2:02 PM, Petite Abeille wrote:
>
> On Sep 24, 2013, at 7:59 PM, Dan Kennedy wrote:
>
> > A double quoted string is treated as a column name if possible, or a
> > string literal otherwise. It's an SQL thing.
>
> Nah. The second part is a SQLite thing. Randomly converting id
On Sep 24, 2013, at 8:16 PM, Simon Slavin wrote:
> The first version (INSERT OR FAIL, then UPDATE) won't lead to any SQLite
> errors if one of the rows already exists. So you can do a whole lot of both
> lines in one transaction and the transaction will still succeed.
Is that so? If 'INSERT O
On 24 Sep 2013, at 7:19pm, Marc L. Allen wrote:
> INSERT OR IGNORE?
Dammit, yes. I meant INSERT OR IGNORE, not INSERT OR FAIL. Thanks Marc.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
On Sep 24, 2013, at 8:05 PM, Simon Slavin wrote:
> Which is why you do an INSERT first, and allow it to fail, then do the UPDATE.
Sure. A lot of error proce procedural code to do what one SQL statement could
do much more naturally.
___
sqlite-users
So it does! And, for those of us lucky enough to be on a system that isn't 8
years old, enjoy! ;)
And now that I see that, I will renew push for upgrades.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Petite Abeille
Sent
INSERT OR IGNORE?
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Slavin
Sent: Tuesday, September 24, 2013 2:16 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Bug : Tcl interface + "INSERT OR REPLACE
On 24 Sep 2013, at 7:09pm, Marc L. Allen wrote:
> Also, there are times when you do a bulk insert, so you have to structure the
> query to not fail on records that are already present.
Yeah. Actually I got what I posted wrong. I should have written
Which is why you do an INSERT OR FAIL, the
On Sep 24, 2013, at 8:09 PM, Marc L. Allen wrote:
> Not complaining, mind you. MS SQL doesn't have it, and I've long learned to
> deal with it.
MS SQL Server sports a MERGE statement if I'm not mistaken:
http://msdn.microsoft.com/en-us/library/bb510625.aspx
__
On 9/24/2013 12:49 PM, John Drescher wrote:
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote:
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
CityCountry Languages
Country
On Sep 24, 2013, at 8:06 PM, Marc L. Allen wrote:
> Considered harmful? How so? I wouldn't mind a version of ON CONFLICT UPDATE
> fieldlist.
In its current form.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/m
Yes, of course. But, it seems a waste of time, since you're obviously already
at the record (or at least done the initial index search) to not be able to
simply update it.
Not complaining, mind you. MS SQL doesn't have it, and I've long learned to
deal with it.
Also, there are times when you
On Sep 24, 2013, at 7:54 PM, "Marc L. Allen"
wrote:
> Yep. What most people want is an INSERT OR UPDATE.
Yep. Which is what one usually calls 'MERGE':
http://en.wikipedia.org/wiki/Merge_(SQL)
And sadly, SQLite doesn't provide anything like that at all. Oh, well… 'ON
CONFLICT clause' cons
Considered harmful? How so? I wouldn't mind a version of ON CONFLICT UPDATE
fieldlist.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Petite Abeille
Sent: Tuesday, September 24, 2013 1:59 PM
To: General Discussion of SQLit
On 24 Sep 2013, at 6:58pm, Petite Abeille wrote:
> On Sep 24, 2013, at 7:54 PM, "Marc L. Allen"
> wrote:
>
>> Yep. What most people want is an INSERT OR UPDATE.
>
> Yep. Which is what one usually calls 'MERGE':
>
> http://en.wikipedia.org/wiki/Merge_(SQL)
>
> And sadly, SQLite doesn't p
On Sep 24, 2013, at 7:59 PM, Dan Kennedy wrote:
> A double quoted string is treated as a column name if possible, or a
> string literal otherwise. It's an SQL thing.
Nah. The second part is a SQLite thing. Randomly converting identifiers into
literals is more of a misfeature.
On 24 Sep 2013, at 9:50am, pisey phon wrote:
> And now I have an error with insert data into database with Sqlite3.
> Errro: "SQLite3::exec() [sqlite3.exec]: near "SET": syntax error".
Insert a debugging line into your program so that having make up the full
INSERT command it shows it on the d
On 24 Sep 2013, at 4:19am, Aryc wrote:
> I'm trying to use SQlite as a transfer medium between my PHP world and my
> Python world.
> in PHP i can read and write just fine. but when i try to read the database
> from a python program i get the dreaded "file is encrypted or not a database"
> mes
On 09/24/2013 04:52 PM, Alexander Syvak wrote:
Hello,
using input select all "project@na" from project where 1 yields 4 lines of
"project@na". In fact the column named project@na does not exist, but the
project@name does in the tested data base. What is the gist of such a
result?
A double quot
Yep. What most people want is an INSERT OR UPDATE.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Petite Abeille
Sent: Tuesday, September 24, 2013 1:48 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Bug
On Sep 23, 2013, at 6:19 PM, Jean-Marie CUAZ wrote:
> -> no exception is raised to host langage Tcl for 2 rows not inserted because
> a UNIQUE constraint is not respected
> -> partial execution : 2 rows are definitely deleted from the table ...(ouch
> !)
Yep. Looks like it does exactly what i
Hello,
using input select all "project@na" from project where 1 yields 4 lines of
"project@na". In fact the column named project@na does not exist, but the
project@name does in the tested data base. What is the gist of such a
result?
P.S. Please, reply to my e-mail.
Regards,
Alexander.
___
And now I have an error with insert data into database with Sqlite3.
Errro: "SQLite3::exec() [sqlite3.exec]: near "SET": syntax error".
I a a new with Sqlite3
here is my code:
open($db_file);
}
public function connecting($db){
if(!$db){
Hello,
Thanks to SQlite developement team for this wonderfull library
We have been hit today by the following :
package require sqlite3
sqlite3 db1 test
db1 eval {CREATE TABLE T1 (A PRIMARY KEY, B, C, D UNIQUE DEFAULT '-')}
db1 eval {INSERT INTO T1 VALUES (0, 1, 1, 'a') , (1, 1, 1, 'b') , (
thanks you so much for replying it really help me
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Problem-with-method-numRows-in-Sqlite3-tp71420p71439.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users
All;
I'm trying to use SQlite as a transfer medium between my PHP world and my
Python world.
in PHP i can read and write just fine. but when i try to read the database from
a python program i get the dreaded "file is encrypted or not a database"
message.
can any body help me?
Thanks
Paul Alag
Many who solved this, thank you all.
Staffan
On Tue, Sep 24, 2013 at 7:11 PM, Yuriy Kaminskiy wrote:
> Staffan Tylen wrote:
> > On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin
> wrote:
> >
> >> On 24 Sep 2013, at 5:35pm, Staffan Tylen
> wrote:
> >>
> >>> sqlite> .tables
> >>> City
Staffan Tylen wrote:
> On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin wrote:
>
>> On 24 Sep 2013, at 5:35pm, Staffan Tylen wrote:
>>
>>> sqlite> .tables
>>> CityCountry Languages
>>> Country Country Official Languages
>>> Country CapitalsCou
On 09/24/2013 11:53 PM, Staffan Tylen wrote:
Well, it's not my database I'm looking at. What puzzles me is that Country
Languages works but Country Official Languages doesn't, so could there be a
parsing problem?
It's because the AS keyword is optional. These two are equivalent:
SELECT coun
On Tue, Sep 24, 2013 at 12:53 PM, Staffan Tylen wrote:
> Well, it's not my database I'm looking at. What puzzles me is that Country
> Languages works but Country Official Languages doesn't, so could there be a
> parsing problem?
>
>
I think I see what is happening..
when you have a space in the f
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote:
> SQLite version 3.7.16.2 2013-04-12 11:52:43
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> .tables
> CityCountry Languages
> Country Country Official Langua
Well, it's not my database I'm looking at. What puzzles me is that Country
Languages works but Country Official Languages doesn't, so could there be a
parsing problem?
I agree, the names should be quoted ...
On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin wrote:
>
> On 24 Sep 2013, at 5:35pm, St
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote:
> SQLite version 3.7.16.2 2013-04-12 11:52:43
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> .tables
> CityCountry Languages
> Country Country Official Langua
On 24 Sep 2013, at 5:35pm, Staffan Tylen wrote:
> sqlite> .tables
> CityCountry Languages
> Country Country Official Languages
> Country CapitalsCountryLanguage
Either don't use spaces in your token names (table names, column names, index
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote:
> SQLite version 3.7.16.2 2013-04-12 11:52:43
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> .tables
> CityCountry Languages
> Country Country Official Langua
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
CityCountry Languages
Country Country Official Languages
Country CapitalsCountryLanguage
sqlite> select count
45 matches
Mail list logo