Re: [sqlite] Web application with SQLite

[Tim Johnson]

* Eduardo  [131231 07:11]:
> 
> You can check mongoose webserver. It uses LUA for scripting web pages
> (similar to PHP but with LUA) and Sqlite for db access from LUA.

  I found what I believe is the mongoose page at
  https://code.google.com/p/mongoose/
  Very interesting! 

  BTW: See the following text at that page :
  "Lua server pages (PHP-like functionality using Lua) with SQLite3,
  see page.lp"
  Where "page.lp" is a link to
  https://github.com/cesanta/mongoose/blob/master/test/page.lp
  That URL generates a 404 error.

> You can use scgi lib from http://www.xamuel.com/scgilib/ and use Sqlite
> if you are developing a webservice.
  
   Thank you for turning me on to this.

-- 
Tim 
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Web application with SQLite

[Tim Johnson]

  Understood. Thanks
* Mohd Radzi Ibrahim <imra...@gmail.com> [131229 13:54]:
> fossil is a webserver by itself with sqlite as the database engine. AFAIK,
> there's no scripting language used on the server. All written in C.
> 
> 
> 
> On Mon, Dec 30, 2013 at 1:02 AM, Tim Johnson <t...@akwebsoft.com> wrote:
> 
> > * Stephan Beal <sgb...@googlemail.com> [131229 07:48]:
> > > On Sun, Dec 29, 2013 at 5:35 PM, Tim Johnson <t...@akwebsoft.com> wrote:
> > >
> > > >   :) And if I request http://www.sqlite.org/src/timeline/index.php
> > > >   I get the same page, so Igor, Mr. Hipp uses PHP as the 'querying'
> > > >   code, or so I presume.
> > > >
> > >
> > > LOL! If you try /timeline/foo/bar/baz you'll get the same thing. That
> > page
> > > is written in C. The /timeline part of the request is intercepted by C
> > code
> > > and the rest is ignored.
> > >
> > > http://fossil-scm.org/index.html/timeline/foo/bar/baz
> >   I stand (embarrassingly) corrected 
> >
> >   FYI: I started out doing web programming in 1995 using C, but
> >   transitioned to scripting languages around 2001. I didn't know
> >   anyone was still doing web application in C!
> >
> >   It stands to reason in terms of performance, for sure.
> >
> >   Thanks
> > --
> > Tim
> > tim at tee jay forty nine dot com or akwebsoft dot com
> > http://www.akwebsoft.com, http://www.tj49.com
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

-- 
Tim 
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Web application with SQLite

[Tim Johnson]

* Stephan Beal <sgb...@googlemail.com> [131229 07:48]:
> On Sun, Dec 29, 2013 at 5:35 PM, Tim Johnson <t...@akwebsoft.com> wrote:
> 
> >   :) And if I request http://www.sqlite.org/src/timeline/index.php
> >   I get the same page, so Igor, Mr. Hipp uses PHP as the 'querying'
> >   code, or so I presume.
> >
> 
> LOL! If you try /timeline/foo/bar/baz you'll get the same thing. That page
> is written in C. The /timeline part of the request is intercepted by C code
> and the rest is ignored.
> 
> http://fossil-scm.org/index.html/timeline/foo/bar/baz
  I stand (embarrassingly) corrected 

  FYI: I started out doing web programming in 1995 using C, but
  transitioned to scripting languages around 2001. I didn't know
  anyone was still doing web application in C! 

  It stands to reason in terms of performance, for sure.

  Thanks
-- 
Tim 
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Web application with SQLite

[Tim Johnson]

* Igor Korot  [131227 12:16]:
> Hi ALL,
> Does people use SQLite for Web development? Or web apps are written
> only with mySQL/MS SQL?

  Drupal can use sqlite as its default database. I have used both
  sqlite and MySQL with drupal. SQLite is offered as on option at
  the drupal install. 
  
  PHP is the core PL for drupal. I have used PHP very little, but I
  note that the PHP/drupal PDO database access features the same
  syntax for queries from any of sqlite, mysql or postresql.

  That's a good thing, in my book. And fyi - if you aren't familiar
  with drupal - see drupal.org

  Most certainly I could use sqlite with my own python framework,
  but have chosen to work with MySQL out of sheer momentum, I grok
  that you are probably getting some pretty good pros and cons about
  performance.

  HTH
-- 
Tim 
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] General setup on Mac OSX 10.7

[Tim Johnson]

* Simon Slavin <slav...@bigfraud.org> [121216 15:07]:
> 
> On 16 Dec 2012, at 11:10pm, Tim Johnson <t...@akwebsoft.com> wrote:
> 
> > I've recently set up drupal on my workstation which is hosting Mac
> > OSX 10.7. I would welcome
> > 1)Recommendations on what I should install to manage sqlite
> > 2)How they should be installed
> >  NOTE: macports works well for me but alternative suggestions are
> >  welcomed.
> > The macports list re sqlite can be seen here :
> > http://www.macports.org/ports.php?by=name=sqlite
 
> While as a Linux-user you expect to see DarwinPorts, MacPorts,
> Fink, Homebrew and/or other package managers, it might help to
> know that Mac-users don't think in those terms.
  :) Well this mac user users a generous portion of macports.
  postfix, fetchmail, mutt, procmail, mc and vim to name some..
  But I got macvim as a stand-alone install for the gui version of
  vim. I am actually pretty new to mac going on a year now.
  (12 years on linux)

> There is almost no library-sharing on Macs.  The two big
> collections of shared libraries are the ones which Apple supplies
> with OS X and the ones which Microsoft supplies with its Office
> suite.  Normal professional and hobby programmers will use Apple's
> libraries intensively, and never use Microsoft's libraries unless
> they're specifically interfacing with Microsoft's stuff.  A
> mundane Mac user hit with "This app requires jcrak and visdis."
> wouldn't know what to do about it.
  Yeah, I've got that, after years on linux  
<...> 
> SQLite on a Mac has standard Mac behaviour here.  As a programmer
> you aren't expected to use a library.  You can download up-to-date
> source files for SQLite 'Amalgamated' version from the SQLite
> server
 
> <http://www.sqlite.org/download.html>
  Oh good! Thank you. 
<...>
> But actually SQLite is used so much on Macs that Apple included a
> copy of the shell tool with the OS.  You'll find a copy of the
> sqlite3 shell tool as
 
> /usr/bin/sqlite3
  Duh. I didn't even think to look and thar she blows ... 

> Apple's Developer Tools installations include copies of the .h and
> .c files (many many copies of the .h file) but I recommend that
> you just grab new ones from the SQLite server whenever you start a
> new project.  That way you get all the recent features and
> bugfixes.
  Good tip.
  And I have python with sqlite3 as a module in the standard
  distro

  Thanks again. I really appreciate the tips.
  Your entire email is going into my knowledgebase.
  I owe you a beer.
-- 
Tim 
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] General setup on Mac OSX 10.7

[Tim Johnson]

Greetings :

I've recently set up drupal on my workstation which is hosting Mac
OSX 10.7. I would welcome
1)Recommendations on what I should install to manage sqlite
2)How they should be installed
  NOTE: macports works well for me but alternative suggestions are
  welcomed.
The macports list re sqlite can be seen here :
http://www.macports.org/ports.php?by=name=sqlite

Thanks
-- 
Tim 
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installing _sqlite3.so for Python 2.7 on ubuntu

[Tim Johnson]

* Tim Johnson <t...@johnsons-web.com> [110327 16:59]:
> I have python 2.6 on my ubuntu 10.04 workstation.
> the sqlite module imports without a problem.
> 
> I have installed python 2.7 by compiling it.
> There is no /usr/local/lib/python2.7/lib-dynload/_sqlite3.so,
> so am getting an import error.
> What do I need to do?
 
  OK. I solved it. (For ubuntu) I had to install libsqlite3-dev.
  Not sure what the solution would be on other distros.
  tj

> FYI: Programmer 24 years, linux 11 years, python 8 years.
> Never have used sqlite.
> 
> TIA
> -- 
> Tim 
> tim at johnsons-web dot com or akwebsoft dot com
> http://www.akwebsoft.com
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

-- 
Tim 
tim at johnsons-web dot com or akwebsoft dot com
http://www.akwebsoft.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Installing _sqlite3.so for Python 2.7 on ubuntu

[Tim Johnson]

I have python 2.6 on my ubuntu 10.04 workstation.
the sqlite module imports without a problem.

I have installed python 2.7 by compiling it.
There is no /usr/local/lib/python2.7/lib-dynload/_sqlite3.so,
so am getting an import error.
What do I need to do?

FYI: Programmer 24 years, linux 11 years, python 8 years.
Never have used sqlite.

TIA
-- 
Tim 
tim at johnsons-web dot com or akwebsoft dot com
http://www.akwebsoft.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users