Re: [sqlite] GUI for SQLite

2013-06-26 Thread Rose, John B
We have tried Firefox SQLite Manager, SQLite DB Browser and Navicat. They all seem fine and Navicat seems good as a paid option with more features than the other two. From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of

Re: [sqlite] GUI for SQLite

2013-06-26 Thread Rose, John B
fyi http://www.barefeetware.com/sqlite/compare/?ml/ http://devtest.ws.utk.edu/tutorials/sqlite/gui/ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Rob Richardson [rdrichard...@rad-con.com] Sent: Wednesday, June 26,

[sqlite] SQLite, HTML5 and Javascript

2012-10-29 Thread Rose, John B
1) We are looking for simple examples, with source code, of a UI using HTML5 to query and add data to an SQLite database 2) We are also looking for examples using Javascript to query an existing SQLite database. And maybe add data to an existing database. We do not care of the database is on

[sqlite] Mod_sqlite install on Apache 2.2.15 using yum question

2012-07-12 Thread Rose, John B
On a Red Hat server I am a bit new to yum but have successfully installed a few things. Including mod_perl, mod_python I have tried to unsuccessfully install mod_sqlite yum install mod_sqlite Loaded plugins: product-id, rhnplugin, subscription-manager Updating certificate-based

Re: [sqlite] Mod_sqlite install on Apache 2.2.15 using yum question

2012-07-12 Thread Rose, John B
Could you elaborate on this ... On 7/12/12 4:35 PM, Simon Slavin slav...@bigfraud.org wrote: If you are running Apache 2.x, the ability to access sqlite files is included in the default distribution, so unless you go out of your way to download the bare-bones modless version you won't need

Re: [sqlite] Mod_sqlite install on Apache 2.2.15 using yum question

2012-07-12 Thread Rose, John B
We are setting up what is to be a central virtual host server. So at this point no specific application. Apache 2.2.15 is the installation. I am not seeing mod_sqlite in the module listing. On 7/12/12 5:32 PM, Simon Slavin slav...@bigfraud.org wrote: On 12 Jul 2012, at 10:26pm, Rose, John B

[sqlite] GUI for SQLite

2012-03-07 Thread Rose, John B
We are new to SQLite and have experimented with a few GUIs, Firefox plugin, SQLite DB Browser, and Navicat. Is there a single GUI that is considered the best, with the most features? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Rose, John B
Hello We are new to SQLite and are working on an intro tutorial for people here. We would like to create an example where we create an SQLite database on our desktop and access it there via command line, GUI like Navicon, and a web based application, then upload the .db file to our Android

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Rose, John B
of example you want? SQLite's database format is the same for any platform. So just copy the file (when it's not open by any application) and you are done. Pavel On Fri, Mar 2, 2012 at 11:34 AM, Rose, John B jbr...@utk.edu wrote: Hello We are new to SQLite and are working on an intro

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Rose, John B
on their desktop. Thanks On 3/2/12 12:52 PM, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [I reordered your message in my response] On 02/03/12 08:59, Rose, John B wrote: I had assumed we just moved the .db file back and forth between our desktop

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Rose, John B
, Rose, John B jbr...@utk.edu wrote: Thanks for the very thorough reply. Android is a red herring in this and your approach is not a good one. How would you do this using two different regular computers? How would you deal with changes being made on both machines at the same time? How

[sqlite] Yum install of PHP not including sqlite3

2012-03-01 Thread Rose, John B
Hello We are running Red Hat 6.2 with PHP 5.3.3 installed via yum Among other things in the ./configure section I see '--without-sqlite3' However, via phpinfo() we see a section ... sqlite3 SQLite3 supportenabled SQLite3 module version0.7-dev SQLite Library3.6.20 Directive