|
|
MySQL and Delicious Library
|
|
|
|
Fresh-Faced Recruit
Join Date: Oct 2006
Status:
Offline
|
|
I'd like to export my library to a MySQL database. Does anyone have an appropriate CREATE TABLE command to set things up ? I'd rather not fool around with field types and lengths if I don't have to.
Dick
|
|
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Offline
|
|
Originally Posted by dnerf
I'd like to export my library to a MySQL database. Does anyone have an appropriate CREATE TABLE command to set things up ? I'd rather not fool around with field types and lengths if I don't have to.
Dick
Your table structure will depend greatly on the data you want to maintain, and the general format of this data.
If you don't already have MySQL experience, a tool like phpMyAdmin will help you create your database structure, as well as import data to this DB via a CSV or SQL dump file.
|
|
|
|
|
|
|
|
|
Fresh-Faced Recruit
Join Date: Oct 2006
Status:
Offline
|
|
I have enough MySQL experience that my concerns are centered around minimizing the effort in exporting the Delicious Library data, analyzing/editing the values using MySQL, then re-importing the edited values into Delicious Library. It looks like Delicious Library exports some 40 fields, and I'm assuming that, if I maintain all 40 fields in MySQL I'll have fewer problems in making the round-trip.
|
|
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Offline
|
|
Originally Posted by dnerf
I have enough MySQL experience that my concerns are centered around minimizing the effort in exporting the Delicious Library data, analyzing/editing the values using MySQL, then re-importing the edited values into Delicious Library. It looks like Delicious Library exports some 40 fields, and I'm assuming that, if I maintain all 40 fields in MySQL I'll have fewer problems in making the round-trip.
That's a decent assumption, since your own MySQL database will always offer you more flexibility in accommodating changes in structure than the DL export option.
How does DL save its data at the file system level? What format is this in? If it is in something like XML, you could also just parse out the data you need and generate MySQL insert statements to recreate your MySQL table, perhaps on scheduled intervals...
|
|
|
|
|
|
|
|
|
Mac Elite
Join Date: Jul 2002
Location: Syracuse
Status:
Offline
|
|
|
Imac Core Duo 1.83/1.5 GB/20 inch cinema, ibook G4 1 ghz
|
|
|
|
|
|
|
|
Fresh-Faced Recruit
Join Date: Oct 2006
Status:
Offline
|
|
Weezer,
Thanks for the info about DeliciousSQLExport. It's almost what I wanted. Unfortunately it doesn't handle 'location in building', 'notes' or 'creation time' fields.
Dick
|
|
|
|
|
|
|
|
|
Fresh-Faced Recruit
Join Date: Jan 2007
Status:
Offline
|
|
Originally Posted by dnerf
Weezer,
Thanks for the info about DeliciousSQLExport. It's almost what I wanted. Unfortunately it doesn't handle 'location in building', 'notes' or 'creation time' fields.
Dick
Sorry to bump a deadish thread, but I think I can help. How comfortable are you with Ruby? I've written a script that can pretty nicely parse through DL's current XML file and give you whatever attributes you like, and even then move to MySQL if you'd want. PM me if you want more, and I can write up some code for you.
Eddie
|
|
|
|
|
|
|
|
|
Registered User
Join Date: Jan 2007
Status:
Offline
|
|
Originally Posted by dnerf
Weezer,
Thanks for the info about DeliciousSQLExport. It's almost what I wanted. Unfortunately it doesn't handle 'location in building', 'notes' or 'creation time' fields.
Dick
DeliciousSQLExport now supports this information as well as shelves, borrowers and loans.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|