Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 01-18-2011, 10:01 AM   #1
unboggling
by the bootstraps
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,052
Karma: 858115
Join Date: Jan 2011
Location: Southeast US
Device: PRS-T2, Nexus 7, KindleT, iPad1, Kindle3KB
Newbie asks for help with build on OS X

Anyone want to help a newbie build an ODBC driver for SQLite from source on OS X? The driver is available in binary for Windows32, W64, and Linux platforms. It was originally developed for Windows. The Mac OS X intel version has something vital missing from the binary package so according to the developer must be built from source.

This driver presumably enables use of SQL queries to fetch data from calibredb (SQLite) back to a spreadsheet, which presumably would be useful providing flexibility to calibre power users with large book libraries (meaning large datasets).

I'm an old-timer with rusty out-of-date skills and I don't even know where to start with this build. Plus the driver was developed primarily for Windows, though it has been implemented on Linux and on Mac OS. OS X is unix-based, my unix skills from 20 years ago are faded and perhaps no longer relevant, I'm lucky if I remember what cd and ls mean.

So for all those reasons the amount of help I need is large and the project may not be worth it in the first place.

For further context, if you're interested, please see this thread:

http://www.mobileread.com/forums/sho...d.php?t=117048
unboggling is offline   Reply With Quote
Old 01-18-2011, 10:10 AM   #2
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,433
Karma: 831552
Join Date: Jan 2010
Location: France
Device: Many android devices
I know that it is another step and a point where errors can be made, but you could use the sqlite shell to dump the calibre database as SQL, then import that SQL into a db that you can get an ODBC driver for.

You could also write a plugin to write your own CSV from within calibre, then import that into a DB.
chaley is offline   Reply With Quote
Old 01-18-2011, 11:07 AM   #3
unboggling
by the bootstraps
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,052
Karma: 858115
Join Date: Jan 2011
Location: Southeast US
Device: PRS-T2, Nexus 7, KindleT, iPad1, Kindle3KB
@chaley. I used to hate working with ingres, db2, and oracle. So it doesn't make much sense that I'm pursuing this ODBC thing, except I figured there'd have been many technical advances since those old days so these days it might be easier and might even work well.

Regarding the plugin suggestion, you've mentioned it before and I'm keeping it in the back of my mind but I'm not sure I'm ready to work with python yet. Re-immersing myself in VB, which at least I used to be relatively proficient with before, I've found that even VB has advanced considerably. So I thought a gradual progression of honing my skills might work best for me. To me python looks scary at this point.

SQLite shell? I didn't see anything about that in the calibre user manual. I'll go look for documentation on the SQLite site.
unboggling is offline   Reply With Quote
Old 01-18-2011, 11:22 AM   #4
unboggling
by the bootstraps
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,052
Karma: 858115
Join Date: Jan 2011
Location: Southeast US
Device: PRS-T2, Nexus 7, KindleT, iPad1, Kindle3KB
Quote:
Originally Posted by chaley View Post
you could use the sqlite shell to dump the calibre database as SQL, then import that SQL into a db that you can get an ODBC driver for.
That approach looks promising. I wonder if ms query and/or excel could deal with that SQL export directly without and odbc driver and expensive database? I'll look into it. Thanks.
unboggling is offline   Reply With Quote
Old 01-18-2011, 11:33 AM   #5
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,433
Karma: 831552
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by unboggling View Post
That approach looks promising. I wonder if ms query and/or excel could deal with that SQL export directly without and odbc driver and expensive database? I'll look into it.
Use MySQL or PostgreSQL. Both are well supported and very high quality DBMS. And both are open source/free. I would pick MySQL, as I find it a bit easier to manage, but I know others who very much disagree with me.

I would be astounded if MS query could use the SQL directly. However, you might be able to import it into MS access if that is on the mac.
chaley is offline   Reply With Quote
Old 01-18-2011, 11:34 AM   #6
unboggling
by the bootstraps
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,052
Karma: 858115
Join Date: Jan 2011
Location: Southeast US
Device: PRS-T2, Nexus 7, KindleT, iPad1, Kindle3KB
If anyone is curious enough to want to look at the source, this is the link to the odbc driver downloads page.
http://www.ch-werner.de/sqliteodbc/
unboggling is offline   Reply With Quote
Old 01-18-2011, 11:41 AM   #7
GRiker
Comparer of the Ephemeris
GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.
 
Posts: 1,497
Karma: 424627
Join Date: Mar 2009
Device: iPad
Quote:
Originally Posted by unboggling View Post
Regarding the plugin suggestion, you've mentioned it before and I'm keeping it in the back of my mind but I'm not sure I'm ready to work with python yet. Re-immersing myself in VB, which at least I used to be relatively proficient with before, I've found that even VB has advanced considerably. So I thought a gradual progression of honing my skills might work best for me. To me python looks scary at this point.
As an ex-VB programmer, I can tell you that Python is more fun, more intuitive, faster to develop (yes, really), and there's no going back. A great intro is Mark Lutz's book.

G
GRiker is offline   Reply With Quote
Old 01-18-2011, 11:42 AM   #8
unboggling
by the bootstraps
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,052
Karma: 858115
Join Date: Jan 2011
Location: Southeast US
Device: PRS-T2, Nexus 7, KindleT, iPad1, Kindle3KB
Quote:
Originally Posted by chaley View Post
Use MySQL or PostgreSQL. Both are well supported and very high quality DBMS. And both are open source/free.
Nope, no ms access here. And I'm starting to wean myself from ms products and switch to open source products, such as open office. So thanks for the MySQL suggestion, I was on their site earlier today while looking for odbc drivers and it looked good.
unboggling is offline   Reply With Quote
Old 01-18-2011, 11:50 AM   #9
unboggling
by the bootstraps
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,052
Karma: 858115
Join Date: Jan 2011
Location: Southeast US
Device: PRS-T2, Nexus 7, KindleT, iPad1, Kindle3KB
Quote:
Originally Posted by GRiker View Post
As an ex-VB programmer, I can tell you that Python is more fun, more intuitive, faster to develop (yes, really), and there's no going back. A great intro is Mark Lutz's book.

G
Hmm. That's the opposite of what I'd assumed (of course). I'll look for the book. Thanks.
unboggling is offline   Reply With Quote
Old 01-18-2011, 11:56 AM   #10
Manichean
Wizard
Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!
 
Manichean's Avatar
 
Posts: 3,130
Karma: 80446
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
Quote:
Originally Posted by GRiker View Post
As an ex-VB programmer, I can tell you that Python is more fun, more intuitive, faster to develop (yes, really), and there's no going back. A great intro is Mark Lutz's book.
If you've done programming before, even the tutorial part of the Python documentation (It even comes with the installation on Windows systems! ) is broad enough to give an introduction. I learned what I know of Python from that.
Manichean is offline   Reply With Quote
Old 01-18-2011, 12:57 PM   #11
unboggling
by the bootstraps
unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.unboggling ought to be getting tired of karma fortunes by now.
 
Posts: 1,052
Karma: 858115
Join Date: Jan 2011
Location: Southeast US
Device: PRS-T2, Nexus 7, KindleT, iPad1, Kindle3KB
OK. I ordered Lutz's 3 books in paperback (ironically) from Amazon. Until they get here in 2 days I'll use the doc that came with python on OS X. I'm also downloading MySQL. Thanks, chaley, GRiker, Manichean.
unboggling is offline   Reply With Quote
Reply

Tags
caiibredb, odbc driver, os x, spreadsheet, sqlite

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MacMillan Asks Authors for Backlist eBook Rights abookreader News 24 08-21-2010 03:58 AM
Copyright Czar asks for Input thename News 6 02-24-2010 06:31 PM
Daniel Akst asks what about "Apple's iTablet and the future of literature"? taglines News 5 01-27-2010 09:00 AM
A new users asks... kweller Calibre 15 04-01-2009 12:37 PM
Removing Books - a newbie asks rquesty Sony Reader 9 12-24-2007 05:12 AM


All times are GMT -4. The time now is 06:31 PM.


MobileRead.com is a privately owned, operated and funded community.