Lysee 3.0.3 has just been released

[libudi]

Hello,
I have just released lysee 3.0.3 to google code: http://code.google.com/p/lysee/.

Lysee is a open source script engine written in pure pascal, modified BSD license. It can be embedded into pascal programs to execute outside LYSEE script.

Lysee was compiled with Free Pascal 2.4.X, Delphi 2006 and Delphi Xe in Xp, Win7 and ubunto 11.10, both of 32 and 64 bit editions.

Documents:
    Language Reference: http://code.google.com/p/lysee/wiki/Reference
    Installation:  http://code.google.com/p/lysee/wiki/Installation
    How to embed lysee:  http://code.google.com/p/lysee/wiki/Embed

Hopefully, it can do something for you. Try it, good advices are wellcome!

[Leledumbo]

Haven't looked at it for a long time, does it have english documentation now?

[libudi]

I tried to write more english documentations, but what i have write is chinese-style english.
I will keep upgrading lysee in my spare time and use it in my work, but at this time,  i need more time and resources to do more.

[Leledumbo]

Just download and compile on my Kubuntu 11.10, needs a little adjustment to the makefile due to move of AvgLvlTree unit (to components/lazutils) in my svn Lazarus installation and removal of -WG option (only applicable to Windows target). Other than that, everything works fine.

[libudi]

Big changes will not be made to lysee.  The next target is to make lysee more stable, effective and simple.

[fabienwang]

I tried to write more english documentations, but what i have write is chinese-style english.
I will keep upgrading lysee in my spare time and use it in my work, but at this time,  i need more time and resources to do more.

man, you did really improve your english since i last checked the project lysee, it was 2010 or beginning 2011.
Btw i have a question:

you say on the page "Lysee script can be embedded into HTML to develop active WEB sites"
but can lysee be used with any web server? apache, nginx ? or do i have to make my own web server ?
and last question: i don't see files functions or db access functions like sqlite/mysql ? are the bindings planned?

[libudi]

man, you did really improve your english since i last checked the project lysee, it was 2010 or beginning 2011.
Btw i have a question:

you say on the page "Lysee script can be embedded into HTML to develop active WEB sites"
but can lysee be used with any web server? apache, nginx ? or do i have to make my own web server ?
and last question: i don't see files functions or db access functions like sqlite/mysql ? are the bindings planned?

Lysee comes from a Excel-like sheet component I wrote with delphi 6 years before 2003, google EFX(TLiEasyItem, TLiEasyForm, TLiEasyView) to find it, lysee was used to implement VB-like macros.

Lysee can access any SQL databases via sqldb module and produce HTML pages via cgi module built in lysee_cgi. lysee_cgi works in standard CGI mode, use <% and %> as code marks(same as ASP).  I usually use FireBird database and Abyss web server to develop websites, they are more simple and effective to me.

I'd like to write some more wikis to explain how to use database and develop websites.

use function funcs() and types() to get a module's information:

>>> load('sqldb')
sqldb
>>> types(sqldb)
{sqldb::database sqldb::dataset}
>>> funcs(sqldb)
{database_create:database(DBName:string) database_execSQL:int(db:database SQL:string) database_openSQL:dataset(db:database SQL:string) database_tables:string(db:database) database_procedures:string(db:database) database_connecTo:void(db:database target:string user:string password:string source:string params:string) database_disconnect:void(db:database) database_reconnect:void(db:database) database_connected:int(db:database) database_transact:void(db:database) database_transacting:int(db:database) database_commit:void(db:database) database_commitRetaining:void(db:database) database_commitAndTransact:void(db:database) database_rollback:void(db:database) database_rollbackRetaining:void(db:database) database_rollbackAndTransact:void(db:database) database_escape:string(db:database stringValue:string) dataset_indexOf:int(ds:dataset fieldName:string) dataset_close:void(ds:dataset) dataset_open:dataset(ds:dataset SQL:string) dataset_count:int(ds:dataset)
 dataset_first:void(ds:dataset) dataset_last:void(ds:dataset) dataset_prior:void(ds:dataset) dataset_next:void(ds:dataset) dataset_eof:int(ds:dataset) dataset_bof:int(ds:dataset) dataset_name:string(ds:dataset index:int) dataset_type:type(d
s:dataset fieldNameOrIndex) dataset_string:string(ds:dataset fieldNameOrIndex) dataset_int:int(ds:dataset fieldNameOrIndex) dataset_float:float(ds:dataset fieldNameOrIndex)}
>>> database_create
database_create:database(DBName:string)
>>> database_connecTo
database_connecTo:void(db:database target:string user:string password:string sou
rce:string params:string)
>>>

The way to connect firebird:

>>> set fb = database("ib")
>>> fb.connecTo('mydb.fdb', '', 'SYSDBA', 'masterkey')
>>> set ds = fb.openSQL("select * from mytable")
>>>

[Leledumbo]

but can lysee be used with any web server? apache, nginx ? or do i have to make my own web server ?

I think the way it works is like Perl style CGI (not with any modxxx for apache, simply plain CGI)

[libudi]

but can lysee be used with any web server? apache, nginx ? or do i have to make my own web server ?

I think the way it works is like Perl style CGI (not with any modxxx for apache, simply plain CGI)

E!,  lysee_cgi is a standalone CGI program, not a module like ISAPI, NSAPI or apache MOD.  And of course, it is easy to convert lysee CGI to a ISAPI, NSAPI or apache MOD. FastCGI(ruby, PHP uses) and other extended CGIs are not supported.

[libudi]

The builtin and auto loaded sys module predefined more types and functions:

Code: [Select]

>>> length(types(sys))
13
>>> length(funcs(sys))
181
>>> methods(string 1)
{"string_set" "string_name" "string_value" "string_compare" "string_replace" "st
ring_pos" "string_lastPos" "string_left" "string_right" "string_trim" "string_tr
imL" "string_trimR" "string_trimA" "string_copy" "string_delete" "string_insert"
 "string_lower" "string_upper" "string_isAlpha" "string_isAlnum" "string_isCntrl
" "string_isSpace" "string_isDigit" "string_isHex" "string_fileText" "string_sav
eToFile" "string_fullFileName" "string_filePath" "string_fileName" "string_fileE
xt" "string_changeExt" "string_lines" "string_chars" "string_isLower" "string_is
Upper"}
>>>