Re: [sqlite] scripting language interpreter

2010-05-02 Thread Tim Romano
Very cool, Jay. Regards Tim Romano On Sat, May 1, 2010 at 11:23 AM, Jay A. Kreibich wrote: > > > > I'd love to see a Lua extension. I know that's been proposed. Lua is > MIT licensed, small, fast, and reasonably mature. It is also designed > to be easily embeddable,

Re: [sqlite] scripting language interpreter

2010-05-02 Thread Tim Romano
@DRH : Thank you for the info on SQLite with TCL. Regards Tim Romano > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] scripting language interpreter

2010-05-02 Thread Alexey Pechnikov
As I think, WClark work on stored procedures implementation for SQLite 3.x. But I don't know about current state of this job. You can see some of his patches here: http://sqlite.mobigroup.ru/src/wiki?name=WClark Note: I'm using the stored TCL procedures but native stores procedures support will

Re: [sqlite] SELECT question (computing day of week the using strftime() function)

2010-05-02 Thread Bernie Reiter
@ Jean-Christophe Deschamps and Roger Andersson Thanks A LOT :-) That is exactly what I was looking for. I do appreciate your help. Txs again bernie -- 13. SELECT question (computing day of week the using strftime()

Re: [sqlite] scripting language interpreter

2010-05-02 Thread Simon Slavin
On 2 May 2010, at 2:34pm, Alexey Pechnikov wrote: > As I think, WClark work on stored procedures implementation for SQLite > 3.x. But I don't know about current state of this job. Ah. Stored procedures are certainly doable. For instance JavaScript supports a little-used function called

[sqlite] Can I throw a query out to the group?

2010-05-02 Thread Matt Young
I am a bit of a novice. I am dealing with meta data, descriptions of the Bureau of Labor Statistics database. BLS data is identified by a series code (16 chars long) but the series format is different for each data group) I need to extract from an SQL table the names of other SQL tables and

Re: [sqlite] Can I throw a query out to the group?

2010-05-02 Thread Simon Slavin
On 2 May 2010, at 3:22pm, Matt Young wrote: > I need to extract from an SQL table the names of other SQL tables and > reference them in a second query to build the proper series_id code: Take a look at the section 'Pragmas to query the database schema' in http://www.sqlite.org/pragma.html

Re: [sqlite] scripting language interpreter

2010-05-02 Thread Tim Romano
Since Javascript has been mentioned: http://code.google.com/apis/v8/intro.html Tim Romano ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] scripting language interpreter

2010-05-02 Thread Alexey Pechnikov
I did speak about stored procedures compiled into native SQLite opcodes. P.S. I did see 1) the compiler (from C# or other language, I'm not sure) into SQLite opcodes 2) stored procedures realization for SQLite 2.x. 2010/5/2 Simon Slavin : > Ah.  Stored procedures are

[sqlite] [server] HTTP + SQLite bundled as single EXE?

2010-05-02 Thread Gilles Ganault
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

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

2010-05-02 Thread Simon Slavin
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 >

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

2010-05-02 Thread g...@greschenz.de
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 hat am 2. Mai 2010 um 21:26 geschrieben: > Hello, > > It's probably quite an easy thing to do for someone

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

2010-05-02 Thread Alexey Pechnikov
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

Re: [sqlite] scripting language interpreter

2010-05-02 Thread darren
> In part, this is a very broad question but I hope it's not unacceptable. > From a birdseye perspective, what is involved in integrating an > interpreted > scripting language with a database engine? I am aware that SQLite > supports > loadable extensions, but would the SQLite architecture also

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

2010-05-02 Thread Kees Nuyt
On Sun, 02 May 2010 21:26:27 +0200, Gilles Ganault 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

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

2010-05-02 Thread Matt Young
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

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

2010-05-02 Thread Simon Slavin
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

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

2010-05-02 Thread Gabor Grothendieck
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

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

2010-05-02 Thread Matt Young
Thanks, I will follow up. On 5/2/10, Gabor Grothendieck 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

Re: [sqlite] Modeling SQLite databases

2010-05-02 Thread M. Bashir Al-Noimi
Hello again, Does any one help me in this issue? I couldn't find any modeling tool for SQLite on Linux?! I need a tool provides diagram database designer just line SQLite Maestro. Thanks in advance... On 01/05/2010 08:14 م, M. Bashir Al-Noimi wrote: > Hi folks, > > Any one know if there is