Re: [sqlite] Accessing sqlite using javascript

[Saurabh Pawar]

This is the best link i have found out till now which will give a very clear 
view.

https://developer.mozilla.org/en/Storage

It helped me a lot.Hope it helps you too.



- Original Message 
From: Saurabh Pawar <saurabh.pa...@ymail.com>
To: sql...@surfulater.com; General Discussion of SQLite Database 
<sqlite-users@sqlite.org>
Sent: Tuesday, 19 May, 2009 8:53:52 AM
Subject: Re: [sqlite] Accessing sqlite using javascript


I tried both the options.EXTJS lib is for firefox 1.5+.So it wont work.

The snippet is giving an error --
Permission denied to get property XPCComponents.classes

Are you aware of this error?.

Thank you.



- Original Message 
From: Neville Franks <sql...@surfulater.com>
To: sqlite-users@sqlite.org
Sent: Monday, 18 May, 2009 2:16:52 PM
Subject: Re: [sqlite] Accessing sqlite using javascript

Monday, May 18, 2009, 3:16:45 PM, you wrote:

SP> I had asked the same question a few days back,but need a some more help.
SP> I am having my whole SQLite database on client's machine.I want a
SP> way to access that db using javscript.I heard about gears,but the
SP> problem is my target PC has firefox 1.08 and gears is for 1.5+.So
SP> is there any other way around?...Also is there any tutorial or
SP> guide which i can have online for referring when i am writing the code?.

SP> Thank you.

There are several ways to do this. From Firefox see:
http://codesnippets.joyent..com/posts/show/1030

The ExtJS Library also provides access to SQLite, but I have not used
that part of ExtJS yet.

Finally Google: "sqlite from javascript".

---
Best regards,
  Neville Franks, http://www.surfulater.com http://blog.surfulater.com


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  Explore and discover exciting holidays and getaways with Yahoo! India 
Travel http://in.travel.yahoo.com/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  Cricket on your mind? Visit the ultimate cricket website. Enter 
http://beta.cricket.yahoo.com

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Accessing sqlite using javascript

[Saurabh Pawar]

I tried both the options.EXTJS lib is for firefox 1.5+.So it wont work.

The snippet is giving an error --
Permission denied to get property XPCComponents.classes

Are you aware of this error?.

Thank you.



- Original Message 
From: Neville Franks 
To: sqlite-users@sqlite.org
Sent: Monday, 18 May, 2009 2:16:52 PM
Subject: Re: [sqlite] Accessing sqlite using javascript

Monday, May 18, 2009, 3:16:45 PM, you wrote:

SP> I had asked the same question a few days back,but need a some more help.
SP> I am having my whole SQLite database on client's machine.I want a
SP> way to access that db using javscript.I heard about gears,but the
SP> problem is my target PC has firefox 1.08 and gears is for 1.5+.So
SP> is there any other way around?...Also is there any tutorial or
SP> guide which i can have online for referring when i am writing the code?.

SP> Thank you.

There are several ways to do this. From Firefox see:
http://codesnippets.joyent.com/posts/show/1030

The ExtJS Library also provides access to SQLite, but I have not used
that part of ExtJS yet.

Finally Google: "sqlite from javascript".

---
Best regards,
  Neville Franks, http://www.surfulater.com http://blog.surfulater.com


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  Explore and discover exciting holidays and getaways with Yahoo! India 
Travel http://in.travel.yahoo.com/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Accessing sqlite using javascript

[Saurabh Pawar]

Thanks a lot.I was looking exactly for something like this



- Original Message 
From: Neville Franks 
To: sqlite-users@sqlite.org
Sent: Monday, 18 May, 2009 2:16:52 PM
Subject: Re: [sqlite] Accessing sqlite using javascript

Monday, May 18, 2009, 3:16:45 PM, you wrote:

SP> I had asked the same question a few days back,but need a some more help.
SP> I am having my whole SQLite database on client's machine.I want a
SP> way to access that db using javscript.I heard about gears,but the
SP> problem is my target PC has firefox 1.08 and gears is for 1.5+.So
SP> is there any other way around?...Also is there any tutorial or
SP> guide which i can have online for referring when i am writing the code?.

SP> Thank you.

There are several ways to do this. From Firefox see:
http://codesnippets.joyent.com/posts/show/1030

The ExtJS Library also provides access to SQLite, but I have not used
that part of ExtJS yet.

Finally Google: "sqlite from javascript".

---
Best regards,
  Neville Franks, http://www.surfulater.com http://blog.surfulater.com


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  Explore and discover exciting holidays and getaways with Yahoo! India 
Travel http://in.travel.yahoo.com/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Accessing sqlite using javascript

[Saurabh Pawar]

I had asked the same question a few days back,but need a some more help.
I am having my whole SQLite database on client's machine.I want a way to access 
that db using javscript.I heard about gears,but the problem is my target PC has 
firefox 1.08 and gears is for 1.5+.So is there any other way around?...Also is 
there any tutorial or guide which i can have online for referring when i am 
writing the code?.

Thank you.


  Explore and discover exciting holidays and getaways with Yahoo! India 
Travel http://in..travel.yahoo.com/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Accessing sqlite3 through javascript.

[Saurabh Pawar]

I would like to thank you all first for replying to my query..

You have cleared my doubt to a great extent.However I still have somethings
to be cleared.I will ask them later after studying sqlite a bit more.

Its better to ask precise questions rather than vauge queries.

Thank you.
--- On Sat, 16/5/09, P Kishor <punk.k...@gmail.com> wrote:

> From: P Kishor <punk.k...@gmail.com>
> Subject: Re: [sqlite] Accessing sqlite3 through javascript.
> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
> Date: Saturday, 16 May, 2009, 4:22 AM
> On Sat, May 16, 2009 at 6:19 AM, Igor
> Tandetnik <itandet...@mvps.org>
> wrote:
> > "Saurabh Pawar" <saurabh.pa...@ymail.com>
> > wrote in message news:240022.95142...@web95016.mail.in2.yahoo.com
> >> So I would like to have some
> >> information if available on how to connect to
> sqlite database through
> >> javascript and access the same.
> >
> > http://gears.google.com/
> 
> gears allows creating and interacting with db on the
> client's machine,
> just like HTML5 databases, but not with db on the server
> machine. One
> would have to use some kind of server-side js and then
> interact with
> that via the client-side js.
> 
> 
> >
> > Igor Tandetnik
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> 
> 
> 
> -- 
> Puneet Kishor http://www.punkish.org/
> Carbon Model http://carbonmodel.org/
> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/
> Science Commons Fellow, Geospatial Data http://sciencecommons.org
> Nelson Institute, UW-Madison http://www.nelson.wisc.edu/
> ---
> collaborate, communicate, compete
> ===
> Sent from Karlstad, Sweden
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 


  Bring your gang together. Do your thing. Find your favourite Yahoo! group 
at http://in.promos.yahoo.com/groups/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Accessing sqlite3 through javascript.

[Saurabh Pawar]

I have been using sqlite3 for my engine based programs and now would like to 
use it for my web based applications which are completely based on html and 
javascript. So I would like to have some information if available on how to 
connect to sqlite database through javascript and access the same.Also would 
like to know if there are any disadvantages in doing so over a normal MYSQL 
database(which is done through PHP and which is what i want to avoid).
Thank You.




  Explore and discover exciting holidays and getaways with Yahoo! India 
Travel http://in.travel.yahoo.com/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users