Re: Database in Redhat Linux

>>Its a pity for Linux World, that most hype is done by people who don't >>know what real database is. So they promote mySQL which is no more >>than fast flat-file search engine with SQL-like syntax. Amen! The prevalence of myMSQL for Open Source project is a major irritant for anyone using those project to do real work. >And it's a real pity that there are so many people who think that the >only valid type of database is a SQL database. But applications have to live in the real world. And the real world, from gnome-db to Crystal Reports does SQL. >>So, only free database is PostgreSQL. But PostgreSQL start to >>resemble real database only since 7.0 version, becouse before there >>was no foreign keys. I would consider that it IS a database, not RESEMBLES [..snipped..] >I think you mean the only free *relational* database - which is not the >same thing at all. There are much better databases out there. While I >would strongly suggest that all database programmers should know >relational theory (it helps design immensely), there are a load of far >better databases out there. SQL and relational databases put >theoretical purity above practicality and functionality, which is why >Oracle is such a beast - I could probably write programs that run faster, >do more, and handle larger datasets, and all on a system half the size! >ust because I don't believe "relational is best". Why not code your App to use ODBC? Then I can use any db I want. unixODBC gives you the ODBC API on several UNIX platforms, and you already have it on Win32. I wish more projects would take this approach so I can use the DB I already have (be it Informix or PostgreSQL) and relate the data generated from that application to data from other applications . . . I mean WOW what a concept. ;) Informix, Oracle, etc... already have ODBC for every platform under the sun (pun!), and unixODBC provides drivers for several of the freebee db engines. Systems and Network Administrator Morrison Industries 1825 Monroe Ave NW. Grand Rapids, MI. 49505

Adam Tauno Williams wrote in message <900eoi$7j7m that >application to data from other applications . . . I mean WOW what >a concept. ;) Informix, Oracle, etc... already have ODBC for every platform >under the sun (pun!), and unixODBC provides drivers for several of the >freebee db engines. JDBC is the best. Java access and can use ODBC sources, via the JDBC-ODBC bridge so it is a superset of ODBC. Type 4 (Pure java) JDBC drivers are truely platform independent as well. One driver for ALL platforms, no Solaris version, HP version, ..."Oh we havn't made a version for your OS yet"... "One driver to..and in the darkness bind them" I'm feeling very "Lord of the Rings" today! David. > >Systems and Network Administrator >Morrison Industries >1825 Monroe Ave NW. >Grand Rapids, MI. 49505