PGSQL and Javascript

[regme please]

Hello all.

Is there a way to directly access PGSQL from a Javascript application?
With no application server intervention, I mean.
Just like libq allows access from C/C++.

--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

--
Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces

[Allan Kamau-3]

May be Javascript + JDBC not sure.

But the question is why would you want to do so?
Javascript can be read easily by the user having the javascript
running on their browser. JDBC or any other database connecting client
will want to some how authenticate the user in most cases the
username, password and maybe remote IP is used. This mean that your
javascript will probably contain username and password in order to use
JDBC to connect to the DB, is this favourable?

Allan.

On Fri, Jan 30, 2009 at 1:40 PM, Reg Me Please <regmeplease@...> wrote:

> Hello all.
>
> Is there a way to directly access PGSQL from a Javascript application?
> With no application server intervention, I mean.
> Just like libq allows access from C/C++.
>
> --
> Fahrbahn ist ein graues Band
> weisse Streifen, grüner Rand
>
> --
> Sent via pgsql-general mailing list (pgsql-general@...)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces

[Sean Davis-3]

No.  I'm not sure how that could be done given the security concerns.

Sean

On Fri, Jan 30, 2009 at 6:40 AM, Reg Me Please <regmeplease@...> wrote:

Hello all.

Is there a way to directly access PGSQL from a Javascript application?
With no application server intervention, I mean.
Just like libq allows access from C/C++.

--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

--
Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces

[regme please]

I'd like to write part of the application in Javascript, server side, not in
the web page.

On Friday 30 January 2009 12:53:05 Allan Kamau wrote:

> May be Javascript + JDBC not sure.
>
> But the question is why would you want to do so?
> Javascript can be read easily by the user having the javascript
> running on their browser. JDBC or any other database connecting client
> will want to some how authenticate the user in most cases the
> username, password and maybe remote IP is used. This mean that your
> javascript will probably contain username and password in order to use
> JDBC to connect to the DB, is this favourable?
>
> Allan.
>
> On Fri, Jan 30, 2009 at 1:40 PM, Reg Me Please <regmeplease@...>

wrote:

> > Hello all.
> >
> > Is there a way to directly access PGSQL from a Javascript application?
> > With no application server intervention, I mean.
> > Just like libq allows access from C/C++.
> >
> > --
> > Fahrbahn ist ein graues Band
> > weisse Streifen, grüner Rand
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general@...)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general

--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

--
Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces

[Sean Davis-3]

On Fri, Jan 30, 2009 at 7:09 AM, Reg Me Please <regmeplease@...> wrote:

I'd like to write part of the application in Javascript, server side, not in
the web page.

I missed your point.  Do a google search for javascript interpreters in the language of your choice.  For example, there is Rhino for java.

Sean

 

On Friday 30 January 2009 12:53:05 Allan Kamau wrote:
> May be Javascript + JDBC not sure.
>
> But the question is why would you want to do so?
> Javascript can be read easily by the user having the javascript
> running on their browser. JDBC or any other database connecting client
> will want to some how authenticate the user in most cases the
> username, password and maybe remote IP is used. This mean that your
> javascript will probably contain username and password in order to use
> JDBC to connect to the DB, is this favourable?
>
> Allan.

>
> On Fri, Jan 30, 2009 at 1:40 PM, Reg Me Please <regmeplease@...>
wrote:
> > Hello all.
> >
> > Is there a way to directly access PGSQL from a Javascript application?
> > With no application server intervention, I mean.
> > Just like libq allows access from C/C++.
> >
> > --
> > Fahrbahn ist ein graues Band
> > weisse Streifen, grüner Rand
> >
> > --

> > Sent via pgsql-general mailing list (pgsql-general@...)

> > To make changes to your subscription:

> > http://www.postgresql.org/mailpref/pgsql-general

--

Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

--
Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces

[regme please]

I already have a JS interpreter (spidermonkey) but there is no PGSQL
interfacing API!
This'd be why I'm asking.

On Friday 30 January 2009 13:24:59 Sean Davis wrote:

> On Fri, Jan 30, 2009 at 7:09 AM, Reg Me Please <regmeplease@...>wrote:
> > I'd like to write part of the application in Javascript, server side, not
> > in
> > the web page.
>
> I missed your point.  Do a google search for javascript interpreters in the
> language of your choice.  For example, there is Rhino for java.
>
> Sean
>
> > On Friday 30 January 2009 12:53:05 Allan Kamau wrote:
> > > May be Javascript + JDBC not sure.
> > >
> > > But the question is why would you want to do so?
> > > Javascript can be read easily by the user having the javascript
> > > running on their browser. JDBC or any other database connecting client
> > > will want to some how authenticate the user in most cases the
> > > username, password and maybe remote IP is used. This mean that your
> > > javascript will probably contain username and password in order to use
> > > JDBC to connect to the DB, is this favourable?
> > >
> > > Allan.
> > >
> > > On Fri, Jan 30, 2009 at 1:40 PM, Reg Me Please <regmeplease@...>
> >
> > wrote:
> > > > Hello all.
> > > >
> > > > Is there a way to directly access PGSQL from a Javascript
> > > > application? With no application server intervention, I mean.
> > > > Just like libq allows access from C/C++.
> > > >
> > > > --
> > > > Fahrbahn ist ein graues Band
> > > > weisse Streifen, grüner Rand
> > > >
> > > > --
> > > > Sent via pgsql-general mailing list (pgsql-general@...)
> > > > To make changes to your subscription:
> > > > http://www.postgresql.org/mailpref/pgsql-general
> >
> > --
> > Fahrbahn ist ein graues Band
> > weisse Streifen, grüner Rand
> >
> > --
> > Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-interfaces

--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

--
Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces

[Miha D. Puc]

Well you can add you own objects to Spidermonkey via its c api. So you
can implement something like Database object in c using libq and access
it from your script.
Regards,
Miha

Reg Me Please pravi:

> I already have a JS interpreter (spidermonkey) but there is no PGSQL
> interfacing API!
> This'd be why I'm asking.
>
> On Friday 30 January 2009 13:24:59 Sean Davis wrote:
>  
>> On Fri, Jan 30, 2009 at 7:09 AM, Reg Me Please <regmeplease@...>wrote:
>>    
>>> I'd like to write part of the application in Javascript, server side, not
>>> in
>>> the web page.
>>>      
>> I missed your point.  Do a google search for javascript interpreters in the
>> language of your choice.  For example, there is Rhino for java.
>>
>> Sean
>>
>>    
>>> On Friday 30 January 2009 12:53:05 Allan Kamau wrote:
>>>      
>>>> May be Javascript + JDBC not sure.
>>>>
>>>> But the question is why would you want to do so?
>>>> Javascript can be read easily by the user having the javascript
>>>> running on their browser. JDBC or any other database connecting client
>>>> will want to some how authenticate the user in most cases the
>>>> username, password and maybe remote IP is used. This mean that your
>>>> javascript will probably contain username and password in order to use
>>>> JDBC to connect to the DB, is this favourable?
>>>>
>>>> Allan.
>>>>
>>>> On Fri, Jan 30, 2009 at 1:40 PM, Reg Me Please <regmeplease@...>
>>>>        
>>> wrote:
>>>      
>>>>> Hello all.
>>>>>
>>>>> Is there a way to directly access PGSQL from a Javascript
>>>>> application? With no application server intervention, I mean.
>>>>> Just like libq allows access from C/C++.
>>>>>
>>>>> --
>>>>> Fahrbahn ist ein graues Band
>>>>> weisse Streifen, grüner Rand
>>>>>
>>>>> --
>>>>> Sent via pgsql-general mailing list (pgsql-general@...)
>>>>> To make changes to your subscription:
>>>>> http://www.postgresql.org/mailpref/pgsql-general
>>>>>          
>>> --
>>> Fahrbahn ist ein graues Band
>>> weisse Streifen, grüner Rand
>>>
>>> --
>>> Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-interfaces
>>>      
>
>
>
>  

--
__________________________________________________________
Miha D. Puc
EBA, agencija za elektronsko poslovanje, d.o.o., Ljubljana
Teslova ulica 30
SI-1000 Ljubljana
e-mail: miha.puc@...
internet: www.eba.si
GSM: [phone]
TEL: [phone]
__________________________________________________________


--
Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces

[Thomas Markus]

look at apache cocoon for serverside javascript (rhino engine)
you can direct access java classes. write all db stuff in java and
access it from js

var dao = Packages.my.own.package.DAOController.findAll();
Packages.java.lang.System.out.println(dao.myproperty);


regards
thomas

Reg Me Please schrieb:
> Hello all.
>
> Is there a way to directly access PGSQL from a Javascript application?
> With no application server intervention, I mean.
> Just like libq allows access from C/C++.
>
>  


[t_markus.vcf]

---

begin:vcard
fn:Thomas Markus
n:Markus;Thomas
org:proventis GmbH
adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany
email;internet:t.markus@...
tel;work:[phone]
x-mozilla-html:FALSE
url:http://www.proventis.net
version:2.1
end:vcard

---

--
Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces

[Sean Davis-3]

On Fri, Jan 30, 2009 at 7:43 AM, Reg Me Please <regmeplease@...> wrote:

I already have a JS interpreter (spidermonkey) but there is no PGSQL
interfacing API!
This'd be why I'm asking.

Ah.  Sorry again.  No idea if this will be useful, but you might take a look at:

http://www.whitebeam.org/

Sean

 

On Friday 30 January 2009 13:24:59 Sean Davis wrote:
> On Fri, Jan 30, 2009 at 7:09 AM, Reg Me Please <regmeplease@...>wrote:
> > I'd like to write part of the application in Javascript, server side, not
> > in
> > the web page.
>
> I missed your point.  Do a google search for javascript interpreters in the
> language of your choice.  For example, there is Rhino for java.
>
> Sean
>
> > On Friday 30 January 2009 12:53:05 Allan Kamau wrote:
> > > May be Javascript + JDBC not sure.
> > >
> > > But the question is why would you want to do so?
> > > Javascript can be read easily by the user having the javascript
> > > running on their browser. JDBC or any other database connecting client
> > > will want to some how authenticate the user in most cases the
> > > username, password and maybe remote IP is used. This mean that your
> > > javascript will probably contain username and password in order to use
> > > JDBC to connect to the DB, is this favourable?
> > >
> > > Allan.
> > >
> > > On Fri, Jan 30, 2009 at 1:40 PM, Reg Me Please <regmeplease@...>
> >
> > wrote:
> > > > Hello all.
> > > >
> > > > Is there a way to directly access PGSQL from a Javascript
> > > > application? With no application server intervention, I mean.
> > > > Just like libq allows access from C/C++.
> > > >
> > > > --
> > > > Fahrbahn ist ein graues Band
> > > > weisse Streifen, grüner Rand
> > > >
> > > > --
> > > > Sent via pgsql-general mailing list (pgsql-general@...)
> > > > To make changes to your subscription:
> > > > http://www.postgresql.org/mailpref/pgsql-general
> >
> > --
> > Fahrbahn ist ein graues Band
> > weisse Streifen, grüner Rand
> >
> > --
> > Sent via pgsql-interfaces mailing list (pgsql-interfaces@...)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-interfaces

--

Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

[Oliveiros Cristina]

Some parts of this message have been removed. Learn more about Nabble's security policy.



Hello, all,

 

If I wanna set a table's column in a certain record to NULL, with an INSERT command, what value should I set the NpgsqlParameter.Value property?

 

Best,

Oliveiros