IoMySQL: MySQL binding for Io

Io에 MySQL 바인딩이 아직 없길래 작성해 보았다. 원래 C는 좋아하지도 않고, 거의 써본 적도 없는데, 내가 지금까지 C로 작성한 코드 중에서는 가장 실용적이다. 프로젝트 홈페이지에서 받을 수 있다.

There’s no MySQL binding for Io yet, so, I wrote it. I don’t like C language actually, and I have few experience about C, however, It is most functional code I ever wrote in C language. You can get it at project homepage.

사용할 때는 Io 소스 디렉토리 내의 addons에 IoMySQL을 받은 뒤 빌드해서 사용하면 된다.

To use, download IoMySQL into addons in Io source directory, then build it.

$ cd Io-SourceFolder
$ svn co http://io-mysql.googlecode.com/svn/trunk/ addons/MySQL
$ io build.io -a MySQL

아래 코드는 그냥 예제.

Following code is a just example…

my := MySQL establish("localhost", "user", "password", "database")

# Get rows by Map
my queryThenMap("SELECT col FROM rel") foreach(at("col") println)
# Get rows by List
my query("SELECT col FROM rel") foreach(at(0) println)

my close

덧. 영어가 어색해서 죄송합니다. 제 모국어가 아니거든요. ㅋㅋ

PS. Sorry for my ugly English. It’s not my primary language.

This entry was posted on March 26, 2007 at 6:23 PM. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Inash Zubair Says:
March 27th, 2007 at 4:37 AM

Hi. I’ve tried building the addon as you’ve instructed. But I get some errors and at the end it says cannot mysqlclient. I’m working on Ubuntu Edgy and have got the latest mysql client libraries installed. Which version does your addon build against? Btw, A direct native driver for Io is very convenient. Thanks and keep up the effort.

Min-hee Hong (DAHLIA) Says:
March 27th, 2007 at 11:45 AM

Hi. I’ve tried building the addon as you’ve instructed. But I get some errors and at the end it says cannot mysqlclient. I’m working on Ubuntu Edgy and have got the latest mysql client libraries installed. Which version does your addon build against?

Hi. I worked this addon on Gentoo, and installed MySQL by emerge(dev-dev/mysql 5.0.26-r1). I wrote build.io loosely, so, in my opinion, it is just a problem of library path finding. Anyway, I’ll fix it soon.