||[May. 30th, 2005|03:56 am]
LiveJournal Client Discussions
I'm interested in making an AIM interface to LiveJournal. It would most likely be an AIM bot which you would IM posts to. The bot would run on someone's server... mine right now. (eventually LiveJournal's?)
Has anything like this been done before? If so, please let me know.
I'm interested in using PHP, Java, and MySQL. Joscar seems to be a good AIM library for Java. Does anyone know of a good Java - MySQL library? Is JDBC good?
Any suggestions, comments, etc will be appreciated!
2005-06-02 02:17 am (UTC)
I used the official MySQL JDBC driver
when I was doing some Java MySQL stuff a while back, and didn't have any problems with it. Is there anything in particular that you're looking for?
I don't know if this will be useful to you, but I wrote a general purpose blogging-by-AIM bot in Python a year or two ago, which could certainly talk to LiveJournal through the Blogger API. It's not really documented (it was just a hack I wrote for myself and some friends), and it's not in your language of choice, but you might be able to borrow ideas from it. Anyway, if you're interested, I've put up a page for it
Sweet! I just downloaded your code, put in my bot's username and password and nothing really happened. Maybe it doesn't work on... dare I say it.... Windows.
Recently I've been working a lot with PHP, and have found PEAR packages really useful. (about the equivelent of CPAN for perl) If you've ever worked with DB_QueryTool, maybe you know what I'm talking about. That's the kind of thing I'm looking for, but I could certainly program my own version if nesesary.