[Helma-user] Is it possible to use SQL Queries directly without collections or mappings etc.?

[AndiSkater]

Hi All!

I'm completely new to helma and I just made the tutorial some time ago. At
the moment I'm planning a Web 2.0 Web Application which will be almost like
a Desktop Application (so much client-side javascript and almost no
classical pages). I'm considering helma because I want to use javascript on
the server-side, too, for sake of code portability. In a running project I'm
using ASP with JScript and an connected SQlite Database and programming is
really nice, but ASP is from Microsoft and I don't want to use a Windows
Server for my next project.

helma seems very interesting an offers many features, but  I have to admit,
that I don't understand the concept of object-relational mapping. I searched
this forum and I found some posts of people knowing which SQL statemant they
would use to get the data they want, but who did not know how to map this.
Why does hemla hide the power of SQL behind these rather limited
collections?

I often use complex SQL statemants and I know how to construct them, isn't
it possible to use SQL Queries directly? This morning I woke up and thought,
well, there is this sqlshell... it seemed to accept a SQL query. So I had a
look at the code of helma.sqlshell.js and found the method:
helma.sqlshell.Datasource.prototype.query = function(con, param) {
    // some SQL has been submitted - evaluate it
...

So, is it possible to use this capability to query the database directly and
create a helma application which is a bit more like PHP oder ASP? My project
will use the server-side mostly for DB and File Access and security relevant
methods through AJAX (respectively AJAJ).

I had a look at http://en.wikipedia.org/wiki/Server-Side_JavaScript but most
of the other implementation implementing JS on server-side are in early
development or make things even more complex. :-/

Probably you can give me some hints if helma is right for me or if there is
an alternative.

Thanks in advance,
Andi

-- 
View this message in context: http://www.nabble.com/Is-it-possible-to-use-SQL-Queries-directly-without-collections-or-mappings-etc.--tf3063012s2589.html#a8517935
Sent from the Helma - User mailing list archive at Nabble.com.