[sqlite] Export the results from a select to excel
Hello, what is the fastest way to do this with the C-api? tx, Danny Belgium ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Optimising SQLite3 db's in C
Hello, I got my first SQLite based program up and running. It's a downloader for yahoo quotes in Linux. So speed is very important. I already twiddled with some settings but I am not sure if these are ok. Anybody any suggestions which settings we can tweak to make SQLite super fast? Is there a big risk to have the journal in memory instead of as a file = extra disk access and this in current computers the bottleneck. Hope soon we gone have payable SSD disks of 256MB ;-) regards, Danny Belgium ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] web page data scraping to sqlite db
Hello, I am working on a SQLite db with equity data in it. On http://finance.yahoo.com/q?s=dow you can find the current P/E and Div & Yield fields. So I like to store in my db for name=DOW pe=12.25 and div=7.9 in a automated way. I can use wget to get the page in a file but I still needs some function to get those 2 fields. The best ofcourse would be doing this with one function call. Any ideas how to tackle this problem? tx, Danny ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Getting field data back from SQLite db
Hello, I am new on SQLite so bear with me :-) Can someone give me a simple c solution on following: I execute select telnr from contacts where name="David" I just want to get from the found record the content of field telnr back to my c program in variable c_telnr. Thanks in advance, Danny Belgium ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users