Re: [sqlite] sliteonline or sqlite in js
Impressive ! On 12 November 2014 12:08, Kirill kir...@aidagw.com wrote: Good day, Full line manager to work with sqlite directly from the browser on any platform: http://sqliteonline.com/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] GUI INfo
C++ or Python / Qt/PySide On 10 September 2014 02:05, jose isaias cabrera jic...@cinops.xerox.com wrote: Warren Young wrote... On 9/10/2014 14:56, Maxine Nietz wrote: I am an experienced Access VBA programmer. I know about the SQLite commands to create and manipulate data in tables and queries. What I want to know is where do I find info on creating a graphical user interface such as menus, forms and reports. What additional programs are required to do this? C#. D. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Variable values in Views
There a tcl binding to sqlite, maybe it could help you ? Noël On 30 July 2014 08:44, Sylvain Pointeau sylvain.point...@gmail.com wrote: It is called parameterized view in sqlserver. Actually it is extremely useful in order to have a good reusability in the code. I was actually missing it in Oracle, although I found a workaround of using the pipelined functions. Unfortunately, it is missing in sqlite, as well as the merge statement, also very useful (insert or replace has just to be avoided) What I used to make is to use a shell script, and to use sed to replace my variable before executing the script... Far from ideal but it worked ok, it is just annoying because we have to prepare the file first. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] R-Tree Storage Optimization for Points
Hi Mohit, Maybe you should use the spatialite extension ? Noël On 19 June 2014 06:27, Mohit Sindhwani m...@onghu.com wrote: Hello! We are using SQLite3 for storing geographical points that can be queried using a bounding box (find everything that lies within this box). Obviously, this query fits the capabilities of the RTree module very well and it is a simple 2 dimensional search using an R-Tree that has 5 columns. However, since these are points that are stored in the table, x1=x2 and y1=y2 when we do the insertion. As a former embedded systems engineer, this feels like a waste since I can see that we are inserting exactly the same value into the table. INSERT into data_rtree(1000, 10, 5, 10, 5); INSERT into data_rtree(1000, 17, 1, 17, 1); and so on. Is there a way that we could optimize the module so that we don't need to store the same value twice? We are using this on a system with constrained resources, so it helps to reduce the amount of storage space we need for our database. Thanks, Mohit. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] R-Tree Storage Optimization for Points
It should be painless if you omit geos, I think. On 19 June 2014 09:00, Mohit Sindhwani m...@onghu.com wrote: Hi Noël, Thanks for our reply. On 19/6/2014 2:19 PM, Noel Frankinet wrote: Hi Mohit, Maybe you should use the spatialite extension ? Noël I have to see if indeed spatialite handles the data more efficiently since it also relies on the R-Tree for quite a bit of stuff. That said, I do remember that once upon a time (admittedly 3 - 4 years ago), we had trouble getting Spatialite compiled for a Windows CE target. Maybe, it is time to revisit that again. Best Regards, Mohit. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Suggestion for shell .IMPORT improvement
I propose Musqlar, the Mighty universal sql Archiver :-) On 22 May 2014 15:22, Dominique Devienne ddevie...@gmail.com wrote: On Thu, May 22, 2014 at 1:51 PM, Richard Hipp d...@sqlite.org wrote: How about sqlar for SQL Archive? http://www.sqlite.org/sqlar I like it! Sounds ominous when pronounced out loud :). Much better name IMHO, and no negative connotation in French that I know of. --DD ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?
that would be interesting. Is the C interface from your client exactly like the C interface of sqlite ? On 2 April 2014 14:44, Harmen de Jong - CoachR Group B.V. har...@coachr.com wrote: Do you think it could be used with spatialite extension to build a multi-user spatial database ? Noel Frankinet We don't have experience with Spatialite. However, we had a quick look at it and think it should not be too hard to support this from our SQLite database server app. Best regards, Harmen de Jong ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?
so there is to client library to link to ? a simple layer that would mimic the sqlite interface and do all the xml encoding/decoding and communication could be handy ? On 2 April 2014 16:09, Harmen de Jong - CoachR Group B.V. har...@coachr.com wrote: that would be interesting. Is the C interface from your client exactly like the C interface of sqlite ? Since it is a server application, this server application itself accesses SQLite directly via C-API (so this server application uses indeed the C library of SQLite). However the client needs some way to connect to and communicate with this SQLite server. In our case we have chosen to use XML messages over socket to communicate with the server. Please have a look at the first post to find some examples of how to send your SQL code and prepare statements to the SQLite server application. Best regards, Harmen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] select all fields of a column in one table that are not in a column in another table
L'accesoire indispensable : http://www.adafruit.com/products/1533 On 17 October 2013 16:29, dean gwilliam mgbg25...@blueyonder.co.uk wrote: On 17/10/2013 14:45, Igor Tandetnik wrote: On 10/17/2013 3:35 AM, dean gwilliam wrote: On 16/10/2013 22:04, Igor Tandetnik wrote: On 10/16/2013 4:49 PM, dean gwilliam wrote: if I have two tables 1 aliases (std_name, raw_name) 2 items (name..) what would the query look like to select all name fields in itms that match neither std_name or raw_name in aliases and where the resulting list of names contains no duplicates. select distinct name from items where not exists (select 1 from aliases where std_name = name or raw_name = name); Thank you very much Igor. Your answer is very much appreciated. It seems that std_name would be better placed in another table eg std_names and I'm not sure how you'd change the query to reflect the extra table select distinct name from items where name not in (select std_name from std_names) and name not in (select raw_name from aliases); -- or select distinct name from items where name not in ( select std_name from std_names union all select raw_name from aliases ); Igor. Thank you very much indeed! __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] select all fields of a column in one table that are not in a column in another table
oups, sorry ! On 17 October 2013 16:36, Noel Frankinet noel.franki...@gmail.com wrote: L'accesoire indispensable : http://www.adafruit.com/products/1533 On 17 October 2013 16:29, dean gwilliam mgbg25...@blueyonder.co.ukwrote: On 17/10/2013 14:45, Igor Tandetnik wrote: On 10/17/2013 3:35 AM, dean gwilliam wrote: On 16/10/2013 22:04, Igor Tandetnik wrote: On 10/16/2013 4:49 PM, dean gwilliam wrote: if I have two tables 1 aliases (std_name, raw_name) 2 items (name..) what would the query look like to select all name fields in itms that match neither std_name or raw_name in aliases and where the resulting list of names contains no duplicates. select distinct name from items where not exists (select 1 from aliases where std_name = name or raw_name = name); Thank you very much Igor. Your answer is very much appreciated. It seems that std_name would be better placed in another table eg std_names and I'm not sure how you'd change the query to reflect the extra table select distinct name from items where name not in (select std_name from std_names) and name not in (select raw_name from aliases); -- or select distinct name from items where name not in ( select std_name from std_names union all select raw_name from aliases ); Igor. Thank you very much indeed! __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] float to string conversion problem
Hello, The pda probably has no floating point support, you should check how sqlite as been compiled. Best wishes Noël On 14 June 2013 14:19, Arjen Markus arjen.mar...@deltares.nl wrote: Hi Filipe, On Thu, 13 Jun 2013 15:59:35 +0100 Filipe Madureira filipe.madureira@**sysdevsolutions.comfilipe.madure...@sysdevsolutions.com wrote: Hi, I have a problem executing a query on a WinCE6 ARM device. I use SQlite for years and tested on all types of devices including WinCE6 ARM and never had a problem. But I have one problem on particular device that has a Texas Instruments ARM CPU with WinCE6. A very simple way to reproduce my problem is: Create Table t1(c1 DECIMAL(12,3)) Insert Into t1(c1) values(2.55) Select c1 From t1 I run this Select with sqlite3_get_table() The value I get is 3.,+ It makes no sense, it is not even a number, and only happens if the decimal values have a number higher than 5. This seems to be a problem with this CPU/WinCE version. I don't know SQLite source code, and it is huge, so can someone tell me where in the source code the float (or double, I don't know) value of 2.55 is being converted to a string to be outputed by sqlite3_get_table()? Or any hint on how to track the problem? Note: I copied the database file to my PC and the value stored there is 2.55, so the problem is retrieving the value on the device. I have no solution to offer and you probably thought of it yourseld too, but the + might be an attempt (rather superfluous and annoying) to indicate upward rounding took place. Does this happen with an ordinary C program too? The culprit would be the printf() family as implemented on the platform. Can scanf() read this type of numbers? Regards, Arjen DISCLAIMER: This message is intended exclusively for the addressee(s) and may contain confidential and privileged information. If you are not the intended recipient please notify the sender immediately and destroy this message. Unauthorized use, disclosure or copying of this message is strictly prohibited. The foundation 'Stichting Deltares', which has its seat at Delft, The Netherlands, Commercial Registration Number 41146461, is not liable in any way whatsoever for consequences and/or damages resulting from the improper, incomplete and untimely dispatch, receipt and/or content of this e-mail. __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile
Hello Ali, I've done years ago, it's pretty much standard use. What do you want to do ? On 31 May 2013 10:19, Ali Dirik explore...@gmail.com wrote: Dear Friends, I want to develop a application that runs Windows CE or Mobile devices. I want to use the Sqlite database. May I find same sample source codes? Best Regards Ali D i rik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile
I've used C++, do you want to use anything else. It's of course easier in C++ since sqlite is in C. You link statically, nothing to install. On 31 May 2013 12:21, fnoyan...@yahoo.com wrote: This is the first shot from google http://sqlite-wince.sourceforge.net/index.html If you'd like to use sqlitecin your app, I do not think it will be an issue for any playform once you have the proper C compiler. You may try to statically compiling your application. On 31/05/2013, at 7:42 PM, Ali Dirik explore...@gmail.com wrote: Hello Noel Frankinet, Thank you for your answer. I using a hand-held terminal ( http://www.ute.com/products_info.php?pc1=1pc2=3rbu=0pid=703) with windows mobile operating system. We use this device for counting. There is already an application that works with SQLCE (Microsoft SQL Compact Edition) I want to use SQLite instead of SQL CE. I found a sample source code on the Internet ( http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application ) I've tried it, but did not succeed source code. Do you have any idea about this? Best Regards Ali Dirik 2013/5/31 Ali Dirik explore...@gmail.com Dear Friends, I want to develop a application that runs Windows CE or Mobile devices. I want to use the Sqlite database. May I find same sample source codes? Best Regards Ali D i rik -- İyi Çalışmalar Ali DİRİK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile
ah, sorry, I will never understand why everybody wants to add a virtual machine on an already feeble machine. Then you will have to deal wil a extra layer of complexity ( you need a assembly that will translate from managed code to unmanaged). You will probably have to compile it yourself, since its probably an arm CPU. Good luck ! On 31 May 2013 13:16, Ali Dirik explore...@gmail.com wrote: Thanks for answers. I use c# (VS2008) I am looking for c# sample source code. 2013/5/31 Noel Frankinet noel.franki...@gmail.com I've used C++, do you want to use anything else. It's of course easier in C++ since sqlite is in C. You link statically, nothing to install. On 31 May 2013 12:21, fnoyan...@yahoo.com wrote: This is the first shot from google http://sqlite-wince.sourceforge.net/index.html If you'd like to use sqlitecin your app, I do not think it will be an issue for any playform once you have the proper C compiler. You may try to statically compiling your application. On 31/05/2013, at 7:42 PM, Ali Dirik explore...@gmail.com wrote: Hello Noel Frankinet, Thank you for your answer. I using a hand-held terminal ( http://www.ute.com/products_info.php?pc1=1pc2=3rbu=0pid=703) with windows mobile operating system. We use this device for counting. There is already an application that works with SQLCE (Microsoft SQL Compact Edition) I want to use SQLite instead of SQL CE. I found a sample source code on the Internet ( http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application ) I've tried it, but did not succeed source code. Do you have any idea about this? Best Regards Ali Dirik 2013/5/31 Ali Dirik explore...@gmail.com Dear Friends, I want to develop a application that runs Windows CE or Mobile devices. I want to use the Sqlite database. May I find same sample source codes? Best Regards Ali D i rik -- İyi Çalışmalar Ali DİRİK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- İyi Çalışmalar Ali DİRİK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile
oh, yes everything in c# then, let's see the performance on an arm cpu ! On 31 May 2013 13:23, Noel Frankinet noel.franki...@gmail.com wrote: ah, sorry, I will never understand why everybody wants to add a virtual machine on an already feeble machine. Then you will have to deal wil a extra layer of complexity ( you need a assembly that will translate from managed code to unmanaged). You will probably have to compile it yourself, since its probably an arm CPU. Good luck ! On 31 May 2013 13:16, Ali Dirik explore...@gmail.com wrote: Thanks for answers. I use c# (VS2008) I am looking for c# sample source code. 2013/5/31 Noel Frankinet noel.franki...@gmail.com I've used C++, do you want to use anything else. It's of course easier in C++ since sqlite is in C. You link statically, nothing to install. On 31 May 2013 12:21, fnoyan...@yahoo.com wrote: This is the first shot from google http://sqlite-wince.sourceforge.net/index.html If you'd like to use sqlitecin your app, I do not think it will be an issue for any playform once you have the proper C compiler. You may try to statically compiling your application. On 31/05/2013, at 7:42 PM, Ali Dirik explore...@gmail.com wrote: Hello Noel Frankinet, Thank you for your answer. I using a hand-held terminal ( http://www.ute.com/products_info.php?pc1=1pc2=3rbu=0pid=703) with windows mobile operating system. We use this device for counting. There is already an application that works with SQLCE (Microsoft SQL Compact Edition) I want to use SQLite instead of SQL CE. I found a sample source code on the Internet ( http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application ) I've tried it, but did not succeed source code. Do you have any idea about this? Best Regards Ali Dirik 2013/5/31 Ali Dirik explore...@gmail.com Dear Friends, I want to develop a application that runs Windows CE or Mobile devices. I want to use the Sqlite database. May I find same sample source codes? Best Regards Ali D i rik -- İyi Çalışmalar Ali DİRİK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- İyi Çalışmalar Ali DİRİK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile
and it's already on year behind the official c sqlite. I wouldn't go that route On 31 May 2013 13:26, Noel Frankinet noel.franki...@gmail.com wrote: oh, yes everything in c# then, let's see the performance on an arm cpu ! On 31 May 2013 13:23, Noel Frankinet noel.franki...@gmail.com wrote: ah, sorry, I will never understand why everybody wants to add a virtual machine on an already feeble machine. Then you will have to deal wil a extra layer of complexity ( you need a assembly that will translate from managed code to unmanaged). You will probably have to compile it yourself, since its probably an arm CPU. Good luck ! On 31 May 2013 13:16, Ali Dirik explore...@gmail.com wrote: Thanks for answers. I use c# (VS2008) I am looking for c# sample source code. 2013/5/31 Noel Frankinet noel.franki...@gmail.com I've used C++, do you want to use anything else. It's of course easier in C++ since sqlite is in C. You link statically, nothing to install. On 31 May 2013 12:21, fnoyan...@yahoo.com wrote: This is the first shot from google http://sqlite-wince.sourceforge.net/index.html If you'd like to use sqlitecin your app, I do not think it will be an issue for any playform once you have the proper C compiler. You may try to statically compiling your application. On 31/05/2013, at 7:42 PM, Ali Dirik explore...@gmail.com wrote: Hello Noel Frankinet, Thank you for your answer. I using a hand-held terminal ( http://www.ute.com/products_info.php?pc1=1pc2=3rbu=0pid=703) with windows mobile operating system. We use this device for counting. There is already an application that works with SQLCE (Microsoft SQL Compact Edition) I want to use SQLite instead of SQL CE. I found a sample source code on the Internet ( http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application ) I've tried it, but did not succeed source code. Do you have any idea about this? Best Regards Ali Dirik 2013/5/31 Ali Dirik explore...@gmail.com Dear Friends, I want to develop a application that runs Windows CE or Mobile devices. I want to use the Sqlite database. May I find same sample source codes? Best Regards Ali D i rik -- İyi Çalışmalar Ali DİRİK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- İyi Çalışmalar Ali DİRİK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 -- Noël Frankinet Strategis sprl 0478/90.92.54 -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile
one last consideration, on android and ios (about the same CPU power), they use sqlite native, nota java translation. Is you application requiring c# in any way ? On 31 May 2013 13:28, Noel Frankinet noel.franki...@gmail.com wrote: and it's already on year behind the official c sqlite. I wouldn't go that route On 31 May 2013 13:26, Noel Frankinet noel.franki...@gmail.com wrote: oh, yes everything in c# then, let's see the performance on an arm cpu ! On 31 May 2013 13:23, Noel Frankinet noel.franki...@gmail.com wrote: ah, sorry, I will never understand why everybody wants to add a virtual machine on an already feeble machine. Then you will have to deal wil a extra layer of complexity ( you need a assembly that will translate from managed code to unmanaged). You will probably have to compile it yourself, since its probably an arm CPU. Good luck ! On 31 May 2013 13:16, Ali Dirik explore...@gmail.com wrote: Thanks for answers. I use c# (VS2008) I am looking for c# sample source code. 2013/5/31 Noel Frankinet noel.franki...@gmail.com I've used C++, do you want to use anything else. It's of course easier in C++ since sqlite is in C. You link statically, nothing to install. On 31 May 2013 12:21, fnoyan...@yahoo.com wrote: This is the first shot from google http://sqlite-wince.sourceforge.net/index.html If you'd like to use sqlitecin your app, I do not think it will be an issue for any playform once you have the proper C compiler. You may try to statically compiling your application. On 31/05/2013, at 7:42 PM, Ali Dirik explore...@gmail.com wrote: Hello Noel Frankinet, Thank you for your answer. I using a hand-held terminal ( http://www.ute.com/products_info.php?pc1=1pc2=3rbu=0pid=703) with windows mobile operating system. We use this device for counting. There is already an application that works with SQLCE (Microsoft SQL Compact Edition) I want to use SQLite instead of SQL CE. I found a sample source code on the Internet ( http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application ) I've tried it, but did not succeed source code. Do you have any idea about this? Best Regards Ali Dirik 2013/5/31 Ali Dirik explore...@gmail.com Dear Friends, I want to develop a application that runs Windows CE or Mobile devices. I want to use the Sqlite database. May I find same sample source codes? Best Regards Ali D i rik -- İyi Çalışmalar Ali DİRİK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- İyi Çalışmalar Ali DİRİK ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 -- Noël Frankinet Strategis sprl 0478/90.92.54 -- Noël Frankinet Strategis sprl 0478/90.92.54 -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite Sample Source Codes For Windows CE/Mobile
it's different (not the sqlite engine in c# but just the interface). The interface is up to date, and maintained with the core engine. But the binary is for x86 windows. On 31 May 2013 14:30, Bernd Lehmkuhl be...@web.de wrote: This is not correct. It's up definitely up to date: https://system.data.sqlite.**org/downloads/1.0.86.0/sqlite-** netFx35-binary-PocketPC-ARM-**2008-1.0.86.0.ziphttps://system.data.sqlite.org/downloads/1.0.86.0/sqlite-netFx35-binary-PocketPC-ARM-2008-1.0.86.0.zip Available at: https://system.data.sqlite.**org/index.html/doc/trunk/www/**downloads.wikihttps://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki This binary package contains all the binaries for the PocketPC version of the System.Data.SQLite 1.0.86.0 (3.7.17) package. The .NET Compact Framework 3.5 is required. Am 31.05.2013 13:28, schrieb Noel Frankinet: and it's already on year behind the official c sqlite. I wouldn't go that route On 31 May 2013 13:26, Noel Frankinet noel.franki...@gmail.com wrote: oh, yes everything in c# then, let's see the performance on an arm cpu ! On 31 May 2013 13:23, Noel Frankinet noel.franki...@gmail.com wrote: ah, sorry, I will never understand why everybody wants to add a virtual machine on an already feeble machine. Then you will have to deal wil a extra layer of complexity ( you need a assembly that will translate from managed code to unmanaged). You will probably have to compile it yourself, since its probably an arm CPU. Good luck ! On 31 May 2013 13:16, Ali Dirik explore...@gmail.com wrote: Thanks for answers. I use c# (VS2008) I am looking for c# sample source code. 2013/5/31 Noel Frankinet noel.franki...@gmail.com I've used C++, do you want to use anything else. It's of course easier in C++ since sqlite is in C. You link statically, nothing to install. On 31 May 2013 12:21, fnoyan...@yahoo.com wrote: This is the first shot from google http://sqlite-wince.**sourceforge.net/index.htmlhttp://sqlite-wince.sourceforge.net/index.html If you'd like to use sqlitecin your app, I do not think it will be an issue for any playform once you have the proper C compiler. You may try to statically compiling your application. On 31/05/2013, at 7:42 PM, Ali Dirik explore...@gmail.com wrote: Hello Noel Frankinet, Thank you for your answer. I using a hand-held terminal ( http://www.ute.com/products_**info.php?pc1=1pc2=3rbu=0**pid=703http://www.ute.com/products_info.php?pc1=1pc2=3rbu=0pid=703 ) with windows mobile operating system. We use this device for counting. There is already an application that works with SQLCE (Microsoft SQL Compact Edition) I want to use SQLite instead of SQL CE. I found a sample source code on the Internet ( http://www.codeproject.com/**Articles/22165/Using-SQLite-** in-your-C-Applicationhttp://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application ) I've tried it, but did not succeed source code. Do you have any idea about this? Best Regards Ali Dirik 2013/5/31 Ali Dirik explore...@gmail.com Dear Friends, I want to develop a application that runs Windows CE or Mobile devices. I want to use the Sqlite database. May I find same sample source codes? Best Regards Ali D i rik -- İyi Çalışmalar Ali DİRİK __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- İyi Çalışmalar Ali DİRİK __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 -- Noël Frankinet Strategis sprl 0478/90.92.54 __**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQL Logic error or missing database
Is your filename UTF8 ? On 5 April 2013 15:02, Richard Hipp d...@sqlite.org wrote: On Fri, Apr 5, 2013 at 8:54 AM, Rob Collie rob.col...@gmail.com wrote: Hello there, For my sins, I'm trying to create a library allowing our legacy fortran code to work with SQL. Calling this from fortran... CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue) ...runs the following code, and yet the error returned is 'SQL Logic error or missing database'. No file is ever created. Is there something dumb I'm missing here? extern C { void EXECUTESQL(char *dataBase, char *query, int returnValue) { // Checking the incoming data from FORTRAN CStringW wName(dataBase); MessageBoxW( NULL, wName, LName: , MB_OK ); // Create the object sqlite3 *oDatabase; // Create the error objects char *sErrorMessage; // Open/create the table, if required returnValue = sqlite3_open_v2(dataBase, oDatabase, I think you want just oDatabase, without the prefix operator. SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, ); if (returnValue != SQLITE_OK ) { sqlite3_close(oDatabase); MessageBoxA(NULL, sqlite3_errstr(returnValue), SQL Open Error, MB_OK); return; } Rob. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQL Logic error or missing database
no it should be ok, check the place where testing.db should be created, do you have write right ? On 5 April 2013 15:12, Rob Collie rob.col...@gmail.com wrote: It's a very odd problem. At first I was worried about character translations between fortran and C, but the following also fails: returnValue = sqlite3_open_v2(testing.db, oDatabase, SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, ); I guess this rules out encoding too? Perhaps it's something to do with how the library is being created? I'm pretty much just including sqlite3.h, sqlite3ext.h, sqlite3.c in a C++ project and compiling it as a static lib. Rob. On Fri, Apr 5, 2013 at 3:03 PM, Richard Hipp d...@sqlite.org wrote: On Fri, Apr 5, 2013 at 9:02 AM, Richard Hipp d...@sqlite.org wrote: On Fri, Apr 5, 2013 at 8:54 AM, Rob Collie rob.col...@gmail.com wrote: Hello there, For my sins, I'm trying to create a library allowing our legacy fortran code to work with SQL. Calling this from fortran... CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue) ...runs the following code, and yet the error returned is 'SQL Logic error or missing database'. No file is ever created. Is there something dumb I'm missing here? extern C { void EXECUTESQL(char *dataBase, char *query, int returnValue) { // Checking the incoming data from FORTRAN CStringW wName(dataBase); MessageBoxW( NULL, wName, LName: , MB_OK ); // Create the object sqlite3 *oDatabase; // Create the error objects char *sErrorMessage; // Open/create the table, if required returnValue = sqlite3_open_v2(dataBase, oDatabase, I think you want just oDatabase, without the prefix operator. No. Scratch that. I misread the code. Ignore what I said. I'm going to get coffee now. SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, ); if (returnValue != SQLITE_OK ) { sqlite3_close(oDatabase); MessageBoxA(NULL, sqlite3_errstr(returnValue), SQL Open Error, MB_OK); return; } Rob. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQL Logic error or missing database
SQLITE_OPEN_READWRITEhttp://sqlite.org/capi3ref.html#SQLITE_OPEN_AUTOPROXY The database is opened for reading and writing if possible, or reading only if the file is write protected by the operating system. In either case the database must already exist, otherwise an error is returned. Is it your problem ? On 5 April 2013 15:15, Noel Frankinet noel.franki...@gmail.com wrote: no it should be ok, check the place where testing.db should be created, do you have write right ? On 5 April 2013 15:12, Rob Collie rob.col...@gmail.com wrote: It's a very odd problem. At first I was worried about character translations between fortran and C, but the following also fails: returnValue = sqlite3_open_v2(testing.db, oDatabase, SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, ); I guess this rules out encoding too? Perhaps it's something to do with how the library is being created? I'm pretty much just including sqlite3.h, sqlite3ext.h, sqlite3.c in a C++ project and compiling it as a static lib. Rob. On Fri, Apr 5, 2013 at 3:03 PM, Richard Hipp d...@sqlite.org wrote: On Fri, Apr 5, 2013 at 9:02 AM, Richard Hipp d...@sqlite.org wrote: On Fri, Apr 5, 2013 at 8:54 AM, Rob Collie rob.col...@gmail.com wrote: Hello there, For my sins, I'm trying to create a library allowing our legacy fortran code to work with SQL. Calling this from fortran... CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue) ...runs the following code, and yet the error returned is 'SQL Logic error or missing database'. No file is ever created. Is there something dumb I'm missing here? extern C { void EXECUTESQL(char *dataBase, char *query, int returnValue) { // Checking the incoming data from FORTRAN CStringW wName(dataBase); MessageBoxW( NULL, wName, LName: , MB_OK ); // Create the object sqlite3 *oDatabase; // Create the error objects char *sErrorMessage; // Open/create the table, if required returnValue = sqlite3_open_v2(dataBase, oDatabase, I think you want just oDatabase, without the prefix operator. No. Scratch that. I misread the code. Ignore what I said. I'm going to get coffee now. SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, ); if (returnValue != SQLITE_OK ) { sqlite3_close(oDatabase); MessageBoxA(NULL, sqlite3_errstr(returnValue), SQL Open Error, MB_OK); return; } Rob. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQL Logic error or missing database
something odd, check you compilation setup, are you on windows with visual studio ? create a small console sample On 5 April 2013 15:27, Rob Collie rob.col...@gmail.com wrote: Yeap. I've tested on the desktop, running as an admin user. I've tried the full path, with no luck. Should SQLITE_OPEN_READWRITE not be used with SQLITE_OPEN_CREATE? If I remove the SQLITE_OPEN_READWRITE flag, I get 'library routine called out of sequence' instead. Rob. On Fri, Apr 5, 2013 at 3:15 PM, Noel Frankinet noel.franki...@gmail.com wrote: no it should be ok, check the place where testing.db should be created, do you have write right ? On 5 April 2013 15:12, Rob Collie rob.col...@gmail.com wrote: It's a very odd problem. At first I was worried about character translations between fortran and C, but the following also fails: returnValue = sqlite3_open_v2(testing.db, oDatabase, SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, ); I guess this rules out encoding too? Perhaps it's something to do with how the library is being created? I'm pretty much just including sqlite3.h, sqlite3ext.h, sqlite3.c in a C++ project and compiling it as a static lib. Rob. On Fri, Apr 5, 2013 at 3:03 PM, Richard Hipp d...@sqlite.org wrote: On Fri, Apr 5, 2013 at 9:02 AM, Richard Hipp d...@sqlite.org wrote: On Fri, Apr 5, 2013 at 8:54 AM, Rob Collie rob.col...@gmail.com wrote: Hello there, For my sins, I'm trying to create a library allowing our legacy fortran code to work with SQL. Calling this from fortran... CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue) ...runs the following code, and yet the error returned is 'SQL Logic error or missing database'. No file is ever created. Is there something dumb I'm missing here? extern C { void EXECUTESQL(char *dataBase, char *query, int returnValue) { // Checking the incoming data from FORTRAN CStringW wName(dataBase); MessageBoxW( NULL, wName, LName: , MB_OK ); // Create the object sqlite3 *oDatabase; // Create the error objects char *sErrorMessage; // Open/create the table, if required returnValue = sqlite3_open_v2(dataBase, oDatabase, I think you want just oDatabase, without the prefix operator. No. Scratch that. I misread the code. Ignore what I said. I'm going to get coffee now. SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, ); if (returnValue != SQLITE_OK ) { sqlite3_close(oDatabase); MessageBoxA(NULL, sqlite3_errstr(returnValue), SQL Open Error, MB_OK); return; } Rob. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQL Logic error or missing database
I would remove the file:// On 5 April 2013 16:08, Rob Collie rob.col...@gmail.com wrote: Yeap, I'm on Visual Studio 2012. I've created a console app: sqlite3 *oDatabase; int returnValue; returnValue = sqlite3_open_v2(file://C:/Newfolder/testing.db, oDatabase, SQLITE_OPEN_CREATE, NULL); if (returnValue != SQLITE_OK ) { //sqlite3_close(oDatabase); return returnValue ; } int anyKey; return 0; It returns 21. Checking the other project, the open actually does return 21 too. On Fri, Apr 5, 2013 at 3:36 PM, Michael Black mdblac...@yahoo.com wrote: Also change the last arg of open to NULL instead of . -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Collie Sent: Friday, April 05, 2013 7:54 AM To: sqlite-users@sqlite.org Subject: [sqlite] SQL Logic error or missing database Hello there, For my sins, I'm trying to create a library allowing our legacy fortran code to work with SQL. Calling this from fortran... CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue) ...runs the following code, and yet the error returned is 'SQL Logic error or missing database'. No file is ever created. Is there something dumb I'm missing here? extern C { void EXECUTESQL(char *dataBase, char *query, int returnValue) { // Checking the incoming data from FORTRAN CStringW wName(dataBase); MessageBoxW( NULL, wName, LName: , MB_OK ); // Create the object sqlite3 *oDatabase; // Create the error objects char *sErrorMessage; // Open/create the table, if required returnValue = sqlite3_open_v2(dataBase, oDatabase, SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, ); if (returnValue != SQLITE_OK ) { sqlite3_close(oDatabase); MessageBoxA(NULL, sqlite3_errstr(returnValue), SQL Open Error, MB_OK); return; } Rob. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQL Logic error or missing database
it's time to check your compiler setting, anything weird ? Are you sure you have the source code of sqlite for windows ? 32 or 64 bits settings ?? On 5 April 2013 16:24, Rob Collie rob.col...@gmail.com wrote: Same problem, I'm afraid. I've tried just about every combination suggested in http://www.sqlite.org/c3ref/open.html On Fri, Apr 5, 2013 at 4:18 PM, Kevin Benson kevin.m.ben...@gmail.com wrote: On Fri, Apr 5, 2013 at 10:08 AM, Rob Collie rob.col...@gmail.com wrote: Yeap, I'm on Visual Studio 2012. I've created a console app: sqlite3 *oDatabase; int returnValue; returnValue = sqlite3_open_v2(file://C:/Newfolder/testing.db, oDatabase, SQLITE_OPEN_CREATE, NULL); if (returnValue != SQLITE_OK ) { //sqlite3_close(oDatabase); return returnValue ; } int anyKey; return 0; It returns 21. Checking the other project, the open actually does return 21 too. Three(3) forward slashes for the Internet path style in Windows, maybe? file:///C:/Newfolder/testing.db -- -- -- --Ô¿Ô-- K e V i N ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQL Logic error or missing database
yes that's the setup I use too, so I suspect something more complicated at work (mismatch between h and c file ? check your include path ??) On 5 April 2013 16:29, Michael Black mdblac...@yahoo.com wrote: This works for me under Visual Studio 2010. I couldn't seem to get a file uri to work at all either. #include stdio.h #include sqlite3.h main() { sqlite3 *oDatabase; int returnValue; returnValue = sqlite3_open_v2(D:/SQlite/testing.db, oDatabase, SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, NULL); if (returnValue != SQLITE_OK ) { printf(%d: %s\n,returnValue,sqlite3_errmsg(oDatabase)); } else { printf(Got it\n); } } -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Collie Sent: Friday, April 05, 2013 9:25 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL Logic error or missing database Same problem, I'm afraid. I've tried just about every combination suggested in http://www.sqlite.org/c3ref/open.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Wanted - simple DATA editor for sqlite tables
I once developped a simple table viewer using WTL and windows ListView. Very lighweight and very speedy. Of course it was windows only and read only. I suppose that a modern editable version using Qt would be even easier to develop ? Noël On 25 March 2013 12:41, c...@isbd.net wrote: Stephen Chrzanowski pontia...@gmail.com wrote: Reading further on, I see that you're looking at end-user. This changes things a bit. Now you're looking at trying to make things user-proof, maintain data integrity (Who said 1one?), validate data, so on and so on. You're probably looking at custom code now. Yes, though the end-user is mostly me so I'm not so fussed about data integrity. It's very simple data, a date, a couple of columns with numbers in and a text column. If it gets confused because I've mis-formatted a date I can simply correct the entry, it doesn't need heavyweight validation. But, if you can trust the user(s), I'd STILL say don't reinvent, but just use a something that is already written. That's exactly where I'm coming from, I'm desperately trying not to re-invent the wheel but all I can find is complete bicycles! :-) I want a simple application with low overheads (i.e. fast to load *and* with no DBMS extras not needed for data entry) and there really don't seem to be any out there. -- Chris Green ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Wanted - simple DATA editor for sqlite tables
Back in the old time there was dbase.I'm always dreaming of a sqlite based dbase. One can be done with tcl + tk sqlite, but I find tcl and tk way too big today. On 25 March 2013 14:17, Simon Slavin slav...@bigfraud.org wrote: On 25 Mar 2013, at 11:35am, c...@isbd.net wrote: I don't want to load/use a DBMS *when I'm editing the data*. Of course a database management program is an excellent tool for managing the database, but they're generally rubbish at making it easy to enter data into the database. Yeah, there seems to be that problem with database editors. They start off as little data editing utilities. Then the authors add more features and them more features, until you have to pick 'editing' and an editing mode before you can do what the application was originally for. Which is what you're trying to avoid. I ended up writing my own in JavaScript/PHP. But you need to be a programmer to do that. And my own editor is custom-designed for the way my databases work so it's not suitable for wide publication. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to write store-procedure in SQLite.net
Hello, I think that sqlite does not support stored procedure, but it does support triggers. Noël On 25 March 2013 07:05, Moumita Banerjee mouban1...@gmail.com wrote: Hi, I am trying to write a store-procedure in SQLite.net , but I am unable to do so. Please help me solve this problem. Thanks, Moumita ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Which C++ data structures might one use to cache a sqlite query result?
a two dimensional array, a vector of vectors ? On 24 January 2013 16:46, Cory Nelson phro...@gmail.com wrote: On Thu, Jan 24, 2013 at 9:31 AM, Frank Chang frankchan...@gmail.com wrote: Could anyone suggest which C++ data structure to use to cache a sqlite query result? Thank you for your help This is too vague, you'll need to provide more information. What have you tried so far? -- Cory Nelson http://int64.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?
It's probably a good way to get something working, but you loose the cross-platform On 10 December 2012 14:47, Gilles Ganault gilles.gana...@free.fr wrote: On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin slav...@bigfraud.org wrote: There are lots of people who manipulate data that way, but they tend to export their data from the SQLite database into their favourite spreadsheet app, do the manipulation there, then reimport to SQLite. This prevents them from having to use an app which doesn't have all the facilities they expect from their spreadsheet app. The SQLite shell tool (free) makes the export and import processes easy (can be done in one command). I'll see if there's a good datagrid + SQLite connector for .Net so I can combine the two and see how it goes. Thanks all. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?
Lets agree to disagree, sqlite is completely cross-plaform. You could develop a cross plate-form solution in the same time (Qt or Tcl/tk). The 95% market does not hold if you think smart-phone and tablet (a good target for a simple data entry application). If you only want windows, why not uuse Access in the first place? But anyway... On 10 December 2012 15:33, Gilles Ganault gilles.gana...@free.fr wrote: On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet noel.franki...@gmail.com wrote: It's probably a good way to get something working, but you loose the cross-platform I know, but Windows is 95% of the market for end-users, cross-platform is a pain to write, they take longer to load and always look/act funny anyway :-) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VC++ and SQLite
Never use stdafx stuff on open source project. Don't use precompiled header. On 13 November 2012 14:33, Arbol One arbol...@gmail.com wrote: I would also keep this feature, however, in the case of SQLite3 amalgamation, I am really confused. You know how we have to #include the 'stdafx.h' in every declaration file (making it non-portable code), i.e. .c, .cpp, etc., well, I tried doing the same thing with sqlite.c, but VS10 complains about it. What a nightmare Visual Studio is :( Genius might have limitations, but stupidity is no handicap Eat Kosher -Original Message- From: sqlite-users-boun...@sqlite.org [mailto: sqlite-users-boun...@sqlite.org] On Behalf Of John Drescher Sent: Monday, November 12, 2012 7:44 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] VC++ and SQLite On Mon, Nov 12, 2012 at 1:52 PM, Doug Nebeker pa...@poweradmin.com wrote: You might be surprised at the speed increase you see in compile time if you've got large projects. The time isn't lost to CPU as much, but disk I/O time adds up when hitting many hundreds of small (header) files (even with an SSD). This is why I use PCH. Building some of my projects take a long time even on a 12 threaded processor with multiple SSDs. -- John M. Drescher ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VC++ and SQLite
why would you need stdafx.h for sqlite ? what is the added benefit ? On 13 November 2012 14:57, Michael Schlenker m...@contact.de wrote: Am 13.11.2012 14:33, schrieb Arbol One: I would also keep this feature, however, in the case of SQLite3 amalgamation, I am really confused. You know how we have to #include the 'stdafx.h' in every declaration file (making it non-portable code), i.e. .c, .cpp, etc., well, I tried doing the same thing with sqlite.c, but VS10 complains about it. You can do that without making it non portable by adding /FI to your compile line: http://msdn.microsoft.com/en-us/library/8c5ztk84%28v=vs.71%29.aspx Try /FI stdafx.h Michael What a nightmare Visual Studio is :( Genius might have limitations, but stupidity is no handicap Eat Kosher -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Drescher Sent: Monday, November 12, 2012 7:44 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] VC++ and SQLite On Mon, Nov 12, 2012 at 1:52 PM, Doug Nebeker pa...@poweradmin.com wrote: You might be surprised at the speed increase you see in compile time if you've got large projects. The time isn't lost to CPU as much, but disk I/O time adds up when hitting many hundreds of small (header) files (even with an SSD). This is why I use PCH. Building some of my projects take a long time even on a 12 threaded processor with multiple SSDs. -- John M. Drescher ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VC++ and SQLite
Remove use precompiled header from your configuration. On 10 November 2012 14:11, Arbol One arbol...@gmail.com wrote: I know this question is not a SQLite question, but I am hoping that someone here has had a similar experience and/or can point me to the right place to ask this question. After years or using Code::Blocks and Dev-Cpp, I have recently installed Visual Studio 10 Express; it is the first time I am using it, in my Windows 7 machine. I have written, with the help of this mailing list a wrapper class for the latest SQLite3 library using C::B as my development platform, now that I want to switch to VS10, there were a lot of gcc specific code that I had to repair and after clearing all the C++ discrepancies between MinGW's g++ and MS's VC++ I have been left with this error message: fatal error C1853: 'Debug\sql.pch' precompiled header file is from a previous version of the compiler, or the precompiled header is C++ and you are using it from C (or vice versa Does anyone know how to resolve this issue or perhaps a VS10 specific mailing list to address this question? TIA. This e-mail is for the sole use of the intended recipient and may contain confidential or privileged information. Unauthorized use of its contents is prohibited. If you have received this e-mail in error, please notify sender immediately via return e-mail and then delete the original e-mail. Let there come out of you a group of people inviting to all that is good, enjoining what is right, and to strive against what is wrong: They are the ones to attain respect and admiration, i.e. FSF, GTK+, *NIX, SQLite... etc. Eat Kosher http://www.hanefesh.com/edu/kosher_Food_Symbols.htm#USAD:DocumentsDownloadedInstallations ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Noël Frankinet Strategis sprl 0478/90.92.54 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite Windows 2000
Roger Binns a écrit : But in fact sqlite runs perfectly fine on windows2000 and is compilable with any free compiler (mingw for instance) Best regards Noël Frankinet -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/05/2010 12:01 AM, Frank Church wrote: and Windows 2000. Mainstream support ended 5 years ago, and all support ends in just over a month, no matter how much money anyone is prepared to throw at them: http://support.microsoft.com/lifecycle/?LN=en-usx=7y=6p1=3071 You haven't said how it fails. A correctly installed and maintained system should be just fine. A system with other 3rd party software on it is especially likely to have experienced the dll being overwritten. http://en.wikipedia.org/wiki/Microsoft_Windows_library_files#Msvcrt.dll I don't have my own Windows 2000 system to test it with. It is generally a good idea to have an MSDN subscription as you then have access to the operating systems for development and testing. http://msdn.microsoft.com/en-us/subscriptions/subscriptionschart.aspx Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkwKAqYACgkQmOOfHg372QQAbwCfb1fdVgPFt0fO96KmjgVk1xzr RbMAnRZVgil2oHZAXemL2JgxsebuAi2z =LCfX -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite Windows 2000
Roger Binns a écrit : -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/05/2010 04:21 AM, noel frankinet wrote: But in fact sqlite runs perfectly fine on windows2000 Exactly as my second paragraph says. But in the Windows 2000 time frame applications used to install their own copies of msvcrt.dll in the system directories which means one broken application is all it takes to screw that up. But when the operating system vendor no longer supports a platform it is increasingly pointless for a software person to continue support. At some point you have to call it quits. (For example see who still supports Windows 95, MacOS 7 or Redhat Linux 3.) I see windows 2000 as the finest os that redmont has produced. You'd better not develop on the latest ms os if you want to have some installed base. and is compilable with any free compiler (mingw for instance) You are mixing multiple things up. There are two different issues: source compatibility and binary compatibility. SQLite does compile with pretty much any C compiler out there (source compatibility). Binary compatibility is a bit more tricky. The compiler links SQLite against system libraries that provide underlying functionality such as file access, memory allocation etc. What happens is compiler and platform specific. In general the resulting SQLite works with that version of the operating system and any version going forward but not older ones. In the case of Microsoft, they have been distributing the C libraries with the compilers not the operating system and been numbering the C library as part of the file name. Additionally various data structures (eg stdio) have changed between library versions and having multiple versions of the C library used in the same process is a recipe for problems. Applications should be putting the C libraries in their own directories and not system locations. msvcrt.dll (with no numbers) is a special case and is in system directories and in theory is for the use of operating system applications only. Because of that pervasiveness MinGW targets it as the C library. In fact they claim to support no other version, although their compiled DLLs do work with other versions in my experience. I did not know that mingw was using msvcrt.dll. But anyway, its there, in system directory, so it should run fine. BTW I believe the distributed SQLite Windows DLL is actually produced by a gcc cross compiler on Linux, which you could label MinGW as well. Yes I think so too. Best regards Noël Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkwKZMsACgkQmOOfHg372QRYyQCgsOpimyfGUtV83mEbqgEhS1+7 nAoAnR7r+vi6qb2WgiY1Z4zGfQbo2ZSK =DImh -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is the absence of msvcrt.dll a known issue with SQLite Windows 2000
Roger Binns a écrit : -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/05/2010 08:20 AM, noel frankinet wrote: I see windows 2000 as the finest os that redmont has produced. You'd better not develop on the latest ms os if you want to have some installed base. Your opinion is fine, but someone has to bear the burden of supporting increasingly outdated operating systems. For example I have a Mac running OSX 10.3. The open source software I use (eg Firefox and Emacs) do not run on it anymore because they were not willing to bear that burden. And pretty much no one supports Windows 98 these days for the same reason. Yes, but its a pity(windows 98 is another problem). I still use windows 2000 as my base point. I test on xp after that (but I progress, before it was watcom c++ and dos extender). I did not know that mingw was using msvcrt.dll. But anyway, its there, in system directory, so it should run fine. The thing you missed is that there is no one msvcrt.dll. There was one version shipped with the operating system, then updated versions with new functionality and bug fixes shipped with Microsoft compilers, service packs and other updates. On install applications were placing whatever versions they wanted into the system directory and not necessarily doing that right. This is why it is possible for SQLite3.dll to work just fine on one system but not another. Yes I understand that. With XP the dll became a protected system file and Windows went to great lengths to ensure that any installer futzing with it would have the actions reversed. Microsoft also started numbering the dll shipped with the C compiler, and said applications should install the dll in their program directory (which is searched first before system directories). They also introduced sxs where the system managed multiple versions of dlls and that whole mess. Yes I've seen that, and also exe that don't run because of double dependency http://en.wikipedia.org/wiki/Side-by-side_assembly Consequently XP and later systems are far less likely to have problems with incorrect msvcrt.dll. My experience is the reverse, but luck maybe. Anyway thank you for your info, I wish you would have been there when I was pulling my hair with side by side assembly issue Noël Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkwKhmIACgkQmOOfHg372QSszgCg4m6GBuZlfb6kVx4u32WHibAU GcAAniDiHqlOfkDRrJGEuecucH73Umja =2OwY -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about using SQLite3 on Windows Mobile 6+
Anthony Papillion a écrit : Hello Anthony, Your windows Mobile device has a Arm processor, you will need to recompile sqlite.dll for that processor (with evc3+evc4 or visual studio 2005/2008) Best wishes Noël Frankinet Hello Everyone, I'm totally new to SQLite and am trying to use it in a new Windows Mobile application. I've downloaded the SQLite3.dll and went to my project and tried to add a reference to the dll. For some reason, when I try to add the reference, I am told A reference to sqlite3.dll could not be added with no further information. I've been searching Google for a while and can't find a resolution so I'm hoping someone can help me out. Thanks a lot! Anthony Papillion OpenEMR HQ, Inc. www.openemrhq.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite compile error
Gary Zigmann a écrit : Hello, Since sqlite is a library, could you show us your main program, in order to help you ? Best wishes Noël Frankinet Good Afternoon, Today I downloaded sqlite-amalgamation-3_6_22.zip from the sqlite.org website because I was looking for a SQL database to replace MS Access on my machine. I compiled sqlite3.c using a c compiler and came up with this error: [Linker error] undefined reference to `winm...@16' Can you help me? Thanks, Gary Zigmann, MBA Clinical Data Analyst Gifford Medical Center gzigm...@giffordmed.org This information is confidential. If you are not the intended recipient, delete this e-mail and any attachments without forwarding it or retaining a copy. To try to obtain permission to use this transmission or to notify the sender of the error, call (802) 728-2135 or e-mail gzigm...@giffordmed.org. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Need help understanding the basic of C++/sqlite
Fabrice NA a écrit : Hi, In sqlite3_exec, you pass a function pointer (callback). Sqlite call that function with each row of data Best wishes Noël Hi all, I am trying to understand Sqlite and to make thing worse I am also learning C++. You will not be surprised that I find it really hard to understand the C++ example on the web. Can someone guide me to digest this? If you can explain please do so by extrapolating since I am a total newbie. I have managed to compile the code example into a file called testdb.exe and have created a database named Cars.db containing 7 rows. (notice that I have removed some part of that code that I don't need help for) #include stdio.h #include sqlite3.h static int callback(void *NotUsed, int argc, char **argv, char **azColName){ int i; for(i=0; iargc; i++){ printf(%s = %s\n, azColName[i], argv[i] ? argv[i] : NULL); } printf(\n); return 0; } int main(int argc, char **argv){ sqlite3 *db; char *zErrMsg = 0; int rc; if( argc!=3 ){ fprintf(stderr, Usage: %s DATABASE SQL-STATEMENT\n, argv[0]); exit(1); } rc = sqlite3_open(argv[1], db); rc = sqlite3_exec(db, argv[2], callback, 0, zErrMsg); sqlite3_close(db); return 0; } Now in command line when I execute testdb.exe cars.db select * from cars (the table is called cars too) everything works fine and I get an output with all my seven rows. But how come this work? Is this some kind of magic? Even after reading the doc again and again I don't understand (probably because I am still learning some basic C++ concepts). Here my questions; 1) What is the purpose of doing sqlite3 *db are we just creating a pointer of type sqlite3 named db here? 2) At first I though that for the main function the first parameter cars.db was represented by the variable argc and the second select * from cars by argv. Well at the end, it looks like that cars.db is argv[1] and that the select statement is argv[2]. What is argc then? Seems like it's the number of rows returned by the query (when looking at function callback) but how the program find this out? How come we have a line if( argc!=3 ) and see this same argc variable in the callback function? 3) I don't understand the third argument from the query rc = sqlite3_exec(db, argv[2], callback, 0, zErrMsg); my problem is understanding the callback function inside the sqlite3_exec function. Reading this link http://www.sqlite.org/c3ref/exec.html didn't help too much even though it has been written in plain English. 4) I am using VC++ Express from Microsoft on WinXP and would like to know if it's possible to pass parameter when debugging i.e. tell the debugger to use cars.db for file and use select * from cars as a statement (this would allow me to see what's hapening witout replacing variables by their real values). 5) It's really hard to find some simple example on internet about C++ working with sqlite. Can any of you provide with simple sample codes that shows how you can do and what you can do with sqlite and C++? I hope I didn't offended anyone with my lack of knowledge and I thank in advance the courageous ones who managed to read this email until the end and probably got answers to my questions. Fabou ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Quick question:
S B a écrit : Pocket PC use a arm/xscale processor, not a x86.The os is also differnet (windowsCE vs win32). A recompile is needed with the right tool (evc3, evc4 of visual studio 2005/2007). Best wishes Noël Jason, Chances are you will have to compile it for CE. I imagine it uses a different compiler/SDK than standard XP. Use the amalgamated version of the source - it's very easy. SB On Mon, Jan 5, 2009 at 1:28 PM, jason young jason.yo...@motoman.com wrote: Quick question: Can anyone tell me what is involved with getting a WinCE 5.0 executable that I can do some testing and development with. I tried to take the Windows executable on the download page and run it on CE but it failed claiming that it could not SQLite3 (or one of its components). FYI, I can get the same executable to run on my XP machine. Please help me understand what I'm doing wrong. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] wtl list view article on codeproject
Hello, I've written a small article to show how to connect sqlite to a wtl listview on windows. http://www.codeproject.com/KB/list/alphaview.aspx I hope it will help somebody Best wishes Noël Frankinet ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [newbie] Compiling for Windows CE
David Stephenson a écrit : Hi, I'm trying to compile 3.5.9 to Windows CE using embedded C++ 4.0 and I get the following error: Hello David, You probably should compile for a console project ( or a dll it depends) Noël corelibc.lib(pegwmain.obj) : error LNK2019: unresolved external symbol _WinMain referenced in function _WinMainCRTStartup How can I resolve this? David ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] rtree extension - Windows Binary?
Griggs, Donald a écrit : Hi Andrew, Maybe this goes without saying, but I guess you've already worked on the usual suspects such as: -- An index for Lat and another for Lon. -- Larger cache -- EXPLAIN QUERY PLAN prefix to ensure that index used -- One-time VACUUM has any effect? -- ANALYZE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Brampton Sent: Friday, June 13, 2008 11:52 AM To: sqlite-users@sqlite.org Subject: [sqlite] rtree extension - Windows Binary? Hi, I've recently created a database with latitude/longitude points in it, and now I need to search for points without a given rectangle. With 60,000 points I'm able to retrieve a rectangle of 50 points in ~1 second. This is way too slow, so I wanted to try out the rtree extension. However at the moment I'm unable to compile it, so I was wondering if anyone had a DLL for windows which I could use. I am using PHP 5.x to access my SQLite database, so the extension must be compatible with the sqlite included with that. What do you use to compile, I just added rtree.c to my vc6 project and it compiled right away. I've not tested it yet, however :-{ Best wishes Noël Would anyone be able to give me such a DLL? Also is there a good write up on how to use this extension? I've been following the mailing list, but another source would be helpful. thanks Andrew ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Thank you
D. Richard Hipp a écrit : I'd like to take credit for the new r-tree module because it is a fine piece of work. But in truth the new r-tree module was written entirely by Dan Kennedy. http://www.sqlite.org/crew.html Good job, Dan! D. Richard Hipp [EMAIL PROTECTED] Thank you to Dan and Richard then, Very fine work indeed, thanks a lot, it complete the spatialite project quite nicely. Noël Frankinet ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Please test lastest CVS using WinCE
[EMAIL PROTECTED] a écrit : Can somebody with the ability to compile and test for wince please test check-in [4802] for me. http://www.sqlite.org/cvstrac/chngview?cn=4802 For that matter, is there anybody out there who would like to become the official wince maintainer for SQLite? If you are able to compile, test, and debug SQLite for wince and would like to take on this task, we will be happy to welcome you to the official SQLite development team. Benefits include: * CVS check-in privileges * Access to the private SQLite developers chatroom * A prestigious [EMAIL PROTECTED] email alias * Praise and admiration from your peers -- D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Hello, I am ready to help if you want. I develop a GIS package on pocketPC and windows, It use sqlite quite well. Best regards Noël Frankinet ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] what platforms does SQLite run on?
Sam Carleton a écrit : I see that SQLite runs on Windows, OSX, and *NIX, will it run on Windows Mobile (CE) or any embedded OS's? It runs on any CE that I know Noel Sam ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQlite in PDA with Windows CE
Jorge Rodríguez Pedrianes a écrit : Hello, Anybody Knowk to use sqlite embeden in a PDA??, I saw that i can download a .dll to windows, but can I use this dll in PDA? I saw the documentation but don't find anything about this. Anybody can I help me?? Thanks!!! _ Tecnología, moda, motor, viajes,…suscríbete a nuestros boletines para estar siempre a la última http://newsletters.msn.com/hm/maintenanceeses.asp?L=ESC=ESP=WCMaintenanceBrand=WLRU=http%3a%2f%2fmail.live.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.17.4/1189 - Release Date: 18/12/2007 21:40 Hello, No you cannot use sqlite3.dll on a pda, you need to recompile with a arm compiler. (evc3 or evc4 are free for instance). Best wishes. Noël - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Script Language
Cesar Rodas a écrit : I am planning to develop a interpreted language with LEMON FLEX. The main goal is to provide a easy way to script commons actions, and to teach algorithm in my University (National University of Asuncion - Paraguay). The language have syntax as PHP and Python I am planning to create a SQLite support in the core, for teach SQL too. Is any one instresting to help in this project? Thanks to all. PD: The language doesn't have a name jet, and will be Public Domain. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date: 8/03/2007 10:58 Hello Cesar, I am interested in the inner working of LEMON, so I am ready to help (I know tcl and Lua, but I never have devlopped an interpretor). Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Script Language
Cesar Rodas a écrit : Your help will be welcome. On 09/03/07, Noel Frankinet [EMAIL PROTECTED] wrote: Cesar Rodas a écrit : I am planning to develop a interpreted language with LEMON FLEX. The main goal is to provide a easy way to script commons actions, and to teach algorithm in my University (National University of Asuncion - Paraguay). The language have syntax as PHP and Python I am planning to create a SQLite support in the core, for teach SQL too. Is any one instresting to help in this project? Thanks to all. PD: The language doesn't have a name jet, and will be Public Domain. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date: 8/03/2007 10:58 Hello Cesar, I am interested in the inner working of LEMON, so I am ready to help (I know tcl and Lua, but I never have devlopped an interpretor). Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] - No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date: 8/03/2007 10:58 Just tell me what you expect from me. Do you have a description of the language ( a grammar ?), is it object based, object orientated or just procedural. Do you want to implement it in pure C or a mixture of C and C++. Is SQL a part of the language ? -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite GUI app that offers layouts
COS a écrit : Hi Tom, - Original Message - From: TB [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Tuesday, October 17, 2006 9:47 PM Subject: [sqlite] SQLite GUI app that offers layouts Hi all, There seem to be several SQLite GUI apps around. But I haven't seen any that offer building of layouts, ie positioning test frames for fields on a page for form data entry or printing. This feature is typical of proprietary apps such as FileMaker, AppleWorks, 4D etc. Anyone know of a GUI app that offers layouts (ie form creation), especially on a Mac (but even other platforms)? DBManager Enterprise Edition (http://www.dbtools.com.br/EN/dbmanagerpro) can do that. It has a form designer which allows to create and execute forms like MSAccess does. This manager is for windows only and there is a TRIAL Edition which you can test and see how it works. Is there a conventional way to store the layout information in the SQLite database itself, so it can be moved from one SQLite GUI app to another, and retain compatible forms? I doubt you will find something like. Usually the form is handled only by the GUI which created it. For example, you can't execute MSAcess forms on any other GUI. Because of that it doesn't matter if the form is saved in the SQLite DB or not, since most GUI's will not know what to do with it. Hope that helps, COS - To unsubscribe, send email to [EMAIL PROTECTED] - Hello Tom, With my NGUI (http://www.gistek.net/ngui.htm) framework, I define a form layout in XML and the form behavior (on events) in lua. That info can be stored in a sqlite table and a registered sqlite command could create the form on the fly, populate it and wait for user input. My framework in win32/windowsCE (pda) only, but I suppose the same could be done with gtk or Qt. Lua fits well with sqlite because its very compact Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite GUI app that offers layouts
Sorry, the correct url is : http://www.gistek.net/gui.html -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite GUI app that offers layouts
.02$ Interesting, but I'm wondering why not use the tcl/tk binding to simply generate the forms using the well crafted tcl binding which comes with the SQLite language? Tcl/TK is a very simple scripting language which is portable to all major platforms, has a very useful GUI widget set, and while it might not be the prettiest interface in the world, getting very useable forms up and running using sqlite/tk is trivial. /.02$ - To unsubscribe, send email to [EMAIL PROTECTED] - yes, tcl/tk is another option, I used to use it a lot. However tcl/tk is a little bit fat(6Mb), you need zillion of extension to get a good looking gui and there is no object support in the core. Lua is less than 300k, ngui also, so we are not playing in the same category. -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite GUI app that offers layouts
Rich Shepard a écrit : On Wed, 18 Oct 2006, Rob Sciuk wrote: Interesting, but I'm wondering why not use the tcl/tk binding to simply generate the forms using the well crafted tcl binding which comes with the SQLite language? Tcl/TK is a very simple scripting language which is portable to all major platforms, has a very useful GUI widget set, and while it might not be the prettiest interface in the world, getting very useable forms up and running using sqlite/tk is trivial. /.02$ Alternative #3: write your application in python and use the wxPython widget set. This combination is portable across OSes and uses the native widgets so the look and feel is consistent. Rich Alternative #4 : write your application in lua and use IUP widgets set. This combination is portable across OSes and uses the native widgets so the look and feel is consistent but the size is 10 time smaller. -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQLite GUI app that offers layouts
Rob Sciuk a écrit : On Wed, 18 Oct 2006, Rich Shepard wrote: Rob, And, ... there's pysqlite2 which is a teriffic implementation of the python database API. I'm using python, wxPython, and pysqlite2 in our approximate reasoning models. It's a nice system. Rich So many scripting languages, and so little time. Noel is making a valiant case for Lua/IUP widgets, though I'm only vaguely aware of that language. What was that link again? htpp://www.lua.org http://luaforge.net/projects/iup/ thinking about it, storing xml (or generating xml on the fly from a registered sqlite command) seems better than generating tcl/python/lua whatever code ? Its also easy to send/receive remotely. My NGUI controls accept xml directly, so you can feed them from sqlite without additional step. Anyway, there's always some tradeoff (size, speed, portability)... Best wishes. -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] contains function
Dennis Cote a écrit : Noel Frankinet wrote: I would like to create a user function to know if a record is contained in a rectangle ? If have looked to sqlite_create_function I know that my record has for column (xmin,ymin,xmax,ymax) I would like to use the new function to write something like select * from table where ??? contains (how I pass the selecting rectangle) Is it possible ? How do I do that ? Thank you Noel, You need to create a predicate function that returns a boolean or integer (0 or 1) value based on 6 input values. Conceptually it would look like this: int point_in_rect(px, py, rxl, rxh, ryl, ryh) Where px and py are the location of a point, rxl and rxh are the low and high limits of the rectangle's x dimension, and ryl and ryh are the low and high limits of the rectangle's y dimension. You would use this function like this: create table points(x int, y int, data text); select * from points where point_in_rect(x, y, 10, 100, 25, 75); This should give you an idea of how to implement it using the sqlite APIs. /* implement point in rect predicate function */ void point_in_rect(sqlite3_context* ctx, int argc, sqlite3_value** argv) { int p, rl, rh, in = 0; /* check x values first */ p = sqlite3_value_int(argv[0]); rl = sqlite3_value_int(argv[2]); rh = sqlite3_value_int(argv[3]); if (p = rl p =rh) { /* now check y values */ p = sqlite3_value_int(argv[1]); rl = sqlite3_value_int(argv[4]); rh = sqlite3_value_int(argv[5]); if (p = rl p = rh) in = 1; } sqlite3_result_int(ctx, in); } /* register point in rect predicate */ sqlite3* db; rc = sqlite3_create_function(db, point_in_rect, 6, SQLITE_UTF8, NULL, point_in_rect, NULL, NULL); HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] - Very good Denis, That' what I was looking for; but had some problem wrapping my head around it. Thanks a lot Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Wish to store a C structure in sqlite column
Narendran a écrit : Noel Frankinet wrote: Narendran a écrit : Dear Friends, I am in the process of forming a Generic API,(sql oriented and BerkelyDB and sister databases). In the process of integration ,i like to store a Structure in Sqlite. as far as my knowledge SQLITE allows me to declare the column types suppoted by the programming languare or say i am using blob . My requirement is i wish to store a structure in the SQLite column. I am unable to form a sql statement to store the structure ,i am also not clear with whether i can have a strucure as column type. suggestions will be really helpful. Thanking you, B.Narendran You will need to turn your c struct into a blob and store that blob. When retrieving the blob, you need a way to turn it back into your struct. Its releatively easy if your struct does not contains pointers. Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] - Dear Frankinet, Thanks for ur reply, I am unable to understand what u have said. I am having a structure and I am converting in to a blob. This means i am supposed to remove the '\0' in between the strucure and put a final '\0' (NULL) character . Blob need only on e null character to terminate it. I tried to memcopy the structure elements and store them ,I can store but i am unable to find a way to retrieve it back. typedef struct ethernetcard1 { char port[10]; char ipaddress[20]; char mask[20]; int bandwidth; } what i tried is char *buffer; int bufferlen;buffersize; bufferlen = strlen(port)+strlen(ipaddress)+strlen(mask)+sizeof(int)+1; memcpy(buffer,user.port,strlen(user.port); buffersize = strlen(user.port); memcpy(buffer,user.ipaddress,strlen(user.ipaddress)); buffersize += strlen(user.ipaddress); and finally i included a NULL character to the buffer to make it as string and i can insert in to a text field in sqlite column . I am unable to figure out a way to retrieve it back if i am storing in this way or a blob type I think blob will be similar to this . expecting ur valuable suggestion. Thanking you, Narendran hello Narendran, Unfortunately, I'm still using 2.xx, so I encode the blob in character using sqlite_encode and I decode it back when I get it from sqlite. You are on the right track, but for string you should have a way to store the length. I have written some encoding function (like write_string and read_string) to help encoding and decoding from the buffer (and avoi all those mesy memcpy). I hope this help Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Wish to store a C structure in sqlite column
Narendran a écrit : thanks a lot, I believe i can store a structure now, but there is still a cache . I am in the process on creating a Independant API,I can store a structure in SQLite thro the above specified ways. what if some one else wants to use my API's which i used to create the DBI's ,and the destination Database engine doesn't support the blob datatypes. My question may be silly, but this is a serious issues for me. I am unable to resolve the problem for 3 days,hat's off to everyone. Thanking you , B.Narendran you can always encode it in text then -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Wish to store a C structure in sqlite column
Narendran a écrit : Dear Friends, I am in the process of forming a Generic API,(sql oriented and BerkelyDB and sister databases). In the process of integration ,i like to store a Structure in Sqlite. as far as my knowledge SQLITE allows me to declare the column types suppoted by the programming languare or say i am using blob . My requirement is i wish to store a structure in the SQLite column. I am unable to form a sql statement to store the structure ,i am also not clear with whether i can have a strucure as column type. suggestions will be really helpful. Thanking you, B.Narendran You will need to turn your c struct into a blob and store that blob. When retrieving the blob, you need a way to turn it back into your struct. Its releatively easy if your struct does not contains pointers. Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Which API to use to get resultant of query
sandhya a écrit : Thanks a lot for your response Actually there is one function call in some sample found like, static int callback(void *NotUsed, int argc, char **argv, char **azColName) { int i; for(i=0; iargc; i++){ printf(%s = %s\n, azColName[i], argv[i] ? argv[i] : NULL); } printf(\n); return 0; } you don't call that callback , its called by sqlite... In your case argc will be 1, argv[0] will contains the oid and azColNames[0] will be oid I reffered Shell.c also where in they also has the same function,If i am not passing my arguments through command prompt... What i should pass as 2 and 3 arguments in the above function call ie argc and argv.Is there any API which directly gives the result. Actually my query is returing only one data ie OID of the fileIn this case what i can do to get that data.Where it will get stored? Please help me...in doing this Thank you Sandhya - Original Message - From: Jay Sprenkle [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Friday, September 15, 2006 7:38 PM Subject: Re: [sqlite] Which API to use to get resultant of query On 9/15/06, sandhya [EMAIL PROTECTED] wrote: sprintf(szQuery,select oid from %s where filename = '%s',sampletbl,test.htm); there's an example program here: http://sqlite.org/quickstart.html and a more involved one here http://www.reddawn.net/~jsprenkl/Sqlite -- -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- - To unsubscribe, send email to [EMAIL PROTECTED] - -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Which API to use to get resultant of query
sandhya a écrit : You mean there is no need for me to take care of this function calls ..Its just enough having definition there. But by doing that i am not getting any kind of output ie my OID. No you should write the callback and do whatever you want with the passed data. You the pass the call_back name to the relevant sqlite function. sqlite will call it for every row selected by your query. - Original Message - From: Noel Frankinet [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Friday, September 15, 2006 8:02 PM Subject: Re: [sqlite] Which API to use to get resultant of query sandhya a écrit : Thanks a lot for your response Actually there is one function call in some sample found like, static int callback(void *NotUsed, int argc, char **argv, char **azColName) { int i; for(i=0; iargc; i++){ printf(%s = %s\n, azColName[i], argv[i] ? argv[i] : NULL); } printf(\n); return 0; } you don't call that callback , its called by sqlite... In your case argc will be 1, argv[0] will contains the oid and azColNames[0] will be oid I reffered Shell.c also where in they also has the same function,If i am not passing my arguments through command prompt... What i should pass as 2 and 3 arguments in the above function call ie argc and argv.Is there any API which directly gives the result. Actually my query is returing only one data ie OID of the fileIn this case what i can do to get that data.Where it will get stored? Please help me...in doing this Thank you Sandhya - Original Message - From: Jay Sprenkle [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Friday, September 15, 2006 7:38 PM Subject: Re: [sqlite] Which API to use to get resultant of query On 9/15/06, sandhya [EMAIL PROTECTED] wrote: sprintf(szQuery,select oid from %s where filename = '%s',sampletbl,test.htm); there's an example program here: http://sqlite.org/quickstart.html and a more involved one here http://www.reddawn.net/~jsprenkl/Sqlite -- -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com - - --- To unsubscribe, send email to [EMAIL PROTECTED] - - --- -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- -- Noël Frankinet Gistek Software SA http://www.gistek.net -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- - To unsubscribe, send email to [EMAIL PROTECTED] - -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] converting a sqlite table to dbf
P Kishor a écrit : Thanks, so the answer is there is no straight-forward way of doing this. I will export to CSV, and then rebuild a dbf using Perl. In case folks wonder why I am going back to the abacus, my data start and end as .dbf. I use SQLite in between to do magic tricks with it. On 8/29/06, Fred Williams [EMAIL PROTECTED] wrote: Kind'a like chucking your Pentium 5 and going back to scratching on the cave wall with a rock, Eh? I'd export the tables to a CVS files using something like SQLiteAdmin.exe. Open the CVS files with Excel and save the resulting spreadsheets as .DBF files (My Excel has a choice of DBASE II through DBASE IV.) Or you could use that block buster database, Access, to do the same. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of P Kishor Sent: Monday, August 28, 2006 11:23 PM To: sqlite-users@sqlite.org Subject: [sqlite] converting a sqlite table to dbf is there any straightforward way for converting a SQLite table to dbf format? Hello, I use shapelib (a libary to read and write gis shape files), the attributes files are dbf files, its in c and it easyling bound to sqlite. Best wishes. -- Noël Frankinet Gistek Software SA http://www.gistek.net - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] VB.Net DataSet DataGrid with ADO.Net Provider
John Newby wrote: Hi, I don't know if you can remember but I was asking for advice on displaying info to the user using a dataset/datagrid, and you said you used a virtual listview. I am currently having loads of trouble using the dataset/datagrid so I was wondering if you could let me know more about your virtual listview please. Also would the virtual listview allow for amendments/deletion/insertion of data and recognise the change and update the database accordingly. Many thanks John On 10/05/06, Noel Frankinet [EMAIL PROTECTED] wrote: John Newby wrote: Hi, I am trying to access a SQLite database using the ADO.Net provider and bring all the data back in a tabular form, I can bring back the data using a datareader but I don't know if I can put the data into a datset or a datagrid. Does anyone know if you can do this? Many thanks. John. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 9/05/2006 Hello, I use a virtual listview directly on top of sqlite3, its in c++ but it works very well (even on PDA). It could easily be turned in an activeX (its ATL/WTL, no MFC). Best wishes. -- Noël Frankinet Gistek Software SA http://www.gistek.net No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.8.4/364 - Release Date: 14/06/2006 Hello, My virtual list is WTL C++ code, it runs on top of a Cdataview class that does all the work. It works on PC and PDA, and yes, beiing virtual, it reflects insert and deletes quite well (a trigger does the Window Updating). I can send you that code (3 .h files) but it won't be free of dependency from other part of my project. I hope to one day make it into a separated project but I don't have the time right now, Are you interested ? Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
[sqlite] external indexing
Hello All, since nobody has answered my last question, I'll try to rephrase it : How do you select record you have the keys (and I mean a lot of keys) I know SELECT .. WHERE rowid= SELECT .. WHERE rowid IN (something like that) SELECT ... WHARE rowid BETWEEN ... Is there another way, does a temporary table helps ? Thank you -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] external indexing
Rusty Conover wrote: Using a temporary table seems to be the best way when you have lots of keys. Of course there is a tradeoff point, such as for 1 or 2 rows a temporary table is overkill. Also it depends on if you're temporary table is being stored in memory or on the disk, check the relevant PRAGMA documentation to specify how you want them stored. CREATE TEMP TABLE search_keys(oid INTEGER NOT NULL PRIMARY KEY); Next, insert all of the records you're searching for into search_keys table. You might want to do an ANALYZE here on the temporary table, so the planner can pick the most efficient way to do the upcoming join depending on the number of rows you're searching for, and the number of rows you're searching in. Do the actual select: SELECT ... from search_keys, target where search_keys.oid = bar.oid I believe the ordering of the tables in the from clause may be important as the planner may use it in determining which table to process first, but if there are statistics about all of the tables it may reorder them. drh, would know actual behavior for sure. Finally don't forget to: DROP TABLE search_keys Cheers, Rusty -- Rusty Conover InfoGears Inc. Web: http://www.infogears.com Hello Rusty, Exactly what I was looking for I've seen the PRAGMA TEMP_STORE to create a memory table. Do you think I can join a memory table and a disk based one ? Anyway, thank a lot Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] SQLite as R data store and spatial data maybe ?
[EMAIL PROTECTED] wrote: Noel Frankinet [EMAIL PROTECTED] wrote: You might want to take a look at DRH's proposal, http://www.sqlite.org/cvstrac/wiki?p=VirtualTables which looks like it would make it easier for the R community to implement the sort of interface you're talking about. I've read the proposed virtualTable schema. Mr Hipp could you elaborate on how you envision spatial indexing ? I've not thought about it. The VirtualTable proposal was developped to support full-text search and as something to replace the (goofy) pragmas currently used to find schema information. I would imagine that virtualtables would also be useful for spatial indexing, but I have not looked closely into the matter. -- D. Richard Hipp [EMAIL PROTECTED] Thank you for your reply, I suppose that whatever indexing technique, it boils down to I have that bunch of keys please return the corresponding records. I can then use IN or BETWEEN statement, but I suspect that a UNION between a TABLE(query_quadtree(interesting_window)) (is this a virtual table?) and my target table would do better. Am I right ? maybe a little bit confused ? Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] SQLite as R data store and spatial data maybe ?
Eric Bohlman wrote: Andrew Piskorski wrote: As an R user, I'm happy to see the project below, it could become a very handy use of SQLite. I suspect it's well out of scope for that project, but it would be particularly cool to eventually see some of the integration go the other way, and allow use of SQLite's SQL engine to manipulate R data frames (which are tables, basically) from within R, as that would be much more powerful than R's rather limited set of data frame manipulation functions. You might want to take a look at DRH's proposal, http://www.sqlite.org/cvstrac/wiki?p=VirtualTables which looks like it would make it easier for the R community to implement the sort of interface you're talking about. Hello all, I've read the proposed virtualTable schema. Mr Hipp could you elaborate on how you envision spatial indexing ? I now construct a in memory quadtree of my spatial structure, so that I get a set of key when I do a window query. I suppose now that I need to create a temporary table of thoses key and then do a kind of union between this table and my target geometry+attributes table. How would a virtual table help that process ? Thank you -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: AW: [sqlite] Re: spatial sqlite anyone ?
Martin Pfeifle wrote: Hi, I think the simplest solution would be to put a spatial index on top of the B-tree, that's what e.g. Oracle does in their Spatial Cartridge. Basically you store the index data in relations and index these relations by B-trees. In this case, you do not have to change the core code of SQLite. You can already do this now. Nevertheless, it would be nice, if SQlite supports somehow the extensible indexing interface. So, you ask a spatial query and in the background the system uses the index data stored in relations. We have done a lot of research on that topic. To get acquainted to the basic idea, you might have a look at The Paradigm of Relational Indexing: A Survey. In my opinion, a direct integration of a spatial index is of course preferable, but who is going to do that? Best Martin Hello Martin, hello All, Thank you for the above link, it is very useful. I definitely want to go the spatial index map to btree index way. I especially like the quad-tree select because I understand it and I already have most of the building blocks : SELECT DISTINCT idx.id FROM polygons_quadtree idx, TABLE(ZDecompose(BOX()) titles, Table(ZupperHull(tiles.zval)) uh WHERE (idx.zval BETWEEN tiles.zval AND ZHi(tiles.zval)) OR (idx.zval = uh.zval); Well almost, I know how to make ZDecompose, I still not sure about ZHi, ZUpperHul, do you have any more pointers ? I didn't konw the TABLE statement to return a pseudo table, unfortunately, it seems not available in sqlite, can it be emulated by a transient memory table ? Do you think that such a complex statement has any chance to be speedier than a simple bbox elimination ? Thanks again, Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: AW: AW: [sqlite] Re: spatial sqlite anyone ?
Martin Pfeifle wrote: Hello Noel, I think you can find more information on the computation of the upper hull values in [FFS00] Implementing Geospatial Operations in an Object-Relational Database System. Yes I'm already reading that. For testing, we used oracle, where we had transient tables. I am not sure whether we have transient memory tables in SQLite. If yes, you can use them. I think sqlite has it The simple box elimination always goes along with a full table scan. Assume you have the polygons of complete Europe in your database and you do a selective spatial query, you still have to evaluate all bounding boxes of all polygons. In that case a hierarchical organization of the data, e.g. by the Relational Quadtree or the Relational R-tree, is certainly much more efficient. If you always select let's say more than 10% of all polygons, then the box filtering might be enough. I'm going to use the quadtree approach, will see if its already usable Do you already have working code on sqlite ? Best regards Best Martin - Ursprüngliche Mail Von: Noel Frankinet [EMAIL PROTECTED] An: sqlite-users@sqlite.org Gesendet: Freitag, den 19. Mai 2006, 09:38:13 Uhr Betreff: Re: AW: [sqlite] Re: spatial sqlite anyone ? Martin Pfeifle wrote: Hi, I think the simplest solution would be to put a spatial index on top of the B-tree, that's what e.g. Oracle does in their Spatial Cartridge. Basically you store the index data in relations and index these relations by B-trees. In this case, you do not have to change the core code of SQLite. You can already do this now. Nevertheless, it would be nice, if SQlite supports somehow the extensible indexing interface. So, you ask a spatial query and in the background the system uses the index data stored in relations. We have done a lot of research on that topic. To get acquainted to the basic idea, you might have a look at The Paradigm of Relational Indexing: A Survey. In my opinion, a direct integration of a spatial index is of course preferable, but who is going to do that? Best Martin Hello Martin, hello All, Thank you for the above link, it is very useful. I definitely want to go the spatial index map to btree index way. I especially like the quad-tree select because I understand it and I already have most of the building blocks : SELECT DISTINCT idx.id FROM polygons_quadtree idx, TABLE(ZDecompose(BOX()) titles, Table(ZupperHull(tiles.zval)) uh WHERE (idx.zval BETWEEN tiles.zval AND ZHi(tiles.zval)) OR (idx.zval = uh.zval); Well almost, I know how to make ZDecompose, I still not sure about ZHi, ZUpperHul, do you have any more pointers ? I didn't konw the TABLE statement to return a pseudo table, unfortunately, it seems not available in sqlite, can it be emulated by a transient memory table ? Do you think that such a complex statement has any chance to be speedier than a simple bbox elimination ? Thanks again, Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Re: AW: AW: Re: spatial sqlite anyone ?
George Ionescu wrote: Hello Noel, Hello George I'm reposting this message because I have the feeling that you missed the original one. I don't plan to replace the normal indexing, I plan to have a set of function to create a (memory ?) index. But how do I retrieve the data without doing a select where rowid = xxx ? If you're going to create a memory index, than this will be no sqlite spatial index extension: I'm already doing this now by selecting records from a table and creating an in-memory spatial index. the question is how to select in a table when you have a set of keys, I think that I have a path now, but I have to check that I don't know whether by coincidence or not, dr. Hipp has just published a wiki page regarding Virtual Tables which might do the trick, and although it's in very incipient stage (e.g. proposal) it sounds interesting. Go check it out at http://www.sqlite.org/cvstrac/wiki?p=VirtualTables. yes we need temporary table for that, that was the missing link, I'll check what virtual table is, but I suppose that it has to do with the TABLE() sql statement. I must confess that I'm a little tired right now and I cannot see the Virtual Table's application in Spatial Indexes :-) Perhaps tomorrow morning my luck will change and I'll be enlightened. And another think, regarding your second wannado: 2 - to be able to load and exchange data from WKT (well know text format) and binary (shape file for instance) I don't know / think whether this extension should / must be able to read an ESRI shape. You should design your extension carefully with a pluggable way of doing readers/writers. This way, if anyone needs to work with a special format he/she could write it if it doesn't exist. I was saying that because I already do it, using shapelib, and shape files are a de facto standard. I'm saying that because, for example, I've chosen to use an SVG-style notation for storing my gis elements. George. -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Re: spatial sqlite anyone ?
George Ionescu wrote: Hello dear Noel, hello all sqlite users, a spatial extension for sqlite would be nice, although I think that replacing the indexing scheme (e.g. replace the current b-tree with a quad-tree or another spatial index) is alot of work. Just some questions / thoughts: 1. How would you handle indexing? Would you replace completely the btree with a spatial index (the hardest thing to do)? And if so, btree indexing would still be available or not? 2. Go for GEOS's STRTree. It's the fastest spatial index I could find (I did some research awhile ago on open-source solutions regarding spatial indexes). 3. You might want to take a look at SpatialIndex (http://u-foria.org/marioh/spatialindex/). The library is pretty clever designed and it supports RSTAR-tree, MVR-tree and TPR-tree. The problem I found with this library was that it was slower than GEOS at the time I last checked. One of the features I like is that it allows persisting the index. This might be an intermediate solution: you could store the index as a blob in the database. It would not be very efficient (as efficient as replacing indexing) but it would be a place to start. 4. Another nice library who might do the job is CGAL (http://www.cgal.org/). I didn't benchmarked it mostly because GEOS suited my needs just fine, but how knows, it might be better than the ones I mentioned. George. Hello George, Thanks a lot for your input, I don't plan to replace the normal indexing, I plan to have a set of function to create a (memory ?) index. But how do I retrieve the data without doing a select where rowid = xxx ? Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: AW: [sqlite] Re: spatial sqlite anyone ?
Martin Pfeifle wrote: Hi, I think the simplest solution would be to put a spatial index on top of the B-tree, that's what e.g. Oracle does in their Spatial Cartridge. Basically you store the index data in relations and index these relations by B-trees. In this case, you do not have to change the core code of SQLite. You can already do this now. Nevertheless, it would be nice, if SQlite supports somehow the extensible indexing interface. So, you ask a spatial query and in the background the system uses the index data stored in relations. We have done a lot of research on that topic. To get acquainted to the basic idea, you might have a look at The Paradigm of Relational Indexing: A Survey. In my opinion, a direct integration of a spatial index is of course preferable, but who is going to do that? Best Martin Not me, Thank you for the article, If I get the key from the quadtree/rtree index, what is the way to get the data while staying on top of sqlite ? If can see the following schema: select data according to normal sql rule (all the non spatial rules) then filter it spatailly (that's what I do now, simple bbox filtering, no indice). I would prefer the other way around, use spatial index, get a subset (a key set ?) then apply sql alphanumerical filter. Do you know a way to do that in sqlite ? Best regards - Ursprüngliche Mail Von: George Ionescu [EMAIL PROTECTED] An: sqlite-users@sqlite.org Gesendet: Donnerstag, den 18. Mai 2006, 08:28:39 Uhr Betreff: [sqlite] Re: spatial sqlite anyone ? Hello dear Noel, hello all sqlite users, a spatial extension for sqlite would be nice, although I think that replacing the indexing scheme (e.g. replace the current b-tree with a quad-tree or another spatial index) is alot of work. Just some questions / thoughts: 1. How would you handle indexing? Would you replace completely the btree with a spatial index (the hardest thing to do)? And if so, btree indexing would still be available or not? 2. Go for GEOS's STRTree. It's the fastest spatial index I could find (I did some research awhile ago on open-source solutions regarding spatial indexes). 3. You might want to take a look at SpatialIndex (http://u-foria.org/marioh/spatialindex/). The library is pretty clever designed and it supports RSTAR-tree, MVR-tree and TPR-tree. The problem I found with this library was that it was slower than GEOS at the time I last checked. One of the features I like is that it allows persisting the index. This might be an intermediate solution: you could store the index as a blob in the database. It would not be very efficient (as efficient as replacing indexing) but it would be a place to start. 4. Another nice library who might do the job is CGAL (http://www.cgal.org/). I didn't benchmarked it mostly because GEOS suited my needs just fine, but how knows, it might be better than the ones I mentioned. George. -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: AW: AW: [sqlite] Re: spatial sqlite anyone ?
Martin Pfeifle wrote: Hi, the baisc idea of the Relational R-tree is to map the hierarchical relationship between the R-tree nodes to a (father, son) relation where a b-tree is on father. You can the traverse the relation preferable using recursive SQL, if not available, you have to do it on your own. The Idea of the Relational Quadtree is to select the Quad numbers according to a space filling curve,e.g. z-values. that's what I had in mind, mapping a quadtree key to an integer key (I have seen something about morton code). However I still get a key set, what kind of sql may I use to avoid one by one select ? Do you have any pointer for that ? Then again you can use ordinary SQL. - Ursprüngliche Mail Von: Noel Frankinet [EMAIL PROTECTED] An: sqlite-users@sqlite.org Gesendet: Donnerstag, den 18. Mai 2006, 09:50:56 Uhr Betreff: Re: AW: [sqlite] Re: spatial sqlite anyone ? Martin Pfeifle wrote: Hi, I think the simplest solution would be to put a spatial index on top of the B-tree, that's what e.g. Oracle does in their Spatial Cartridge. Basically you store the index data in relations and index these relations by B-trees. In this case, you do not have to change the core code of SQLite. You can already do this now. Nevertheless, it would be nice, if SQlite supports somehow the extensible indexing interface. So, you ask a spatial query and in the background the system uses the index data stored in relations. We have done a lot of research on that topic. To get acquainted to the basic idea, you might have a look at The Paradigm of Relational Indexing: A Survey. In my opinion, a direct integration of a spatial index is of course preferable, but who is going to do that? Best Martin Not me, Thank you for the article, If I get the key from the quadtree/rtree index, what is the way to get the data while staying on top of sqlite ? If can see the following schema: select data according to normal sql rule (all the non spatial rules) then filter it spatailly (that's what I do now, simple bbox filtering, no indice). I would prefer the other way around, use spatial index, get a subset (a key set ?) then apply sql alphanumerical filter. Do you know a way to do that in sqlite ? Best regards - Ursprüngliche Mail Von: George Ionescu [EMAIL PROTECTED] An: sqlite-users@sqlite.org Gesendet: Donnerstag, den 18. Mai 2006, 08:28:39 Uhr Betreff: [sqlite] Re: spatial sqlite anyone ? Hello dear Noel, hello all sqlite users, a spatial extension for sqlite would be nice, although I think that replacing the indexing scheme (e.g. replace the current b-tree with a quad-tree or another spatial index) is alot of work. Just some questions / thoughts: 1. How would you handle indexing? Would you replace completely the btree with a spatial index (the hardest thing to do)? And if so, btree indexing would still be available or not? 2. Go for GEOS's STRTree. It's the fastest spatial index I could find (I did some research awhile ago on open-source solutions regarding spatial indexes). 3. You might want to take a look at SpatialIndex (http://u-foria.org/marioh/spatialindex/). The library is pretty clever designed and it supports RSTAR-tree, MVR-tree and TPR-tree. The problem I found with this library was that it was slower than GEOS at the time I last checked. One of the features I like is that it allows persisting the index. This might be an intermediate solution: you could store the index as a blob in the database. It would not be very efficient (as efficient as replacing indexing) but it would be a place to start. 4. Another nice library who might do the job is CGAL (http://www.cgal.org/). I didn't benchmarked it mostly because GEOS suited my needs just fine, but how knows, it might be better than the ones I mentioned. George. -- Noël Frankinet Gistek Software SA http://www.gistek.net
[sqlite] external indexing
Hello All, Still trying to figure out the best way to index on top of sqlite (for spatial indeex). Lets say the the external index gives me a bunch of rowid, what would be the correct way to send that to sqlite ? (My sql levelis rather low) Should I bypass the sqlparser or is there an efficent way to do that in SQL? Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
[sqlite] spatial sqlite anyone ?
Hello all, I would like to set up a project to spatialise sqlite. 1 - to be able to create geometry colum that would store points,multipoints,lines,multilines,polygones and multi-polygones (Ogis simple features) 2 - to be able to load and exchange data from WKT (well know text format) and binary (shape file for instance) 3 - to create a spatial index on geometry data (either an quadtree or a more advanced Rtree). 4 - to do spatial operation (join, disjoin, near, ...) on those data. I'm ready to contribute code for 1 and 2, there are open-source c or c++ library for 3 and 4. Ideally source should be on sqlite.org. What do you think ? Any interest ? -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: AW: [sqlite] spatial sqlite anyone ?
Martin Pfeifle wrote: I am very interested. We are working on spatial sqlite for almost one year. We plan to include sqlite into an embedded spatial application. You mention that there are open-source code for library 3 and 4. Can you give me a hint where to find it? I will contact you at the end of the week providing more information about our spatial sqlite and the requirements of our application. Best Martin Hello Martin I also have some working code. I use it on a pda application. for point 3 and 4 I was thinking to the rtree library (i don't have a link right now, but google knows it), and the geos lib (from posgis). I wait for your mail, I hope that we will find contributor, a spatial sqlite would be a killer app I think. Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] VB.Net DataSet DataGrid with ADO.Net Provider
John Newby wrote: Hi, I am trying to access a SQLite database using the ADO.Net provider and bring all the data back in a tabular form, I can bring back the data using a datareader but I don't know if I can put the data into a datset or a datagrid. Does anyone know if you can do this? Many thanks. John. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 9/05/2006 Hello, I use a virtual listview directly on top of sqlite3, its in c++ but it works very well (even on PDA). It could easily be turned in an activeX (its ATL/WTL, no MFC). Best wishes. -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] extensible indexing
Martin Pfeifle wrote: Dear all, is it somehow possible to add an own index-structure, e.g. M-tree, R-tree, Quadtree...to SQLite? Has anyone ever done that? Best Martin ___ Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de Hello Martin, Apparently nobody, I'm also very interested in R-Tree, I do build and use a Quadtree, but in memory. I also load gis data from sqlite, but without index. Does somebody knows how to complete the process ? (loading gis data with spatial index). I have read somewhere that a quadtree index can be encoded in an integer key, that would be enough for me. Does somebody has a pointer ? Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Sqlite and Java
Nilo Paim wrote: Hi all, Does anybody here knows something about a port of sqlite to java? Please, note that I'm not talking about java calling sqlite via JNI, but about a real rewrite of sqlite using java. Obviously, a second step would be the writing of a JDBC driver. Would be useful that port? Comments? Suggestions? Thanks to all. Nilo Porto Alegre - Brasil Hello Nilo, What would be the point ? A slower, memory hungry, less portable sqlite ? Cheers, -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Sqlite and Java
Nilo Paim wrote: Hi Noel, Maybe slower, maybe memory hungry... but not less portable in my opinion. Java is machine independent, unless when using native code. On that scenario ( native code ) Java is not portable. My point is: I would like to have access to sqlite databases from java without worrying me about native code, dll's, .so'es, etc..., just using only pure java code, without lossing the normal access to the same databases, using the normal way, via C, C++ or any other compiled language. Thanks for your quick response. Cheers, Nilo Porto Alegre - Brasil Hello Nilo, I think there a IBM open source sql engine in pure Java. But I don't rember the name right now. May be you could use that ? Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Sqlite and Java
Kervin L. Pierre wrote: Cloudscape, which was given to Apache foundation and is now the Apache Derby Project. http://db.apache.org/derby/ Yes this is it ! -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Trying to compile under VC.NET
Henning Folger wrote: Hello, I am happy to find sqlite. This backend fully matches my need regarding to a projekt of mine. But i have to make some changes to fit into my project. So i tried to recompile the sources under VC.NET. On the web page i found a howto to do it, but i have no luck with it. I always get the error C1010, unexpected end of file while looking for precompiled headers. Is there anyone out who can help me or can send me an an howto or maybe a dsw-File? Thanks for your help Henning turn off precompiled header ? -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Final Year Project/Dissertation help required!!!!
John Newby wrote: No, I'm not asking the community to do my homework for me, I need to do a user analysis phase for my dissertation, and as I don't know anyone who uses SQLite this is the only place I can get my questions answered. Many thanks. John. On 13/12/05, juan perez [EMAIL PROTECTED] wrote: So in a nutshell you are asking the community to do your homework. What a shame. Start by analyzing the sqlite3 command line interface, make a GUI that replicates that (and more, heck its a GUI), contribute it to the sqlite project, THEN talk about your dissertation. jp. John Stanton wrote: john.newby wrote: Hi, I am doing my final year project/dissertation on Creating a GUI to SQLite I am after help for my analysis phase and would like any comments/help from members or if you could put me in the right direction as to where I could find out this information. I would like information regarding SQLite for the following if at all possible:- Why users use SQLite instead of other SQL databases? SQLite has two fine features. Firstly it is simple, lives in one file and doesn't require a server process. Secondly it implements all the important elements of SQL. Would a GUI detract users from using SQLite? There is a wagon load of GUIs to SQLite already. They neither add nor detract from the DBMS. Regarding a GUI to SQLite:- What features a GUI MUST have? What features you would LIKE a GUI to have? What features you would NOT LIKE to have? This is like asking what features are needed in a coat without specifying its intended usage. Any help on these questions or any other information you may feel would help me on my journey would be greatfully appreciated. You can contact me at my University email address on [EMAIL PROTECTED] Many thanks for your help. John. This e-mail is intended solely for the addressee. It may contain private and confidential information. If you are not the intended addressee, please take no action based on it nor show a copy to anyone. Please reply to this e-mail to highlight the error. You should also be aware that all electronic mail from, to, or within Northumbria University may be the subject of a request under the Freedom of Information Act 2000 and related legislation, and therefore may be required to be disclosed to third parties. This e-mail and attachments have been scanned for viruses prior to leaving Northumbria University. Northumbria University will not be liable for any losses as a result of any viruses being passed on. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.13.13/198 - Release Date: 12/12/2005 Hello, I would propose : Creates a stand alone explorer like utility. Left pane a tree view showing table, views and indexes. Right pane, a tab control where each opened table will be displayed. In the tree view, a context menu to open a table, create a new table, create an index, a view, drop a table and so on. In the right pane use a virtual ListView control to show the data. A shell like control to enter direct sql commands. A form editor to defines editing mask (saved in xml of course and in a system table). A small scripting language (lua ?) to create user defined commands. There must be dialog boxes or wizard to help the creation of table, and data query. There must be facilities to import and export data in various format. Utility must be stand alone, does not depends on any runtime besides sqlite. Must be cross platform, so use wxwindows, or qt, and run on a PDA. Must be open source, BSD licensed or public domain so that I can steal it. Anything else ? Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Probably not simple question
[EMAIL PROTECTED] wrote: Hello, I have a following problem. In my program I have a vector of elements let say defined as follow: struct intDouble { int x; int y; }; Now, I would like to put the contents of this vector into sqlite table, to be able than read it back. Mayby someone can suggest some solution how to do it in C++?? Regards WojciechW. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.13.12/193 - Release Date: 6/12/2005 I use a blob, your class have to be able to output and be constructed by the same blob. Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Probably not simple question
erw2 wrote: I have follow your advice and had a look at CppSQLite. setBinary and getBinary functions work only on unsigned char, and size of intDouble is (on my PC) 8 bytes, so much more than unsigned char (1 byte). The question is how to correctly store such structure in db, and how to restore it later? Regards WojciechW Hello, when storing, create a blob from your structure and store it. When retrieving, validate the blob (by its size, by a magic number at the end or something like that) then feed the blob into malloced memory and you get your object back (even if its a collection of objects) Best wishes, -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] SQLite for CAD database
Rajan, Vivek K wrote: Hello- Has anyone used SQLite database for storing CAD database: especially netlist and physical connectivity/topology? If so, what kind of performance have you been able to get? Rajan No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 25/11/2005 Hi, I use sqlite for gis data (polygone, polylines, points). No connectivity yet but topological layer (surface connected to line connected to point) are on my road map. Up to now, speed is very good even for hundred of thousands of objects. I use a quadtree indexing scheme that seems good enough. Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] functions that return tables
Nathan Kurz wrote: Perhaps related to the recent questions about converting rows to columns, I'm finding the need for user defined aggregate functions that can return multiple values, or ideally multiple rows of values. Assume you to determine the highest N values from column. You'd want a aggregate function like max_n(col, n) that makes one pass through the table, saving the highest values it sees, and then returning them. SELECT max_n(col, 3) FROM test; max --- 10 9 8 My current workaround is to have my function return a comma separated list of values (10,9,8), parse this string in my application, and generate a new query, but ideally I'd like to do this in one step. Is there any reasonable way to accomplish this? Or am I left with defining a new function type that returns a handle to a temp table, and new parsing logic to wrap the right OP codes around that function? Thanks! Nathan Kurz [EMAIL PROTECTED] Hello Nathan, why not a vector of values ? Regards, -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] uSQLiteServer Source code available
Doug Nebeker wrote: I have a simple C++ HTTP server that I wrote (all in a single .cpp and .h file). Multi-threaded, has a session concept (via cookies), can parse POST and GET variables. It is a C++ class that you can derive from and then override the LoadFile method (which is where I typically put my command/transaction processing). The default just serves files from a defined directory. Implemented on Windows with the Win32 API, so there would be some porting to get it onto other platforms. I'd be happy to put out somewhere if anyone is interested (and I'd love to receive feedback--always happy to learn from anyone). By the way, it is my personal work and not owned in any way by my employer (-- decided to put that there for my own sake...) Doug -Original Message- From: David Fletcher [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 7:59 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] uSQLiteServer Source code available r == roger [EMAIL PROTECTED] writes: r HTTP would be the logical choice, telnet is often firewalled. BTW, r you can of course allready telnet into the server anyway. r I will try doing something like this, but I have never implemented r the server side of a HTML connection. Do you know where I can find a r quick guide to making a simple HTTP server? Better still, what about r a small simple ready made HTTP server of the sort that can be r embedded into the application and has hooks to callback into user r code? I know that Qt has something like this, but I can't recall if this is only available in the enterprise (commercial) edition or not. Check http://www.trolltech.com for more. See http://doc.trolltech.com/4.0/qhttp.html, for example. http://www.sourceforge.net has some http clients and servers, too. A search there should turn up some results. HTH Hello Doug, I am *very* interested, I'm searching something like that for quite some time. I have a sax like xml parser (not validating) in one .h file (C++) if somebody is interested ! Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] sqlite and spatial extension
Rajan, Vivek K wrote: Hello- Are there spatial extensions available for sqlite? And/or is there any add-on library/shareware/freeware which can enable spatial extensions/queries with SQLite? Rajan Hello, None that I'm aware of also I do use sqlite to store geagraphical info, but as a blob. I have a crude spatial indexing but I would like to find a better solution. Any idea ? -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Question about SQLite and spatial data
Rajan, Vivek K wrote: I have a need to store spatial and connectivity data (think verilog netlist with x, y coordinate information) in a persistence on-disk file. I am looking at different SQL-based databases and am wondering if anyone has recommendations/opinions on how good SQLite is for: - Storing spatial data. An examples, documentation and support links - Performing spatial queries and indexing for very large hierarchical data set Please advice. Rajan No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.18/91 - Release Date: 6/09/2005 Hello, I do it. I have a collection of graphical classes (line, polylines, ) than can be saved and retrieved from sqlite. I use the 2.8. The shape are saved as blob encoded in text. When drawing or selecting, shapes are pulled from the Geometry column via sqlite call-back mechanism. Shape class have a static factory method that takes the blob pulled from db as parameter and return a well formed object. The table schema is made from a primary key , 4 int for a bounding box, a the geometry blob. I try now to make a spatial index (quadtree or rtree) but I already have good performance by selecting bounding box. Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Have ever anybody port SQLite to WinCE
jason zhang wrote: Hi all, I am going to use SQLite on WinCE platform.Have ever anybody has experience with it? I encounter some problem when I port SQLite to WinCE. No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005 Hello, yes, I use sqlite on winCE for two years now. Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Have ever anybody port SQLite to WinCE
jason zhang wrote: Hi, Thank you.I just found that there is a project named SQLite for wince in sourceforge.net, Do you use that version? - Original Message - From: Noel Frankinet [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Tuesday, August 16, 2005 2:49 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE jason zhang wrote: Hi all, I am going to use SQLite on WinCE platform.Have ever anybody has experience with it? I encounter some problem when I port SQLite to WinCE. No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005 Hello, yes, I use sqlite on winCE for two years now. Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net yes, I had made the first crude port to ce than I switched to that much better port. -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Have ever anybody port SQLite to WinCE
jason zhang wrote: Hi, Thank you. How about the performance of this library? - Original Message - From: Noel Frankinet [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Tuesday, August 16, 2005 2:57 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE jason zhang wrote: Hi, Thank you.I just found that there is a project named SQLite for wince in sourceforge.net, Do you use that version? - Original Message - From: Noel Frankinet [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Tuesday, August 16, 2005 2:49 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE jason zhang wrote: Hi all, I am going to use SQLite on WinCE platform.Have ever anybody has experience with it? I encounter some problem when I port SQLite to WinCE. No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005 Hello, yes, I use sqlite on winCE for two years now. Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net yes, I had made the first crude port to ce than I switched to that much better port. -- Noël Frankinet Gistek Software SA http://www.gistek.net very good, I even use it for graphic display (GIS). -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] how to list table making a view
Dennis Cote wrote: Noel Frankinet wrote: Lawrence Chitty wrote: You may be able to do this using the 'explain' statement for example, I have a view called 'myview'. Wrapping this into an sql select statement and proceeding this with explain e.g. explain select null from myview gives a result set with the following:- addropcodep1p2p3 0ColumnName00null 1ColumnName10TEXT 2Integer00NULL 3OpenRead1228mytable1 4VerifyCookie03016NULL 5Integer00NULL 6OpenRead217mytable2 7Rewind113NULL 8Rewind212NULL 9String00NULL 10Callback10NULL 11Next29NULL 12Next18NULL 13Close10NULL 14Close20NULL 15NullCallback10NULL 16Halt00NULL All you need to do now is search through the result set for any opcode that is OpenRead, and the table name is in the p3 (last) column. As you can see, myview consists of mytable1 and mytable2 Thank you that's what I was looking for. Noel and Lawrence, You should note that this will only work if your sqlite library is compiled without NDEBUG defined (i.e. only in a debug build). In debug builds, the table names in the explain output are generated by taking the root page number that is actually stored in the compiled VM and looking up the corresponding table name in the sqlite_master table. Production builds (which are substantially faster) don't do this, they simply display the root page number. You can of course do the lookup in the sqlite_master table yourself, but I don't know if there is a good way to tell if you are using a debug or production build. You can't simply check if the table name is numeric because someone could create a table with a numeric name. Some of the pragmas, like parser_trace, don't work in production builds, but don't generate any errors either. If anyone knows how to tell if the sqlite library was built with NDEBUG defined, this could be made to work well enough. HTH Dennis Cote Thank you Dennis, so I'm back to my original question, is parsing the DDL from sqlite_master is a viable (good ?) option. Is there a way to do it with salite itself (there surely is way but can hook into it). Or should I rely on my homegrown half-backed SQL parser ? Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] sqlitebrowser alternative
Andrea Giammarchi wrote: I have just uploaded an SQLITEBROWSER like application made in Python and Flash 7. This application requires windows ( it's an exe file ) and Flash Player 7 installed. It works perfectly with all sqlite 2.X database files and it's easy to use ( I hope ). Please tell me what do you think about this little program, thank you :-) http://cmslim.3site.it/download.php?id=6 Andrea Giammarchi Hello, -very heavy download -Install a lot a multi-megabytes dll -does not work (see log) I would prefer a statically linked single exe program written in c that works. Best regards Traceback (most recent call last): File Sqlite_2_Manager.py, line 136, in ? File wx\_core.pyc, line 5301, in __init__ File wx\_core.pyc, line 4980, in _BootstrapApp File Sqlite_2_Manager.py, line 113, in OnInit File Sqlite_2_Manager.py, line 20, in __init__ File wx\lib\flashwin.pyc, line 40, in __init__ File wx\activex.pyc, line 221, in __init__ wx._core.PyAssertionError: C++ assertion wxAssertFailure failed in contrib\activex\wxie/wxactivex.cpp(322): m_ActiveX.CreateInstance failed Traceback (most recent call last): File Sqlite_2_Manager.py, line 136, in ? File wx\_core.pyc, line 5301, in __init__ File wx\_core.pyc, line 4980, in _BootstrapApp File Sqlite_2_Manager.py, line 113, in OnInit File Sqlite_2_Manager.py, line 20, in __init__ File wx\lib\flashwin.pyc, line 40, in __init__ File wx\activex.pyc, line 221, in __init__ wx._core.PyAssertionError: C++ assertion wxAssertFailure failed in contrib\activex\wxie/wxactivex.cpp(322): m_ActiveX.CreateInstance failed -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] sqlitebrowser alternative
Andrea Giammarchi wrote: Hello andrea, Thank you Noel Frankinet for this repot , I just use this application to manage my sqlite database files ... well, Windows XP SP2 and flash player 7, no problema with a lot of database files .. -very heavy download I am working to have a better host ... I am sorry, I know this is slow ... -Install a lot a multi-megabytes dll I have used py2exe, it installs itself a lot of dlls ... because I've not created any dll ... you know that wxpython is just 4,5 megabytes ... -does not work (see log) should you please tell me what version of windows are you using ? windows 2000 prof. - I would prefer a statically linked single exe program written in c that works. he he ... but it works too, however it's an alternative with some features that sqlitebrowser has not :-) ( but has not some features that sqlite browser has ... ) Regards, andr3a Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] sqlitebrowser alternative
Andrea Giammarchi wrote: Noel Frankinet wrote: windows 2000 prof. well, I have tried on windows 2000 prof. SP4 right now ... it works perfectly, are you sure to have opened an uncorrupted sqlite *version 2 *file ??? Really strange if you are sure, anyone should tell me if this program works correctly ? See you, andr3a I was not able to do anything, the rogram crashed immediately, I have several machine and virtual machine here, same result. -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] sqlitebrowser alternative
Andrea Giammarchi wrote: Noel Frankinet wrote: I was not able to do anything, the rogram crashed immediately, I have several machine and virtual machine here, same result. It doesn't need any virtual machine, it's a stand alone executable program, however, 46 downloads and only you have this problem. Well, I don't know why it doesn't work on your windows PC, I am sorry :-( Any other comment from other ? That flash interface will be used with a PHP5 class file to manage, with user and password, your online sqlite files too, should be interesting ? Regards, Andrea Giammarchi A virtual machine is a test a test config inside vmware. The trace back I have sent should show where the error is. Best regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Image Hotspots - Urgent
Anirban Sarkar wrote: Hi all, I know that this is a sqlite forum and not the right place to post any TCL related questions. However, I have posted this question on many TCL forums including comp.lang.tcl but unfortunately did not get any respond. So just thought if anyone on this forum can help me out. It is very urgent. I have an area map which is obviously an image. I need to create some hotspots on the map at specific locations. The hotspots should have some backend data bound to them so that whenever a user clicks on a particular hotspot, he/she is redirected to a required location along with the data which was bound to the selected hotspot. Please note that I am scripting in TCL and the backend used is Sqlite. Any guidelines or help will be highly appreciated. Regards, Anirban Sarkar Create an array of hotspot (rectangle recording the position of the hotspot on the map and a key to your data). When the user click, find the corresponding hotspot by scanning the above rectangle. Use the key to retrieve the data. You may store the rectangle in a sqlite table and do a select on user click. Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] BLOB versus table storage
[EMAIL PROTECTED] wrote: I have a fairly simple database design with a series of tables that reference graphical data. Currently, there is one table that contains the following: CREATE TABLE polygons (id INTEGER PRIMARY KEY, externalref INTEGER, pointcount INTEGER, pointlist BLOB) When I insert data to this table, I have to write a binary list of x,y coordinates in a sequential memory region before storing in the database. Getting information back from the database requires a conversion in the opposite direction. Typically these lists contain 10-20 points, so they are not very large. This currently works, but I'm wondering if it would be better to create a new table for the points and reference the polygon primary key: CREATE TABLE pointlist (polyid INTEGER, x INTEGER, y INTEGER) On average, I'm managing 5+ polygons, so the pointlist could exceed 1 million entries very easily. Points are not shared between polygons. Does anyone have a recommendation as to which solution would be more optimal, both for space and processing time? In a worst case scenario, I could insert over 1 million polygons, resulting in a max 20 million point list table. Thanks, John you will need some form of spatial indexing if you want to retrieve your data faster. I use a simpe quad-tree but I'm sure that better design exist. -- Noël Frankinet Gistek Software SA http://www.gistek.net