Re: [sqlite] open database on Linux. Already db created on Mac.
Am 29.07.2012 14:14, schrieb Durga D: What is the procedure to open the sqlite3 database file in Linux Terminal which is already created on Mac. Since the database file is portable across operating systems, you can just use the sqlite3 tool: $ sqlite3 your.db Lutz ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Thanks to Peter Aronson for providing help!
Dear Peter: Using SQLite is on my listing to purchase. It is really helpful for me to understand futher in SQLite. Thank you again. Best Regards Tom 2012/7/30 sqlite-users-requ...@sqlite.org Send sqlite-users mailing list submissions to sqlite-users@sqlite.org To subscribe or unsubscribe via the World Wide Web, visit http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users or, via email, send a message with subject or body 'help' to sqlite-users-requ...@sqlite.org You can reach the person managing the list at sqlite-users-ow...@sqlite.org When replying, please edit your Subject line so it is more specific than Re: Contents of sqlite-users digest... Today's Topics: 1. Could anyone recommend books for SQLite (???) 2. How to query data in table more than 2? (???) 3. Re: Could anyone recommend books for SQLite (Peter Aronson) 4. Re: How to query data in table more than 2? (Igor Tandetnik) 5. Re: MIN() for a timedelta? (C M) 6. Re: Handling concurrent read request to SQLite (Navaneeth.K.N) 7. Unknown module FTS4 (Navaneeth.K.N) 8. how to process password (yanhong.ye) 9. open database on Linux. Already db created on Mac. (Durga D) 10. Re: EXT : Unknown module FTS4 (Black, Michael (IS)) 11. Re: EXT : open database on Linux. Already db created on Mac. (Black, Michael (IS)) 12. Re: how to process password (Robert Myers) -- Message: 1 Date: Sun, 29 Jul 2012 09:44:56 +0800 From: ??? huangchen...@gmail.com To: sqlite-users@sqlite.org Subject: [sqlite] Could anyone recommend books for SQLite Message-ID: cad70eapwdpr6m0ohzscbgxfg-gded_kojvaq+oeapsufv56...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 Dear all I am looking for a book ,which include all instructures and functions of SQLite. It is like reference guide. Could any help? your sincerely tom -- Message: 2 Date: Sun, 29 Jul 2012 09:50:03 +0800 From: ??? huangchen...@gmail.com To: sqlite-users@sqlite.org Subject: [sqlite] How to query data in table more than 2? Message-ID: cad70eam+hcrddy93c1zoxn6z-ez7+c-dblcwdswps1enk8p...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 Dear all: I would like to query customer from from ooder table and only customer order more than twice. Which clause or filter should I use to filter those customer order more than twice ? Please help Best regards tom -- Message: 3 Date: Sat, 28 Jul 2012 18:50:19 -0700 From: Peter Aronson pbaron...@att.net To: sqlite-users@sqlite.org Subject: Re: [sqlite] Could anyone recommend books for SQLite Message-ID: 501496db.90...@att.net Content-Type: text/plain; charset=UTF-8; format=flowed There's a page on the SQLite website about SQLite books at http://www.sqlite.org/books.html. I own the first two on the page, and like them both. If I was only to get one SQLite book, it'd be the second one on the list: Using SQLite by JayKreibich. Best, Peter On 7/28/2012 6:44 PM, ??? wrote: Dear all I am looking for a book ,which include all instructures and functions of SQLite. It is like reference guide. Could any help? your sincerely tom ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Message: 4 Date: Sat, 28 Jul 2012 23:46:56 -0400 From: Igor Tandetnik itandet...@mvps.org To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to query data in table more than 2? Message-ID: jv2bnn$qkb$1...@dough.gmane.org Content-Type: text/plain; charset=utf-8 ??? huangchen...@gmail.com wrote: I would like to query customer from from ooder table and only customer order more than twice. select CustomerId from Orders group by CustomerId having count(*) 2; -- Igor Tandetnik -- Message: 5 Date: Sat, 28 Jul 2012 23:57:20 -0400 From: C M cmpyt...@gmail.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Subject: Re: [sqlite] MIN() for a timedelta? Message-ID: CAAt3jwF=NW68o= 4hps7c6ks+pbr1uk4_wewqy28cdgzyfyh...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 Thanks everyone for the various replies and help. Very useful and I will look into the differences and if I have questions about how these work will let you know. Thank you, Che -- Message: 6 Date: Sun, 29 Jul 2012 12:38:07 +0530 From: Navaneeth.K.N navaneet...@gmail.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Subject: Re: [sqlite] Handling concurrent read request to SQLite Message-ID: CAJSAyaWDsOhHK8Q= 14sdg00pgbdwr0vevynogypcqk+7arq...@mail.gmail.com Content-Type:
[sqlite] Thanks to Igor Tandetnik for providing help.
Dear Igor Tandetnik Thank you for teaching me how to query data duplicatee more than 2 from table. It is really helpful to me. Best Regards tom 2012/7/30 sqlite-users-requ...@sqlite.org Send sqlite-users mailing list submissions to sqlite-users@sqlite.org To subscribe or unsubscribe via the World Wide Web, visit http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users or, via email, send a message with subject or body 'help' to sqlite-users-requ...@sqlite.org You can reach the person managing the list at sqlite-users-ow...@sqlite.org When replying, please edit your Subject line so it is more specific than Re: Contents of sqlite-users digest... Today's Topics: 1. Could anyone recommend books for SQLite (???) 2. How to query data in table more than 2? (???) 3. Re: Could anyone recommend books for SQLite (Peter Aronson) 4. Re: How to query data in table more than 2? (Igor Tandetnik) 5. Re: MIN() for a timedelta? (C M) 6. Re: Handling concurrent read request to SQLite (Navaneeth.K.N) 7. Unknown module FTS4 (Navaneeth.K.N) 8. how to process password (yanhong.ye) 9. open database on Linux. Already db created on Mac. (Durga D) 10. Re: EXT : Unknown module FTS4 (Black, Michael (IS)) 11. Re: EXT : open database on Linux. Already db created on Mac. (Black, Michael (IS)) 12. Re: how to process password (Robert Myers) -- Message: 1 Date: Sun, 29 Jul 2012 09:44:56 +0800 From: ??? huangchen...@gmail.com To: sqlite-users@sqlite.org Subject: [sqlite] Could anyone recommend books for SQLite Message-ID: cad70eapwdpr6m0ohzscbgxfg-gded_kojvaq+oeapsufv56...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 Dear all I am looking for a book ,which include all instructures and functions of SQLite. It is like reference guide. Could any help? your sincerely tom -- Message: 2 Date: Sun, 29 Jul 2012 09:50:03 +0800 From: ??? huangchen...@gmail.com To: sqlite-users@sqlite.org Subject: [sqlite] How to query data in table more than 2? Message-ID: cad70eam+hcrddy93c1zoxn6z-ez7+c-dblcwdswps1enk8p...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 Dear all: I would like to query customer from from ooder table and only customer order more than twice. Which clause or filter should I use to filter those customer order more than twice ? Please help Best regards tom -- Message: 3 Date: Sat, 28 Jul 2012 18:50:19 -0700 From: Peter Aronson pbaron...@att.net To: sqlite-users@sqlite.org Subject: Re: [sqlite] Could anyone recommend books for SQLite Message-ID: 501496db.90...@att.net Content-Type: text/plain; charset=UTF-8; format=flowed There's a page on the SQLite website about SQLite books at http://www.sqlite.org/books.html. I own the first two on the page, and like them both. If I was only to get one SQLite book, it'd be the second one on the list: Using SQLite by JayKreibich. Best, Peter On 7/28/2012 6:44 PM, ??? wrote: Dear all I am looking for a book ,which include all instructures and functions of SQLite. It is like reference guide. Could any help? your sincerely tom ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Message: 4 Date: Sat, 28 Jul 2012 23:46:56 -0400 From: Igor Tandetnik itandet...@mvps.org To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to query data in table more than 2? Message-ID: jv2bnn$qkb$1...@dough.gmane.org Content-Type: text/plain; charset=utf-8 ??? huangchen...@gmail.com wrote: I would like to query customer from from ooder table and only customer order more than twice. select CustomerId from Orders group by CustomerId having count(*) 2; -- Igor Tandetnik -- Message: 5 Date: Sat, 28 Jul 2012 23:57:20 -0400 From: C M cmpyt...@gmail.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Subject: Re: [sqlite] MIN() for a timedelta? Message-ID: CAAt3jwF=NW68o= 4hps7c6ks+pbr1uk4_wewqy28cdgzyfyh...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 Thanks everyone for the various replies and help. Very useful and I will look into the differences and if I have questions about how these work will let you know. Thank you, Che -- Message: 6 Date: Sun, 29 Jul 2012 12:38:07 +0530 From: Navaneeth.K.N navaneet...@gmail.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Subject: Re: [sqlite] Handling concurrent read request to SQLite Message-ID: CAJSAyaWDsOhHK8Q= 14sdg00pgbdwr0vevynogypcqk+7arq...@mail.gmail.com Content-Type: text/plain;
Re: [sqlite] EXT : Unknown module FTS4
The other library that is getting loaded first is embedded in the GUI application. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Sunday, 29 July, 2012 06:22 To: General Discussion of SQLite Database Subject: Re: [sqlite] EXT : Unknown module FTS4 You probably have another shared library in your path that is getting loaded first. Since you said shared library and not DLL I assume you're using Unix of some sort? Run ldd on your GUI app and see what library it says it will use. Also, you should have either strace or truss which can show you which library is getting loaded when it runs. strace myapp myapp.log Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Navaneeth.K.N [navaneet...@gmail.com] Sent: Sunday, July 29, 2012 2:17 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] Unknown module FTS4 Hello, I have a weird problem. I am working on a shared library, written using C and a GUI application written on C++. GUI application uses the shared library. This shared library uses SQLite amalgamation and links statically. GUI also uses SQLite for some configuration purpose. It is also statically linked. Both of them uses latest SQLite version. My shared library uses FTS4. I have enabled FTS4 by providing the compile time options while compiling the shared library. All works well with the shared library. All my tests in the shared library codebase is passing. Problem happens when I start using this in the GUI program. I am getting error like, Unknown module FTS4. This is weird because I have it linked statically in my shared library and all this GUI program does is to dynamically link to my library. When I set the FTS compilation options to the GUI program, error goes away and all works well. I am not sure why this is happening. Any help would be great! -- -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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] EXT : Unknown module FTS4
You've got me totally confusedyou say shared library and dynamically linked but then say it's embedded in the GUI. Which is it? Are you on Unix/Linux? Can you show us your Makefile or an example build line? What are you compiling with? Have you duplicated your GUI build process on another program using all the same settings and succeeded? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Keith Medcalf [kmedc...@dessus.com] Sent: Monday, July 30, 2012 8:06 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] EXT : Unknown module FTS4 The other library that is getting loaded first is embedded in the GUI application. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Sunday, 29 July, 2012 06:22 To: General Discussion of SQLite Database Subject: Re: [sqlite] EXT : Unknown module FTS4 You probably have another shared library in your path that is getting loaded first. Since you said shared library and not DLL I assume you're using Unix of some sort? Run ldd on your GUI app and see what library it says it will use. Also, you should have either strace or truss which can show you which library is getting loaded when it runs. strace myapp myapp.log Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Navaneeth.K.N [navaneet...@gmail.com] Sent: Sunday, July 29, 2012 2:17 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] Unknown module FTS4 Hello, I have a weird problem. I am working on a shared library, written using C and a GUI application written on C++. GUI application uses the shared library. This shared library uses SQLite amalgamation and links statically. GUI also uses SQLite for some configuration purpose. It is also statically linked. Both of them uses latest SQLite version. My shared library uses FTS4. I have enabled FTS4 by providing the compile time options while compiling the shared library. All works well with the shared library. All my tests in the shared library codebase is passing. Problem happens when I start using this in the GUI program. I am getting error like, Unknown module FTS4. This is weird because I have it linked statically in my shared library and all this GUI program does is to dynamically link to my library. When I set the FTS compilation options to the GUI program, error goes away and all works well. I am not sure why this is happening. Any help would be great! -- -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 ___ 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