javascript to view data from a database

[Methis Elddir]

Can javascript be used to build a web-based front end to a local database?

I wrote an application for a client that controls a series of medical
devices. It runs a series of tests, collects data, and writes it to a
local SQLite database. The customer would like to interactively
filter/query this local data and display it in tables and charts. I
could do this with the language used to develop the application
(LabVIEW) or I can outsource it to someone else. I prefer the latter.
I would also prefer that the client install as little software as possible.

A friend of mine, trying to start his own business, provided an estimate
for building such a web-based application. He wants to use PHP +
Apache. Is that even necessary?

BTW, I obviously know nothing about javascript but I don't mind doing
some reading if you have some links on this topic.

-Methis

 

[Evertjan.]

Methis Elddir wrote on 23 apr 2007 in comp.lang.javascript:

Can javascript be used to build a web-based front end to a local
database?

[please do not use front-end and back-end terminologiy in a web context,
they only confuses the issue]

== 1 ==

Do you mean using serverside code to read a clientside database?

[Javascript dot not mean clientside,
it can be used perfectly well on a server with an ASP platform]

Not without compromizing the security settings of your browser.

== 2 ==

Or do you mean a clientside browser code to read a clientside database?

The same restriction nearly:
Not without compromizing the security settings of your browser.

== 3 ==

Using a serverside code on a serverside database is perfectly possible an
could be reasonably safe, if you know what you are doing, remembering
that the web is a dangerous place securitywize.

But as you show you are not, first start your learning curve now for a
year or two, or pay fow quality expert help. Medical information should
be held under strict privacy controll.

I wrote an application for a client that controls a series of medical
devices. It runs a series of tests, collects data, and writes it to a
local SQLite database. The customer would like to interactively
filter/query this local data and display it in tables and charts. I
could do this with the language used to develop the application
(LabVIEW) or I can outsource it to someone else. I prefer the latter.
I would also prefer that the client install as little software as
possible.

A friend of mine, trying to start his own business, provided an
estimate for building such a web-based application.
He wants to use PHP + Apache.

If you mean, that he will access a clientside database from web-based
PHP/Apache, I would not trust his knowledge of programming and security.

Is that even necessary?

Unanswerable, without a adaequate definition of "even necessary",
J[ava]script on an ASP platform can do the same,
while programming with the same experise.
but read ==3== above.

BTW, I obviously know nothing about javascript but I don't mind doing
some reading if you have some links on this topic.

Obviously I you say so, so start learning
by Googling for tutorial + javascript.

Perhaps the best start is to read the NG faq.
<http://www.jibbering.com/faq/>

 

[Methis Elddir]

Evertjan. wrote:

== 2 ==

Or do you mean a clientside browser code to read a clientside database?

Yes to this one.

Thanks for your sound advice

-methis