On Mon, Nov 22, 2010 at 12:26 AM, Andreas <maps.on@gmx.net> wrote:
> Am 22.11.2010 08:32, schrieb Adarsh Sharma:
>>
>> I am reading about Dialects of different databases. Yet I can't understand
>> what is the need of dialect in Postgres or any other like Hibernate uses
>> Dialect of all Databases for ORM.
>> What is it &
>
>
> As far as I know, the term dialect is used to express the fact that each
> DBMS has it's own implementation of SQL though they have a lot that works
> the same.
> Like you might find that most of PG's commands work similar to say Oracle
> but there are still differences.
> Or Postgresql has "serials" while MySQL has "autoincrement" (not sure) and
> MS-Access has "AutoValue" or however it might be in english. Thats 3 times a
> different name for basically the same thing.
>
> That's what I understood as dialect in the realm of IT systems.
> Maybe Hibernate uses just a certain subset of commands that is proven to
> work the same in every "dialect". This has the benefit that there is no
> special Hibernate for every DBMS but on the otherhand it omits advantages of
> individual DBMS which are not to be found in other DBMS' "dialects" of SQL.
>
>
>> How can we create our own Dialect ?
>
> You don't.
> They happen.
Well in Hibernate, you /could/ create your own Dialect if you wanted
to (it's an abstract base class) but they already have them
implemented for most any DBMS you can think of these days. It's more
common you'd override something in the dialect class that you want to
work differently.
