mysql with postgres

On 12/23/2014 1:37 AM, Ravi Kiran wrote:

Is postgres source code compatible with mysql database?? If it is,
could someone could give me some links so that I can do that.

I want to hack into the postgres source code, but as I am comfortable
with mysql, I want to use the mysql database not postgres.

postgresql and mysql are both SQL dialects, arguably postgresql follows
the SQL standards closer, but both have extensive unique customizations
and extensions. Both systems implement a transactional database
server, but the implementations are completely different, as are the
disk storage structures.

what do you want to achieve by 'hacking into the postgresql source code'
? and if you're 'hacking postgresql' what do you mean by 'want to use
the mysql database' ?

--
john r pierce 37N 122W
somewhere on the middle of the left coast

On Tue, Dec 23, 2014 at 3:37 AM, Ravi Kiran <ravi.kolanpaka@gmail.com>
wrote:

hi all,

Is postgres source code compatible with mysql database?? If it is, could
someone could give me some links so that I can do that.

I want to hack into the postgres source code, but as I am comfortable with
mysql, I want to use the mysql database not postgres.

any references would be fine.

thank you

​This is a bit confusing on the first read. Do you really want to "hack"
the source code to the PostgreSQL software? Or do you mean that you have
some other software (what?) which uses the PostgreSQL data base (perhaps
using libpg) and you want to modify that source code so that it will access
a MySQL database instead of a PostgreSQL database?

The first case makes no sense to me, so I assume you really are doing the
second case: You want some other software to interface with MySQL instead
of PostgreSQL. This case makes more sense to me. And I would say that the
answer is "it depends". Well, actually the answer is "yes, if you're
knowledgeable about both MySQL and PostgreSQL as well as your application".
Both MySQL and PostgreSQL have multiple software APIs that can be used to
access them. If your software is using the "low level" API, such as libpg
for PostgreSQL, then you have a lot of work to do because the API are _NOT_
identical. But if your software uses an API such as ODBC, then it should be
simple.

However, in this latter case, I think it would be better for you to talk
with the developer(s) of the other software. Many developers write their
code such that the database access is encapsulated in a single module so
that supporting multiple database systems only requires modifying that one
module. The people here have no idea because you didn't mention the name of
the product which is using PostgreSQL which you want to use MySQL instead.

In general, you can't just "pop in" a new database interface to existing
software when the software in question is using a low level API such as
"libpg" for PostgreSQL or libmysqlclient / libmysqld for MySQL. The low
level APIs are not identical. I don't know if there is anyone here who has
a "how to convert from the PostgreSQL to MySQL API" type document which
would be needed to address this.

​I hope this at least somewhat addresses your question.

--
​
While a transcendent vocabulary is laudable, one must be eternally careful
so that the calculated objective of communication does not become ensconced
in obscurity. In other words, eschew obfuscation.

111,111,111 x 111,111,111 = 12,345,678,987,654,321

Maranatha! <><
John McKown