Re: [sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

2011-11-15 Thread BertD
Simon Slavin-3 wrote: > > > On 15 Nov 2011, at 11:09pm, BertD wrote: > >> When i'm working with the db in Flex, i'm able to Query the db I want, >> but >> am unable to "UPDATE" nor "INSERT" ? > > My guess is that you're opening a database file with the same name, but in > a different director

Re: [sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

2011-11-15 Thread BertD
Richard Hipp-3 wrote: > > On Tue, Nov 15, 2011 at 6:09 PM, BertD > wrote: > > Sounds like you do not have write permission on the directory (folder) > which is holding the database file. You need this so that SQLite can > create the rollback journal needed for your write transaction. > > T

Re: [sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

2011-11-15 Thread Richard Hipp
On Tue, Nov 15, 2011 at 6:09 PM, BertD wrote: > > Hello all, > > Question : > > I'm using Adobe Flex 4.5 to make an Air app that uses a local SQLite > database. > I've created this database using SQLite Database Browser: > http://old.nabble.com/file/p32851221/SDB.png > > When i'm working with the

Re: [sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

2011-11-15 Thread Simon Slavin
On 15 Nov 2011, at 11:09pm, BertD wrote: > When i'm working with the db in Flex, i'm able to Query the db I want, but > am unable to "UPDATE" nor "INSERT" ? My guess is that you're opening a database file with the same name, but in a different directory. Or that you do have the database file p

Re: [sqlite] How about a proper forum rather than an e-mail list

2011-11-15 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 15/11/11 12:35, Nico Williams wrote: > my answer: a plethora of interfaces to the same data (posts/threads). That is exactly what Gmane already provides. > I'd like to see: > > - RSS/Atom feeds http://rss.gmane.org/gmane.comp.db.sqlite.general

[sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

2011-11-15 Thread BertD
Hello all, Question : I'm using Adobe Flex 4.5 to make an Air app that uses a local SQLite database. I've created this database using SQLite Database Browser: http://old.nabble.com/file/p32851221/SDB.png When i'm working with the db in Flex, i'm able to Query the db I want, but am unable to "

Re: [sqlite] How about a proper forum rather than an e-mail list

2011-11-15 Thread Petite Abeille
On Nov 16, 2011, at 12:02 AM, Nico Williams wrote: > Why are the mail archives for sqlite-users not available for download? They are: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/ > As for loading them into a SQLite3 DB... I once wrote a schema for > this, and it's straightforw

Re: [sqlite] How about a proper forum rather than an e-mail list

2011-11-15 Thread J.M. Royalty
On 11/15/2011 5:02 PM, Nico Williams wrote: On Tue, Nov 15, 2011 at 3:08 PM, Alek Paunov wrote: Me too. As simple first step - let's load the mail archives to downloadable sqlite DB. Why are the mail archives for sqlite-users not available for download? They are avail here - (you have to log

Re: [sqlite] How about a proper forum rather than an e-mail list

2011-11-15 Thread Nico Williams
On Tue, Nov 15, 2011 at 3:08 PM, Alek Paunov wrote: > Me too. As simple first step - let's load the mail archives to downloadable > sqlite DB. Why are the mail archives for sqlite-users not available for download? As for loading them into a SQLite3 DB... I once wrote a schema for this, and it's

Re: [sqlite] How about a proper forum rather than an e-mail list

2011-11-15 Thread Alek Paunov
On 15.11.2011 22:35, Nico Williams wrote: my answer: a plethora of interfaces to the same data (posts/threads). +1 I'd like to see: - RSS/Atom feeds - web UIs ("web forum" UIs) - stable HTTP APIs - mobile apps specifically for fora (probably based on HTTP APIs) - e-mail interface (

Re: [sqlite] How about a proper forum rather than an e-mail list

2011-11-15 Thread Nico Williams
You're not yet convincing me (though that probably doesn't matter); repeating my arguments would be obnoxious (or worse: boring!), so I won't. Let's try a different approach: what's the ideal here? Here's my answer: a plethora of interfaces to the same data (posts/threads). I'd like to see: -

Re: [sqlite] [sqlite-dev] sqlite3_enable_column_metada

2011-11-15 Thread Pavel Ivanov
This kind of questions should be asked on sqlite-users mailing list. Pavel On Tue, Nov 15, 2011 at 3:19 AM, Ilber Ibrahimi wrote: > > Hi u all, > > I’m new to sqlite and i want to know how can i build sqlite with the > parameter SQLITE_ENABLE_COLUMN_METADATA enabled. I’m working with Mac OS X

Re: [sqlite] An interchangeable autoincremental field

2011-11-15 Thread Luciano de Souza
Well, it's not so unsuitable. For luck, a simple replacement could solve the problem. I asked only because I thought there was a pattern. If not, let's go to the replacements! Em 15/11/2011 10:15, Simon Slavin escreveu: On 15 Nov 2011, at 11:27am, Luciano de Souza wrote: With the clause "int

Re: [sqlite] An interchangeable autoincremental field

2011-11-15 Thread Simon Slavin
On 15 Nov 2011, at 11:27am, Luciano de Souza wrote: > With the clause "integer primary key", we can create an autoincrementable > field in Sqlite. Other databases uses auto_increment, serial and something > else. > > If I am not wrong, Sqlite uses also auto_int. But, if I would build a > dat

[sqlite] An interchangeable autoincremental field

2011-11-15 Thread Luciano de Souza
Hi listers, With the clause "integer primary key", we can create an autoincrementable field in Sqlite. Other databases uses auto_increment, serial and something else. If I am not wrong, Sqlite uses also auto_int. But, if I would build a database readable by other databases, what is the best

[sqlite] 3.7.3 -> 3.7.8 changes

2011-11-15 Thread Soundfaction
I just upgraded SQLITE to 3.7.8 from 3.7.3. I have found queries I was previously doing have become extremely slow, and wondered if its a problem with my understanding of SQL or a bug in the QUERY PLAN in newer versions: I wouldn't expect query times to change from 100ms to several minutes due t