On Mon, May 03, 2010 at 03:01:26PM +0400, Alexey Pechnikov wrote:
See http://wiki.tcl.tk/15722 Add SQLite into it - about few minuts of time.
2010/5/3 Gilles Ganault gilles.gana...@free.fr:
I don't know if it'd be easier to combine existing HTTP server +
SQLite
ditto
On Mon, 3 May 2010 08:57:04 -0400, Reid Thompson
reid.thomp...@ateb.com wrote:
http://code.google.com/p/mongoose/
Right, I got Lua and SQLite working as a CGI call. The alternative is
to use the Lua-based Xavante web server and include SQLite; I'll try
to get this working tomorrow. Thank you.
On Mon, 3 May 2010 00:39:37 +0400, Alexey Pechnikov
pechni...@mobigroup.ru wrote:
it's easy for TCL developers. You may build tclsqlite+tclhttpd+your
tcl scripts as starpack (single executable binary). For integrate
SQLite database into starpack use this extension:
On Sun, 2 May 2010 20:31:15 +0100, Simon Slavin
slav...@bigfraud.org wrote:
How are you seeing this ? You send your SQL queries via HTTP and it answers
by replying with XML ?
XML or TAB-separated text. Using regexes, it's easy to parse data,
unless someone knows of a better way.
Besides, if
On Mon, 3 May 2010 11:24:49 +0100, Simon Slavin
slav...@bigfraud.org wrote:
If you're going to mostly pass data for use with web applications then JSON is
possibly a more appropriate format
Thanks, I'll check it out.
The problem is not in coding it -- that's relatively easy. The problem is in
See http://wiki.tcl.tk/15722 Add SQLite into it - about few minuts of time.
2010/5/3 Gilles Ganault gilles.gana...@free.fr:
I don't know if it'd be easier to combine existing HTTP server +
SQLite
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
On Mon, 3 May 2010 15:01:26 +0400, Alexey Pechnikov
pechni...@mobigroup.ru wrote:
See http://wiki.tcl.tk/15722 Add SQLite into it - about few minuts of time.
Thanks. If no one is interested in launching a project that would
offer a single binary and maintain it, I'll try TCL-TK.
How do you authenticate to your http sqlite web server?
is it not a security issue then?
normally you would also need a server side language, so I would say apache
is the only way to go,
and also I don't understand why you need something specific to return JSON
object.
you can do it in 3 seconds
On Mon, 3 May 2010 14:41:10 +0200, Sylvain Pointeau
sylvain.point...@gmail.com wrote:
How do you authenticate to your http sqlite web server?
is it not a security issue then?
SQLite is meant for local use, so people interested in an SQLite
server would operate on a small LAN, protected from the
if you speak about MySQL or POSTGRESQL
then you mean database server, not a web server.
Do you want to have a server where to connect for making your SELECT, UPDATE
DELETE, CREATE?
or do you want a webserver to just do some SELECT? (and having a XML, JSON
or whatever)
Best regards,
Sylvain
On
On Mon, 3 May 2010 14:47:48 +0200, Sylvain Pointeau
sylvain.point...@gmail.com wrote:
if you speak about MySQL or POSTGRESQL
then you mean database server, not a web server.
Yes. Please read the thread, starting with my original post where I
explain the idea.
this is not clear for me.
On Mon, May 3, 2010 at 2:49 PM, Gilles Ganault gilles.gana...@free.frwrote:
On Mon, 3 May 2010 14:47:48 +0200, Sylvain Pointeau
sylvain.point...@gmail.com wrote:
if you speak about MySQL or POSTGRESQL
then you mean database server, not a web server.
Yes. Please
option 1: a database server using sqlite behind the scene:
- which language / protocole to use ?
- which is the security model? (forget .htaccess, this is for apache /
webserver)
option 2: web server using http
- only SELECT statements?
- returning JSON or whatever?
- which protocole to use then?
Sylvain Pointeau schrieb:
option 1: a database server using sqlite behind the scene:
- which language / protocole to use ?
- which is the security model? (forget .htaccess, this is for apache /
webserver)
option 2: web server using http
- only SELECT statements?
- returning JSON or
On Sun, 02 May 2010 21:26:27 +0200, Gilles Ganault
gilles.gana...@free.fr wrote:
It's probably quite an easy thing to do for someone well versed in C,
but I haven't seen a project that would combine a web server and
SQLite into a single EXE.
Here's a diagram:
I would probably take mysql or postgresql, to be able to use the prepared
statements and other facilities.
I don't see any point to implement this kind of system.
or same api as sqlite but the open is taking an url instead,
but you have to re-write the api of sqlite.
In this case, I can see the
On Mon, 03 May 2010 15:22:27 +0200, Michael Schlenker
m...@contact.de wrote:
You could take the Tcl WUB webserver, which already implements a SQLQ
domain from an sqlite DB and use that. Easy to wrap in single file too.
See http://code.google.com/p/wub/source/browse/trunk/Domains/SqlQ.tcl
Thanks
On Mon, May 3, 2010 at 6:24 AM, Simon Slavin slav...@bigfraud.org wrote:
The problem is not in coding it -- that's relatively easy. The problem is
in who would use it. I think that would be mostly people who already use
PHP to write a backend data server. The advantage of this is that it
As example, on my laptop AOL Web Server+SQLite database + TCL scripts
can perform more than 1000 HTTP request per second. But AOLServer is a
solution for big projects. I am using AOLServer for projects with a
few hundreds and more of concurrent user sessions. And for many
projects SQLite is more
Hello,
It's probably quite an easy thing to do for someone well versed in C,
but I haven't seen a project that would combine a web server and
SQLite into a single EXE.
Besides ease of deployment, this would offer a cross-platform solution
that wouldn't require developing a specific client-side
On 2 May 2010, at 8:26pm, Gilles Ganault wrote:
It's probably quite an easy thing to do for someone well versed in C,
but I haven't seen a project that would combine a web server and
SQLite into a single EXE.
Besides ease of deployment, this would offer a cross-platform solution
that
hi,
i did this some years ago:
1) sqlite
2) spidermonkey
3) my own http server
if you are interested, i have to search my old code...
bye, gg
Gilles Ganault gilles.gana...@free.fr hat am 2. Mai 2010 um 21:26 geschrieben:
Hello,
It's probably quite an easy thing to do for someone well
it's easy for TCL developers. You may build tclsqlite+tclhttpd+your
tcl scripts as starpack (single executable binary). For integrate
SQLite database into starpack use this extension:
http://www.siftsoft.com/tclsqlitevfs.html
This is work fine on linux/windows and some other platforms.
--
Best
On Sun, 02 May 2010 21:26:27 +0200, Gilles Ganault
gilles.gana...@free.fr wrote:
Hello,
It's probably quite an easy thing to do for someone well versed in C,
but I haven't seen a project that would combine a web server and
SQLite into a single EXE.
It may not be what you mean, but you should
I want to see SQLite integrated into the R statistical package. R Project
http://www.gardenersown.co.uk/Education/Lectures/R/regression.htm#multiple_regression
for example.
R statistical is very and becoming more popular, has great plotting,
and wrestles data in frames that look awfully like sql
On 3 May 2010, at 1:38am, Matt Young wrote:
I want to see SQLite integrated into the R statistical package.
You have our permission. Go ahead.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
SQLite and R are already integrated through the RSQLite/DBI packages
and even higher level facilities (which I have posted about on this
thread) also exist. I think that such an integration would logically
be done by R people rather than sqlite people.
In the discussion on this thread
Thanks, I will follow up.
On 5/2/10, Gabor Grothendieck ggrothendi...@gmail.com wrote:
SQLite and R are already integrated through the RSQLite/DBI packages
and even higher level facilities (which I have posted about on this
thread) also exist. I think that such an integration would logically
28 matches
Mail list logo