[sqlite] select null values in python

? -- Fabio Spadaro Try Sqlite Root a GUI Admin Tools for manage Sqlite Database: www.sqliteroot.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI for SQLite

/ deleting / modifying fields in any position with the possibility of keeping the data (via form keep data yes or no) -- Fabio Spadaro Try Sqlite Root a GUI Admin Tools for manage Sqlite Database: www.sqliteroot.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] What do people think of SQLite Root?

: sqlite-users-bounces-**CzDROfG0BjIdnm+yROfE0A@public.**gmane.orgsqlite-users-bounces-czdrofg0bjidnm%2byrof...@public.gmane.org] On Behalf Of Fabio Spadaro Sent: Monday, March 05, 2012 3:51 AM To: General Discussion of SQLite Database Subject: [sqlite] Sqlite Root also available for Linux

Re: [sqlite] What do people think of SQLite Root?

Hi. Il giorno 06 marzo 2012 17:31, Kit kit.sa...@gmail.com ha scritto: Announcement of the release Sqlite Root http://www.sqliteroot.com/ now available for Linux. Any feedback is appreciated. Fabio Spadaro Two big problems: - license - size This software is unusable for me

[sqlite] Sqlite Root also available for Linux

Announcement of the release Sqlite Root http://www.sqliteroot.com/ now available for Linux. Any feedback is appreciated. -- Fabio Spadaro Try Sqlite Root a GUI Admin Tools for manage Sqlite Database: www.sqliteroot.com ___ sqlite-users mailing list

Re: [sqlite] What do people think of SQLite Root?

keys. -- Fabio Spadaro Try Sqlite Root a GUI Admin Tools for manage Sqlite Database: www.sqliteroot.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ANNOUNCE: Sqlite Root 1.9.7.5 freeware for MS Windows

trigger,index,view Mailing list here https://groups.google.com/group/sqliteroot?hl=en Any feedbak is welcome! Fabio Spadaro Try Sqlite Root a GUI Admin Tools for manage Sqlite Database: www.sqliteroot.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012/1/31 John Elrick john.elr...@fenestra.com On Tue, Jan 31, 2012 at 6:01 AM, Fabio Spadaro fabiolinos...@gmail.com wrote: Hi 2012/1/30 Bart Smissaert bart.smissa...@gmail.com How do you make it open database files that have an extension other than .slt? RBS

Re: [sqlite] Is there any API for counting number of rows in a particular table.

*.* in the filename of the FileDialog. Thanks. -- Fabio Spadaro Try Sqlite Root a GUI Admin Tools for manage Sqlite Database: www.sqliteroot.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] Is there any API for counting number of rows in a particular table.

Hi 2012/1/30 bhaskarReddy uni...@gmail.com Its working with only table name. Regards, Bhaskar. You could use a GUI to facilitate these requests, and your this regard we propose to test my application it is freeware: www.sqliteroot.com http://www.sqliteroot.com -- Fabio Spadaro Try

Re: [sqlite] ANNOUNCE: Sqlite Root Gui Admin Tool for manage Sqlite Database

Announcing-- Sqlite Root version 1.9.73 has been released and is now available for download at http://www.sqliteroot.com http://wxpython.org/download.php. For any request please contact sqliter...@gmail.com Fabio Spadaro ___ sqlite-users

Re: [sqlite] sqlite3 python foreign key

returned. Issue PRAGMA foreign_keys = ON. Issue PRAGMA foreign_keys and look at the value returned. all [ ] -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] sqlite3 python foreign key

Hi 2011/9/15 Simon Slavin slav...@bigfraud.org On 15 Sep 2011, at 9:12am, Fabio Spadaro wrote: So you get no error from the INSERT command, and you can also find the new row using SELECT ? No error for select If the SELECT command does not show the row then the INSERT did not work

Re: [sqlite] sqlite3 python foreign key

Hi. 2011/9/15 Simon Slavin slav...@bigfraud.org On 15 Sep 2011, at 4:36pm, Fabio Spadaro wrote: i just installed python 2.7.2 and the value returned by PRAGMA foreign_keys is [(0,)]; Later I will try with the tables. Can you tell whether your python installation process is installing

[sqlite] sqlite3 python foreign key

:79063, Apr 16 2010, 13:09:56) [GCC 4.4.3] on linux2 -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] alter table add column

Alter table add column command drop data from table. Can you keep the data or should I store the data before the alter and then put them in the table? -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] alter table add column

Hi 2011/5/31 Stephan Beal sgb...@googlemail.com On Tue, May 31, 2011 at 5:11 PM, Fabio Spadaro fabiolinos...@gmail.com wrote: Alter table add column command drop data from table. Can you keep the data or should I store the data before the alter and then put them in the table

Re: [sqlite] date field with default current date

is a text representation of the current UTC date and/or time. It won't be your local time. Pavel On Fri, Apr 22, 2011 at 5:46 AM, Fabio Spadaro fabiolinos...@gmail.com wrote: Hi. 2011/4/22 Fabio Spadaro fabiolinos...@gmail.com Hi 2011/4/22 Fabio Spadaro fabiolinos...@gmail.com

Re: [sqlite] date field with default current date

you get? Pavel On Thu, Apr 21, 2011 at 1:43 PM, Fabio Spadaro fabiolinos...@gmail.com wrote: Hi. 2011/4/21 Pavel Ivanov paiva...@gmail.com Does not work on python with sqlite3 module What does SELECT sqlite_version() gives you in python with sqlite3 module? Pavel

Re: [sqlite] date field with default current date

Hi 2011/4/22 Fabio Spadaro fabiolinos...@gmail.com Hi. 2011/4/22 Pavel Ivanov paiva...@gmail.com What does SELECT sqlite_version() gives you in python with sqlite3 module? [(u'3.5.9',)] Well, CURRENT_DATE should work then, it was added in 3.1.0. Could you show us an exact statement

Re: [sqlite] date field with default current date

Hi. 2011/4/22 Fabio Spadaro fabiolinos...@gmail.com Hi 2011/4/22 Fabio Spadaro fabiolinos...@gmail.com Hi. 2011/4/22 Pavel Ivanov paiva...@gmail.com What does SELECT sqlite_version() gives you in python with sqlite3 module? [(u'3.5.9',)] Well, CURRENT_DATE should work

[sqlite] date field with default current date

Hi. I'm working with python and sqlite3 and i ask how to create a table with a date field wih defaults current date. Thanks. -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] date field with default current date

Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Fabio Spadaro [fabiolinos...@gmail.com] Sent: Thursday, April 21, 2011 5:37 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] date

Re: [sqlite] date field with default current date

2011/4/21 Mihai Militaru mihai.milit...@xmpp.ro On Thu, 21 Apr 2011 15:17:00 +0200 Fabio Spadaro fabiolinos...@gmail.com wrote: Does not work on python with sqlite3 module Try using the date and time functions, 'date' or 'datetime' in your case: INSERT INTO table(..., date) VALUES

Re: [sqlite] date field with default current date

Hi. 2011/4/21 Pavel Ivanov paiva...@gmail.com Does not work on python with sqlite3 module What does SELECT sqlite_version() gives you in python with sqlite3 module? Pavel On Thu, Apr 21, 2011 at 9:17 AM, Fabio Spadaro fabiolinos...@gmail.com wrote: Hi. 2011/4/21 Black, Michael

[sqlite] sqlite3 backup

Hi all. I use Python's sqlite3. it is possible to backup a database without use the copy command file? -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

[sqlite] issue on blob

Hi all. Can you determine in the blob's data what is buffered file type and what was its original length? Obviously the solution to store the blob on a files would be too easy and I do not like it. Workaround? -- Fabio Spadaro www.fabiospadaro.com

Re: [sqlite] issue on blob

HI, 2010/9/9 Igor Tandetnik itandet...@mvps.org Fabio Spadaro fabiolinos...@gmail.com wrote: Can you determine in the blob's data what is buffered file type and what was its original length? You retrieve the size of the BLOB field with sqlite3_column_bytes function, or with length

Re: [sqlite] is there any way for create a sqlite blob field with python?

Hi 2010/6/15 Roger Binns rog...@rogerbinns.com -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/15/2010 01:46 PM, Fabio Spadaro wrote: I am developing an interface to Python 's SQLite and would it be you can store files in the sqlite database. To do this obviously need to create

Re: [sqlite] is there any way for create a sqlite blob field with python?

Hi, 2010/6/16 Fabio Spadaro fabiolinos...@gmail.com Hi 2010/6/15 Roger Binns rog...@rogerbinns.com -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/15/2010 01:46 PM, Fabio Spadaro wrote: I am developing an interface to Python 's SQLite and would it be you can store files

Re: [sqlite] is there any way for create a sqlite blob field with python?

Hi, 2010/6/15 Roger Binns rog...@rogerbinns.com -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/15/2010 01:46 PM, Fabio Spadaro wrote: I am developing an interface to Python 's SQLite and would it be you can store files in the sqlite database. To do this obviously need to create

Re: [sqlite] is there any way for create a sqlite blob field with python?

Hi, 2010/6/16 Roger Binns rog...@rogerbinns.com -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/16/2010 04:14 AM, Fabio Spadaro wrote: But the next time I select a single line instead of two: fetchall [(read-write buffer ptr 0x02CC2A68, size 1311 at 0x02CC2A30

[sqlite] is there any way for create a sqlite blob field with python?

Hi all. I am developing an interface to Python 's SQLite and would it be you can store files in the sqlite database. To do this obviously need to create a blob field but how to store image files? -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users

[sqlite] data type from join multiple tables

I need to identify data types extracted from a join between multiple tables without using cross-checking table_info more pragmatic. Is there a faster way to do it? -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] data type from join multiple tables

hi, 2010/5/14 P Kishor punk.k...@gmail.com On Fri, May 14, 2010 at 9:01 AM, Fabio Spadaro fabiolinos...@gmail.com wrote: I need to identify data types extracted from a join between multiple tables without using cross-checking table_info more pragmatic. Could you clarify what you

Re: [sqlite] data type from join multiple tables

Hi, 2010/5/14 P Kishor punk.k...@gmail.com On Fri, May 14, 2010 at 9:49 AM, Fabio Spadaro fabiolinos...@gmail.com wrote: hi, 2010/5/14 P Kishor punk.k...@gmail.com On Fri, May 14, 2010 at 9:01 AM, Fabio Spadaro fabiolinos...@gmail.com wrote: I need to identify data types

Re: [sqlite] data type from join multiple tables

Hi, 2010/5/14 P Kishor punk.k...@gmail.com On Fri, May 14, 2010 at 10:11 AM, Fabio Spadaro fabiolinos...@gmail.com wrote: Hi, 2010/5/14 P Kishor punk.k...@gmail.com On Fri, May 14, 2010 at 9:49 AM, Fabio Spadaro fabiolinos...@gmail.com wrote: hi, 2010/5/14 P Kishor

[sqlite] store query

hi all. I'm building an wxPython' application in advanced cases may require a user to write a query and run it. I would also expect that the same query is saved in the database to be reused whenever you want. Someone gives me an indication? -- Fabio Spadaro www.fabiospadaro.com