237 reputation
36
bio website cubrid.org
location Seoul, South Korea
age 27
visits member for 3 years, 5 months
seen May 20 '13 at 20:03

I'm a developer at NAVER Korean IT Corporation. I used to be a project manager of CUBRID open source database. Now dedicate my full time to Node.js development. At NAVER I develop a real-time distributed log search system which uses ElasticSearch, Kafka, Storm, CUBRID, Redis, and Node.js. I also maintain Pulsr, a fast Node.js Web Framework, in my personal time. See my Github for other modules I have created.


Nov
2
comment How do I enable READ-only (passive) mode in a particular RDBMS?
Thank you for your feedback. I've seen great questions with answers which include all databases in one which are accepted and preferred then those which provide only one answer. In any case I will vote up all valid answers and accept the one I think provides more complete answer even if it's related to only a single database.
Nov
2
comment How do I enable READ-only (passive) mode in a particular RDBMS?
Thank you for your answer. One problem with this solution is that you have to change your application code to reflect this new read-only user. Is there a way to do this on DB side only?
Nov
1
comment How do I enable READ-only (passive) mode in a particular RDBMS?
I wouldn't mind if this question and its answers become of "community wiki" type. I'm doing research on this topic so I would appreciate very much answers specific for each database as detailed as possible.
Nov
1
comment How do I enable READ-only (passive) mode in a particular RDBMS?
Oh, I didn't know about this fact in Oracle. Thank you for your answer!
Nov
1
comment How do I enable READ-only (passive) mode in a particular RDBMS?
Thank you for the answer! And yes, I assume the fact that the Web app has to be designed to handle Read-only mode. In SE this time, for instance, most "writable actions" have been automatically disabled which is smart!
May
22
comment Which DBMS are fast enough for an online game (few thousand players)?
CUBRID, in fact, not just a Relational DBMS but also provides Object functionality. The object part is exactly what Game Developers need. In CUBRID you can easily create User Defined Types. Eg. a table can have a column, which has a data type as another table like: CREATE TABLE a ( id INTEGER AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) ); CREATE TABLE b ( id INTEGER AUTO_INCREMENT PRIMARY KEY, custom_column a ); This type of functionality is highly valuable for game developers. Popular online games in South Korea are based on CUBRID.
Mar
21
comment In MySQL, does the order of the columns in a WHERE clause affect query performance?
Right, I agree. However, this is valid in case the value selectivity is low. Considering the data type that Patrick (this question author) uses, which is DATETIME, indexing is recommended. Usually this type of field has quite large set of values, unless there is an odd situation when he uses only several possible dates. *I will edit my answer above to make more clear and valid statement.
Mar
16
comment Storing IP address
nhnb, IPv6 is 128 bit, but the conversation is about IPv4 which IS 32 bit. No need to comment on each comment/answer insisting on your knowledge.