meta user
network profile
| bio | website | cubrid.org |
|---|---|---|
| location | Seoul, South Korea | |
| age | 26 | |
| visits | member for | 2 years, 2 months |
| seen | May 20 at 20:03 | |
| stats | profile views | 7 |
I'm a developer at NHN Corporation. I manage CUBRID open source database project at work, and maintain Pulsr, a fast Node.js Web Framework, in my personal time.
|
May 20 |
awarded | Yearling |
|
May 20 |
revised |
Trying to use MySQL Workbench with TCP/IP over SSH - failed to connect Fixed a typo. |
|
May 20 |
awarded | Caucus |
|
May 20 |
awarded | Constituent |
|
Jan 11 |
awarded | Autobiographer |
|
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 |
revised |
How do I enable READ-only (passive) mode in a particular RDBMS? corrected typo |
|
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! |
|
Nov 1 |
asked | How do I enable READ-only (passive) mode in a particular RDBMS? |
|
May 22 |
awarded | Excavator |
|
May 22 |
revised |
Which DBMS are fast enough for an online game (few thousand players)? Added a link to CUBRID community site to make it easier for users who do not know it to find the official site. |
|
May 22 |
suggested | suggested edit on Which DBMS are fast enough for an online game (few thousand players)? |
|
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. |
|
May 8 |
answered | cross self join to get more rows - better solution? |
|
Nov 19 |
answered | Trying to use MySQL Workbench with TCP/IP over SSH - failed to connect |
|
Mar 21 |
revised |
In MySQL, does the order of the columns in a WHERE clause affect query performance? reflected the suggestions made by other users in the comments. |
|
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. |
