More Delicious Than Ever
March 20th, 2005 • Geeking Out / Goodies / MySQLicious / Software
When I started using del.icio.us, I decided I wanted to use it to manage the linklog for my site. However, I wasn’t satisfied with using an RSS feed to put the most recent links on the frontpage. I wanted to have browsable archives, which meant that I needed my links stored locally on my server. In spite of some extensive searching, I wasn’t able to find an existing del.icio.us to MySQL mirroring tool. Thus, MySQLicious was born.
If synching del.icio.us bookmarks into a MySQL database sounds useful, then MySQLicious might be for you. Check out the MySQLicious project page for downloads and documentation.
♫ Imaginary Baseball League - A Lot To Say
Follow this discussion
Roger Goun
March 21st, 2005 at 10:07 pm
On my system (Fedora Core 3, PHP 4.3.10), I had to tack a semicolon onto the end of the require line in the example or I got a parse error.
adam
March 21st, 2005 at 11:08 pm
Eep! Thanks for catching that. :-)
I've uploaded a fixed version.
Clark
March 23rd, 2005 at 4:08 am
I've been looking for something like this for a while now. I hope I can get it to work.
Some more documentation would be nice, but in the mean time here is my error.
Parse error: parse error, unexpected T_VARIABLE in /siteroot/sqlicious/example.php on line 5
Clark
March 23rd, 2005 at 4:26 am
Every time I post a question like this an answer is just the post above me. You'd think that I'd learn.
New error: Fatal error: Call to undefined function: curl_init() in /siteroot/sqlicious/MySQLicious.php on line 237
phpinfo() states " '–with-curl=shared,/usr' " Am I handing it the wrong url, u, or p?
adam
March 23rd, 2005 at 7:53 am
Yeah… sorry about that parse error. I need to add a note in the version history about that.
As far as the curl_init() error, it sounds like cURL support is compiled into PHP, but the curl binary is not in /usr like PHP thinks it is. MySQLicious requires cURL because it's by far the best way to grab information from remote hosts. There is another way to to it, but it involves manually building the HTTP request and it's just not… nice. :-)
If you have shell access to your host, you can type which curl to find out where it is and request that your host move it or symlink it in /usr. If you type that an get a message like "no curl in…" then cURL isn't installed at all and your host needs to install it.
Now, if your host won't fix cURL, I'd be willing to build in a way to make MySQLicious work without cURL.
Let me know how it goes. :-)