Thread: postgresql and javascript

RobertD.Stewart@ky.gov wrote:
> Does anyone know how to connect  javascript to a postgresql database

You can't connect javascript to any sort of database. You need something
like php, python etc - it can connect to your database and generate
javascript.

Regards,

Chris Smith

Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia

Ph: +61 2 9517 2505
Fx: +61 2 9517 1915

email: info@interspire.com
web: www.interspire.com

On Tuesday 07 December 2004 22:42, Chris Smith wrote:
> RobertD.Stewart@ky.gov wrote:
> > Does anyone know how to connect  javascript to a postgresql database
>
> You can't connect javascript to any sort of database. You need something
> like php, python etc - it can connect to your database and generate
> javascript.

Well you may not be able to now, but I seem to recall the a future version
of Kexi (the KOffice version of Access) although it currently it scripted in
Python it is intended to allow it to be scripted in ECMAScript (which is
near enough JavaScript), so that will have to produce an interface.  But
you will need to wait till at least next year.

David

>
> Regards,
>
> Chris Smith
>
> Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia
>
> Ph: +61 2 9517 2505
> Fx: +61 2 9517 1915
>
> email: info@interspire.com
> web: www.interspire.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html

There is this from Mozilla:  http://www.mozilla.org/projects/sql/


On Tue, 7 Dec 2004 10:27:05 -0500, robertd.stewart@ky.gov
<robertd.stewart@ky.gov> wrote:
> Does anyone know how to connect  javascript to a postgresql database
>
> Please send example if anyone has done it
>

--
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org

Chris Smith wrote:
> RobertD.Stewart@ky.gov wrote:
>
>> Does anyone know how to connect  javascript to a postgresql
>> database
>
>
> You can't connect javascript to any sort of database.

Actually you can, with server side javascript, although I don't know if
it supports postgresql.  It does support odbc.

--
Until later, Geoffrey

# Does anyone know how to connect javascript to a postgresql database
#
# Please send example if anyone has done it

Maybe you mean Java?  Javascript runs within the browser and AFAIK has
no facilities for dealing with a database connection.

FWIW, you can accomplish what you're probably attempting to do by
having PHP or something comprable generate the javascript data sets
you want when the page is rendered.

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

----- Original Message -----

From: RobertD.Stewart@ky.gov

To: pgsql-general@postgresql.org

Sent: Tuesday, December 07, 2004 5:27 PM

Subject: [GENERAL] postgresql and javascript

Does anyone know how to connect  javascript to a postgresql database

Please send example if anyone has done it

 

 

thanks

 

Robert Stewart

Network Eng

Commonwealth Office of Technology

Finance and Administration Cabinet

101 Cold Harbor

Work # 502 564 9696

Cell # 502 330 5991

Email RobertD.Stewart@ky.gov

 

The world rejoiced as nabifadel@usj.edu.lb ("Najib Abi Fadel") wrote:
> i don't see any practical use of javascript with Postgresql, since a
> java script is on the client side.   
>
> Unless you want each client machine to have its own database
> !!!!!!!!!!!!!

Actually, there _is_ a practical use for this.

Mozilla/XUL applications presently have to jump through considerable
hoops to get data stored anywhere more sophisticated than files.

It seems to me that having PostgreSQL support more directly embedded
in Mozilla's ECMAScript implementation would encourage building more
data driven applications, which is hardly a bad thing.

<http://dmoz.org/Computers/Data_Formats/Markup_Languages/XML/Applications/XUL/Applications/>

There aren't any of that style now, which is hardly surprising, as the
present ways involve jumping through various hoops that are doubtless
painful both to code, support, and to watch run in slow-like-molasses
fashion...
--
"cbbrowne","@","ntlug.org"
http://linuxfinances.info/info/emacs.html
"As long as war is regarded as wicked, it will always have
 its fascination.  When it is looked upon as vulgar,
 it will cease to be popular."
    --Oscar Wilde

Geoffrey wrote:

> Chris Smith wrote:
>
>> RobertD.Stewart@ky.gov wrote:
>>
>>> Does anyone know how to connect  javascript to a postgresql
>>> database
>>
>>
>>
>> You can't connect javascript to any sort of database.
>
>
> Actually you can, with server side javascript, although I don't know
> if it supports postgresql.  It does support odbc.
>
Javascript is simply designed for lightweight scripting against a
pre-existing object set provided by the host program.  The quick answer
is that you will need to look for documentation in the program you are
using.  I think that Mozilla used to have an optional add-in for
PostgreSQL support, but it doesn't look like it has been maintained in a
while.

Best Wishes,
Chris Travers
Metatron Technology Consulting

You might want to look at this :
https://bugzilla.mozilla.org/show_bug.cgi?id=81653
This project is a native Postgresql connection in XUL (an XML based
language that describes the Widgets in Firefox).

I have not had time to play with this but it looks like the Firefox
client could connect natively to a Postgres DB and expose it's widgets
to provide a rich DB interface, with the scripting being done in
JScript. This could in essence turn Firefox into an access like client
to a Postgres DB (at least in so far as the forms go). Seems very
promising , but it does not look like development is very active at the
moment.

Cheers
Johan Wehtje

Geoffrey wrote:

> Chris Smith wrote:
>
>> RobertD.Stewart@ky.gov wrote:
>>
>>> Does anyone know how to connect  javascript to a postgresql
>>> database
>>
>>
>>
>> You can't connect javascript to any sort of database.
>
>
> Actually you can, with server side javascript, although I don't know
> if it supports postgresql.  It does support odbc.
>

Hi Robert,

This might help you get started:

http://developer.apple.com/internet/webcontent/xmlhttpreq.html

Keep us posted!

Beau

Good day to all ...

I hope any one can give me an advice ... to optimize my database...

im having a problem when i'm backing up my DB and also using vacuum for my
DB...
my CPU load goes up.... and no one can use my DB... most of the transaction
comes from web server..

I just need ur good advice ...

thank you

please check my postgresql.conf
--
#
#
# Connection Parameters
#
tcpip_socket = true
#ssl = false

max_connections = 300
superuser_reserved_connections = 100

port = 5432
#hostname_lookup = false
#show_source_port = false

#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777 # octal

#virtual_host = ''

#krb_server_keyfile = ''


#
# Shared Memory Size
#
shared_buffers = 600  # min max_connections*2 or 16, 8KB each
#max_fsm_relations = 1000 # min 10, fsm is free space map, ~40 bytes
#max_fsm_pages = 10000  # min 1000, fsm is free space map, ~6 bytes
#max_locks_per_transaction = 64 # min 10
#wal_buffers = 8  # min 4, typically 8KB each

#
# Non-shared Memory Sizes
#
#sort_mem = 1024  # min 64, size in KB
#vacuum_mem = 8192  # min 1024, size in KB


#
# Write-ahead log (WAL)
#
#checkpoint_segments = 3 # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 300 # range 30-3600, in seconds
#
#commit_delay = 0  # range 0-100000, in microseconds
#commit_siblings = 5  # range 1-1000
#
#fsync = true
#wal_sync_method = fsync # the default varies across platforms:
#    # fsync, fdatasync, open_sync, or open_datasync
#wal_debug = 0   # range 0-16


#
# Optimizer Parameters
#
enable_seqscan = true
enable_indexscan = true
enable_tidscan = true
enable_sort = true
enable_nestloop = true
enable_mergejoin = true
enable_hashjoin = true

effective_cache_size = 1000 # typically 8KB each
random_page_cost = 4  # units are one sequential page fetch cost
cpu_tuple_cost = 0.01  # (same)
cpu_index_tuple_cost = 0.001 # (same)
cpu_operator_cost = 0.0025 # (same)

default_statistics_target = 10 # range 1-1000

#
# GEQO Optimizer Parameters
#
geqo = true
geqo_selection_bias = 2.0 # range 1.5-2.0
geqo_threshold = 11
geqo_pool_size = 1024  # default based on tables in statement,
    # range 128-1024
geqo_effort = 1
geqo_generations = 0
geqo_random_seed = -1  # auto-compute seed


#
# Message display
#
#server_min_messages = notice # Values, in order of decreasing detail:
    #   debug5, debug4, debug3, debug2, debug1,
    #   info, notice, warning, error, log, fatal,
    #   panic
#client_min_messages = notice # Values, in order of decreasing detail:
    #   debug5, debug4, debug3, debug2, debug1,
    #   log, info, notice, warning, error
#silent_mode = false

log_connections = true
#log_pid = false
log_statement = true
log_duration = true
log_timestamp = true

#log_min_error_statement = panic # Values in order of increasing severity:
     #   debug5, debug4, debug3, debug2, debug1,
     #   info, notice, warning, error, panic(off)

#debug_print_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false

#explain_pretty_print = true

# requires USE_ASSERT_CHECKING
#debug_assertions = true


#
# Syslog
#
syslog = 2   # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'


#
# Statistics
#
show_parser_stats = false
show_planner_stats = false
show_executor_stats = false
show_statement_stats = false

# requires BTREE_BUILD_STATS
#show_btree_build_stats = false


#
# Access statistics collection
#
stats_start_collector = false
stats_reset_on_server_start = false
stats_command_string = false
stats_row_level = false
stats_block_level = false


#
# Lock Tracing
#
#trace_notify = false

# requires LOCK_DEBUG
#trace_locks = false
#trace_userlocks = false
#trace_lwlocks = false
#debug_deadlocks = false
#trace_lock_oidmin = 16384
#trace_lock_table = 0


#
# Misc
#
autocommit = true
#dynamic_library_path = '$libdir'
#search_path = '$user,public'
#datestyle = 'iso, us'
#timezone = unknown  # actually, defaults to TZ environment setting
#australian_timezones = false
#client_encoding = sql_ascii # actually, defaults to database encoding
#authentication_timeout = 60 # 1-600, in seconds
#deadlock_timeout = 1000 # in milliseconds
#default_transaction_isolation = 'read committed'
#max_expr_depth = 10000  # min 10
#max_files_per_process = 1000 # min 25
#password_encryption = true
#sql_inheritance = true
#transform_null_equals = false
#statement_timeout = 0  # 0 is disabled, in milliseconds
#db_user_namespace = false



#
# Locale settings
#
# (initialized by initdb -- may be changed)
LC_MESSAGES = 'en_US.UTF-8'
LC_MONETARY = 'en_US.UTF-8'
LC_NUMERIC = 'en_US.UTF-8'
LC_TIME = 'en_US.UTF-8'

-----------------

here is my diskspace..
/dev/sdb1              3526172   1132784   2214268  34% /
/dev/sda1               248895      8796    227249   4% /boot
none                   2005700         0   2005700   0% /dev/shm
/dev/md0              65757260  50992580  11424376  82% /var
/dev/sdc1             17409840  13521548   3003916  82% /backup
----------------

Javascript is not only client side. IIS has two script languages installed as
default: VBScript and JScript(MS version of Javascript).

Indeed at my work I have already written hundreds of javascript server pages.
We use MS SQL Server.

I understand Robert Stewart's question, and the only advice I have is look at
the ADO reference site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscmicrosoftadoprogrammersreference.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefodbcprovspec.asp

If Postgresql can expose an ODBC interface then it will work.

Regards,
Clodoaldo Pinto

 --- Najib Abi Fadel <nabifadel@usj.edu.lb> escreveu:
> Hi
>
> i don't see any practical use of javascript with Postgresql, since a java
> script is on the client side.
>
> Unless you want each client machine to have its own database !!!!!!!!!!!!!
>
>
> Najib.
>   ----- Original Message -----
>   From: RobertD.Stewart@ky.gov
>   To: pgsql-general@postgresql.org
>   Sent: Tuesday, December 07, 2004 5:27 PM
>   Subject: [GENERAL] postgresql and javascript
>
>
>   Does anyone know how to connect  javascript to a postgresql database
>
>   Please send example if anyone has done it
>
>
>
>
>
>   thanks
>
>
>
>   Robert Stewart
>
>   Network Eng
>
>   Commonwealth Office of Technology
>
>   Finance and Administration Cabinet
>
>   101 Cold Harbor
>
>   Work # 502 564 9696
>
>   Cell # 502 330 5991
>
>   Email RobertD.Stewart@ky.gov
>
>
>





_______________________________________________________
Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra
uma conta agora! http://br.info.mail.yahoo.com/

Chris Travers wrote:
> Geoffrey wrote:
>
>> Chris Smith wrote:
>>
>>> RobertD.Stewart@ky.gov wrote:
>>>
>>>> Does anyone know how to connect  javascript to a postgresql
>>>> database
>>>
>>>
>>>
>>>
>>> You can't connect javascript to any sort of database.
>>
>>
>>
>> Actually you can, with server side javascript, although I don't know
>> if it supports postgresql.  It does support odbc.
>>
> Javascript is simply designed for lightweight scripting against a
> pre-existing object set provided by the host program.

I wouldn't recommend it, but we did have a full database implementation
strictly using server side javascript.  It was a time reporting system
and it worked okay.  The server side stuff seemed to be quite a load on
the server though.  We are using to connect to an existing Oracle
database.  Nothing else, html and server side javascript.



--
Until later, Geoffrey

Clodoaldo Pinto wrote:
> Javascript is not only client side. IIS has two script languages
> installed as default: VBScript and JScript(MS version of Javascript).

Only does you good if you're running on a IIS platform.  The server side
Javascript engine worked on the Netscape web server product, which was
then moved to Iplanet, Sun product I think.

--
Until later, Geoffrey