[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

[sqlite] Sqlite as a FIFO buffer?

[Allen Fowler]

Hello,

I have several CGI and cron scripts and that I would like coordinate via a 
"First In
/ First Out" style buffer.That is, some processes are adding work
units, and some take the oldest and start work on them.

Could SQLite be used for this?  

It would seem very complex to use SQL for just a FIFO, but then again, SQLite 
would take acre of all ACID / concurrency issues.

Has this been done before?

Thanks,
:)



  

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

Re: [sqlite] Use the result of a query, as a variable name in another query ?

[Dennis Cote]

Stef Mientki wrote:
> to test complex queries, I want to use the command line utility ( or an 
> equivalent that remembers what I type).
>   
The sqlite command line program sqlite3.c will remember what you type if 
you build your own executable from the source. The command line will use 
the readline or editline libraries if they are available when building 
the executable. These libraries provide full command line history 
functionality.

These libraries are not used in the precompiled executables that you can 
download because of licensing issues. SQLite's public domain license is 
not compatible with the GPL and BSD license used by these libraries, so 
they can't be linked into the executables that are distributed by Richard.

I always build my own command line sqlite from source to ensure I get 
the history functions provided by these very useful libraries.

 
> Now I've a table which contains the names of a set of other tables.
> In Python I can easily create the SQL string (containing the field name) 
> and commit it to the database.
>
> Is there a way realize this in the command line ?
> So I need to get the result of a query into a variable and then use that 
> variable in a new query.
>   
If I understand your question (which seems a little vague to me), there 
is no way to build and execute SQL queries that include the result of 
other queries using the command line.

You can use one query to build the text of another query, but there is 
no way to execute the resulting query using the command line. The best 
you could do would be to pass the SQL query text result from one 
invocation of the command line as input to a second invocation of the 
command line where it would be executed. In effect you are using your 
command shell to store the result of the first query and pass it back 
into a second sqlite command. You would be replacing Python programming 
with bash shell scripting.

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

Re: [sqlite] Sorting swedish characters

[Igor Tandetnik]

"Giovanni Ferrari"
 wrote in
message news:4a0fbda5.5050...@telia.com
> Is there a way to sort correctly swedish characters like Ö Ä Å under
> SQLITE?

http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/icu/README.txt

Igor Tandetnik 



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

[sqlite] Sorting swedish characters

[Giovanni Ferrari]

Hi!

Is there a way to sort correctly swedish characters like Ö Ä Å under SQLITE?

Thanks in advance

Rgds

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