Comments on: NEXTGRES Gateway: MySQL Emulator for Oracle http://www.oracle-internals.com/?p=55 Taking a peek inside the box... Tue, 07 Sep 2010 22:20:11 +0000 http://wordpress.org/?v=2.3.1 By: jonah.harris http://www.oracle-internals.com/?p=55#comment-9930 jonah.harris Mon, 15 Feb 2010 18:02:10 +0000 http://www.oracle-internals.com/?p=55#comment-9930 Tyler, Yes, NEXTGRES contains a list of reserved words for each target database and permits alterations to be applied to object names during parse tree transformation. If the word is reserved on the target system, you have the option of applying a prefix/suffix to it. When migrating the data itself, you rename the column/object to a non-reserved word using a prefix or suffix, and configure NEXTGRES to apply that same prefix/suffix transformation when dealing with that column/object. Tyler,

Yes, NEXTGRES contains a list of reserved words for each target database and permits alterations to be applied to object names during parse tree transformation.

If the word is reserved on the target system, you have the option of applying a prefix/suffix to it. When migrating the data itself, you rename the column/object to a non-reserved word using a prefix or suffix, and configure NEXTGRES to apply that same prefix/suffix transformation when dealing with that column/object.

]]> By: Tyler V http://www.oracle-internals.com/?p=55#comment-9924 Tyler V Mon, 15 Feb 2010 17:16:22 +0000 http://www.oracle-internals.com/?p=55#comment-9924 This is super cool!! Nice work. I have a question based on a recent project. We received a request to create an environment for open source tools. We have nothing against LAMP, far from it, but it costs money to support more OSes and database platforms, so management wanted to try our existing stack first. We normally run Solaris, Oracle, and weblogic or glassfish. We tried to get several examples of open source tools running on Solaris/Oracle, but Oracle proved to be the part that wouldn't work, since many of the packages used Oracle reserved words for column names etc. Does your project also have some way to detect and translate between black-box packages that use reserved words? This is super cool!! Nice work. I have a question based on a recent project. We received a request to create an environment for open source tools. We have nothing against LAMP, far from it, but it costs money to support more OSes and database platforms, so management wanted to try our existing stack first. We normally run Solaris, Oracle, and weblogic or glassfish. We tried to get several examples of open source tools running on Solaris/Oracle, but Oracle proved to be the part that wouldn’t work, since many of the packages used Oracle reserved words for column names etc. Does your project also have some way to detect and translate between black-box packages that use reserved words?

]]> By: ORACLE INTERNALS » NEXTGRES Gateway: MySQL Emulator for Oracle « ????????????? http://www.oracle-internals.com/?p=55#comment-9421 ORACLE INTERNALS » NEXTGRES Gateway: MySQL Emulator for Oracle « ????????????? Tue, 02 Feb 2010 14:54:21 +0000 http://www.oracle-internals.com/?p=55#comment-9421 [...] Read more here: ORACLE INTERNALS » NEXTGRES Gateway: MySQL Emulator for Oracle [...] […] Read more here: ORACLE INTERNALS » NEXTGRES Gateway: MySQL Emulator for Oracle […]

]]> By: jonah.harris http://www.oracle-internals.com/?p=55#comment-9339 jonah.harris Sat, 30 Jan 2010 16:02:12 +0000 http://www.oracle-internals.com/?p=55#comment-9339 Fixed and updated. Fixed and updated.

]]> By: jonah.harris http://www.oracle-internals.com/?p=55#comment-9338 jonah.harris Sat, 30 Jan 2010 15:54:55 +0000 http://www.oracle-internals.com/?p=55#comment-9338 Heh... just realized that my show tables doesn't currently include views. Oops! Gotta fix that. Heh… just realized that my show tables doesn’t currently include views. Oops! Gotta fix that.

]]> By: jonah.harris http://www.oracle-internals.com/?p=55#comment-9337 jonah.harris Sat, 30 Jan 2010 15:50:36 +0000 http://www.oracle-internals.com/?p=55#comment-9337 Baron, Good question. Added to the entry is an example against Postgres. From a configuration standpoint, I can restrict to showing all tables or only tables you have in your search_path (which means they wouldn't have to be schema-qualified). In this example, it's configured to return all tables. I also support the [(FROM | IN) db_name] [LIKE quoted_string] syntax, but not yet the additional WHERE clause. Where databases are concerned, from a MySQL-compatibility standpoint, you could either create separate actual databases or simulate them by creating separate Postgres schema and using search_path. The second method is similar to what I use when simulating MySQL with an Oracle database. Each MySQL user has an Oracle account that uses synonyms to point to the actual schema containing the data (assuming that you're connecting with a user other than the owner of those tables in Oracle). -Jonah Baron,

Good question. Added to the entry is an example against Postgres.

From a configuration standpoint, I can restrict to showing all tables or only tables you have in your search_path (which means they wouldn’t have to be schema-qualified). In this example, it’s configured to return all tables. I also support the [(FROM | IN) db_name] [LIKE quoted_string] syntax, but not yet the additional WHERE clause.

Where databases are concerned, from a MySQL-compatibility standpoint, you could either create separate actual databases or simulate them by creating separate Postgres schema and using search_path. The second method is similar to what I use when simulating MySQL with an Oracle database. Each MySQL user has an Oracle account that uses synonyms to point to the actual schema containing the data (assuming that you’re connecting with a user other than the owner of those tables in Oracle).

-Jonah

]]> By: Baron Schwartz http://www.oracle-internals.com/?p=55#comment-9333 Baron Schwartz Sat, 30 Jan 2010 12:34:40 +0000 http://www.oracle-internals.com/?p=55#comment-9333 Jonah, You connected to a Postgres backend with a MySQL client, but then ran a Postgres command to look for tables. What happens if you run SHOW TABLES? Jonah,

You connected to a Postgres backend with a MySQL client, but then ran a Postgres command to look for tables. What happens if you run SHOW TABLES?

]]> By: Log Buffer #176: a Carnival of the Vanities for DBAs | The Pythian Blog http://www.oracle-internals.com/?p=55#comment-9309 Log Buffer #176: a Carnival of the Vanities for DBAs | The Pythian Blog Fri, 29 Jan 2010 19:02:56 +0000 http://www.oracle-internals.com/?p=55#comment-9309 [...] is Jonah H. Harris with an introduction to the NEXTGRES Gateway, a MySQL Emulator for Oracle. Jonah writes: “So, a few people have asked me what NEXTGRES Gateway is. My short answer, the [...] […] is Jonah H. Harris with an introduction to the NEXTGRES Gateway, a MySQL Emulator for Oracle. Jonah writes: “So, a few people have asked me what NEXTGRES Gateway is. My short answer, the […]

]]> By: Prajith http://www.oracle-internals.com/?p=55#comment-9184 Prajith Tue, 26 Jan 2010 10:11:54 +0000 http://www.oracle-internals.com/?p=55#comment-9184 Hey Dude, congratulations !! Fantastic Work !! Keep up the spirit Prajith Hey Dude,

congratulations !! Fantastic Work !!

Keep up the spirit

Prajith

]]> By: Robert Treat http://www.oracle-internals.com/?p=55#comment-9152 Robert Treat Mon, 25 Jan 2010 13:58:07 +0000 http://www.oracle-internals.com/?p=55#comment-9152 Definitely interesting Jonah, would love together a chance to play around with that. Let me know if you want some external validation of this tool. Definitely interesting Jonah, would love together a chance to play around with that. Let me know if you want some external validation of this tool.

]]>