[sqlite] Adobe AIR and Sqlite - Adobe could have statically included the FTS module?

Adobe AIR did not include the FTS module. I read in this thread (https://store1.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=75=697=1417051=y) that they disabled loadable modules. However, it would have been easy for them to statically include the FTS (and maybe other modules) in

[sqlite] Pending Queue?

In Section 7.0, Transaction Control At The SQL Level, at http://www.sqlite.org/lockingv3.html, it says: "If the SQL COMMIT command turns autocommit on and the autocommit logic then tries to commit change but fails because some other process is holding a SHARED lock, then autocommit is turned

[sqlite] Can more than one user connect to an in-memory database?

I don't see how. Any clues? Thanks! Scott ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to select Strict Affinity or No Affinity modes?

I take it that there's no way to work around this currently? Scott Scott Chapman wrote: > D. Richard Hipp wrote: > >> On Feb 2, 2008, at 7:57 PM, Scott Chapman wrote: >> >> >> >>> I've looked high and low and can't find a way t

Re: [sqlite] How to select Strict Affinity or No Affinity modes?

D. Richard Hipp wrote: > On Feb 2, 2008, at 7:57 PM, Scott Chapman wrote: > > >> I've looked high and low and can't find a way to invoke the other 2 >> affinity modes. Are they available? I'm on 3.5.4. >> > The concept of "strict" affinity mode w

[sqlite] How to select Strict Affinity or No Affinity modes?

I've looked high and low and can't find a way to invoke the other 2 affinity modes. Are they available? I'm on 3.5.4. Any pointers would be greatly appreciated. Thanks! Scott ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite with visual basic?

Thanks Steve. Anyone have guidance on which of these will work (well) with the latest version of VB and SQLite? Steve O'Hara wrote: Check out the WIKI, there's a myriad of possibilities. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of Scott

[sqlite] sqlite with visual basic?

I am having a look at Visual Basic Express 2005 Beta. I haven't programmed VB since version 3.0 on Windows 3.1 many years ago. I didn't do any database with it then. All of my programming these days is in Python with Postgresql or SQLite. Has anyone gotten VB and SQLite working together?

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

Eli, I'd highly recommend Python. I've used Perl, PHP and Python. Python is hands-down the winner. After getting ahold of the elegance of Python, PHP feels like a hack job. Perl is "executable line noise". Python is very mature and very nice. It has a far cleaner implementation of just

Re: [sqlite] 3.1.3 on Windows with python apsw: malformed database schema - near "AUTOINCREMENT": syntax error

C:\Documents and Settings\Scott Chapman\My Documents\development\misc\sqlite> C:\Documents and Settings\Scott Chapman\My Documents\development\misc\sqlite> C:\Documents and Settings\Scott Chapman\My Documents\development\misc\sqlite> C:\Documents and Settings\Scott Chapman\My Docum

Re: [sqlite] 3.1.3 on Windows with python apsw: malformed database schema - near "AUTOINCREMENT": syntax error

I'm not able to duplicate this on Linux with fresh compiles of everything. That leads me to believe the binary I downloaded for Windows is not built on 3.1.3 after all. Scott On Saturday 05 March 2005 06:01 pm, Scott Chapman wrote: > Windows XP Pro, Python 2.3.4, sqlite 3.1.3 > I'm g

Re: [sqlite] Does "PRAGMA full_column_names = 1" work with APSW and 3.1.3?

I'm able to duplicate this on Linux with fresh compiles of Python, apsw, sqlite. Scott On Saturday 05 March 2005 06:11 pm, Scott Chapman wrote: > I'm using APSW 3.0.8-r3 on Python Windows XP Pro with Python 2.3.4. > > Minimal test-case code: > > import apsw > db = apsw.Co

[sqlite] Re: make error with 3.1.3 on Suse 9.1

This was caused by me having two different readline.h files on my server. Please disregard! Thanks! Scott On Saturday 05 March 2005 05:55 pm, Scott Chapman wrote: > When I run make, I get this: > > ./libtool --mode=link gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src > -DN

[sqlite] Does "PRAGMA full_column_names = 1" work with APSW and 3.1.3?

I'm using APSW 3.0.8-r3 on Python Windows XP Pro with Python 2.3.4. Minimal test-case code: import apsw db = apsw.Connection('test.db3') cursor=db.cursor() cursor.execute('PRAGMA empty_result_callbacks = 1') sql="select * from testnn" # testnn is empty cursor.execute (sql) description =

[sqlite] 3.1.3 on Windows with python apsw: malformed database schema - near "AUTOINCREMENT": syntax error

qlite> create table test (id INTEGER PRIMARY KEY AUTOINCREMENT,name text); sqlite> .quit C:\Documents and Settings\Scott Chapman\My Documents\development\misc\sqlite>python apsw_pragma.py test1.db3 Traceback (most recent call last): File "apsw_pragma.py", line 37, in ? dosql(s

[sqlite] make error with 3.1.3 on Suse 9.1

When I run make, I get this: ./libtool --mode=link gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src -DNDEBUG -I/usr/include -DSQLITE_OMIT_CURSOR -DHAVE_READLINE=1 -I/usr/include/readline \ -o sqlite3 ./src/shell.c libsqlite3.la -lreadline -lreadline gcc -g -O2 -DOS_UNIX=1

Re: [sqlite] SQLite Advocacy

> Let's be careful out there. I have found rookies tend to blindly > evangelically tout their first learned tool as the one and only path of > light to truth and world peace. Fred, I think you just hit a good part of the reason that PHP and MySQL have mind-share out there when they are lousy

Re: [sqlite] SQLite Advocacy

On Wednesday 02 February 2005 7:52 am, John Dean wrote: > At 14:57 02/02/2005, Paul Malcher wrote: > >Scott Chapman wrote: > >>Regarding the issue of SQL Server vs. SQLite: > >>If the choice were between SQL Server and SQLite, and the need came up > >>t

Re: [sqlite] SQLite Advocacy

On Monday 31 January 2005 7:58 am, Downey, Shawn wrote: > "If anyone can see the source code, then won't we be venerable to > hackers?" Here is a very useful paragraph that should be given to anyone who thinks in the above terms: "A common question in the minds of some CEOs and CIOs is, 'If it

[sqlite] Can you get a description of a table when the sql results are empty?

I made a little python code below that fetches a sqlite3 table description (using apsw) but it won't work when the table is empty. ÂI made it tell me the table is empty in this case. Â Is there a way to get the columns in a table without having to parse the SQL that created the table, when the

[sqlite] sqlite3 accepts create table blah (id integer primarykey) without errors.

It should be "primary key" not "primarykey". It doesn't give you any errors and it doesn't give you a primary key. Scott

[sqlite] How do I create a log of SQLite SQL statements, etc?

I'd like to be able to see all the sql traffic going to/from my sqlite database. Is there a way to run things in a debug mode so that it outputs the sql traffic to a log file, similar to how you'd do it in Postgres? Scott -