From Fedora Project Wiki
(added big list of package reviews)
(→‎SQL Parsing: rename section)
 
(22 intermediate revisions by the same user not shown)
Line 2: Line 2:


== RDBMS ==
== RDBMS ==
{| border="1"
* postgres
|-
* mysql
! Software !! Review Request !!
* sqlite
|-
* mingw32-sqlite : Bug 467407 - Review Request: mingw32-sqlite - MinGW Windows port of sqlite embeddable SQL database engine
| postgres ||                ||
* bdb
|-
* firebird [https://bugzilla.redhat.com/show_bug.cgi?id=498790 498790]
| mysql    ||                ||
* [http://db.apache.org/derby/ Apache Derby]
|-
 
| sqlite   ||                ||
What about the MySQL diaspora?
|-
* [http://askmonty.org/wiki/index.php/MariaDB MariaDB]
| bdb     ||                ||
* [https://launchpad.net/drizzle Drizzle]
|-
| firebird ||[https://bugzilla.redhat.com/show_bug.cgi?id=498790 498790]||
|}


== Tools for working with databases ==
== Tools for working with databases ==
* openoffice-base
* openoffice-base
* crunchyfrog
* crunchyfrog
* tora
* tora http://tora.sourceforge.net/ appears to have been dropped between FC-3 and FC-4.  See [https://bugzilla.redhat.com/show_bug.cgi?id=167356 bug 167356] for notes if anyone wants to take this one up.
* teiid
* teiid
plus schema visualizers, etc etc
* [http://www.eclipse.org/datatools/ Eclipse Data Tools]
 
== Schema Visualizers ==
* [http://schemaspy.sourceforge.net/ schemaspy]
* [http://mkweb.bcgsc.ca/schemaball/?home Schemaball]
* [http://oraschemadoc.yarpen.cz/ Oraschemadoc]


== Test Suites ==
== Test Suites ==


== Other stuff ==
== Other stuff ==
* show/squeal/tabulate
* [https://bugzilla.redhat.com/show_bug.cgi?id=492816 squeal]
* Tutorial D?
* Tutorial D?
* XML databases?
* XML databases?
* SPARQL?
* SPARQL?
* Object databases?
* Object databases?
* [http://buzhug.sourceforge.net/ buzhug] a pure-Python database engine with a Pythonic syntax, not SQL


== Various packages ==
== Various packages ==
* Bug 484511 -  Review Request: crunchyfrog - A multi-engine SQL client and database front-end
* Bug 487978 - Review Request: sqlitebrowser - Design and edit database files compatible with SQLite
* Bug 446990 -  (python-axiom) Review Request: python-axiom - An in-process object-relational database
* Bug 446990 -  (python-axiom) Review Request: python-axiom - An in-process object-relational database
* Bug 496688 -  Review Request: monodevelop-database - Addin for MonoDevelop for an integrated database explorer and editor
* Bug 437574 -  Review Request: ruby-pg - A Ruby interface for the PostgreSQL database engine
* Bug 474044 -  Review Request: libzdb - A small, fast, and easy to use database API
* Bug 474044 -  Review Request: libzdb - A small, fast, and easy to use database API
* Bug 166201 - Review Request: perl-Ima-DBI : Database connection caching and organization
* Bug 166201 - Review Request: perl-Ima-DBI : Database connection caching and organization
* Bug 477818 -  Review Request: gsql - Integrated database development tool for GNOME 
* Bug 239156 -  (DBIx-SQLite-Simple) Review Request: perl-DBIx-SQLite-Simple - Easy access to SQLite databases using objects
* Bug 239156 -  (DBIx-SQLite-Simple) Review Request: perl-DBIx-SQLite-Simple - Easy access to SQLite databases using objects
* Bug 438587 -  Review Request: libsqlite3x - C++ Wrapper for the SQLite3 database engine
* Bug 467407 -  (mingw32-sqlite) Review Request: mingw32-sqlite - MinGW Windows port of sqlite embeddable SQL database engine
* Bug 196793 -  (php-pear-MDB2) Review Request: php-pear-MDB2 - Database Abstraction Layer  
* Bug 196793 -  (php-pear-MDB2) Review Request: php-pear-MDB2 - Database Abstraction Layer  
* Bug 256521 -  Review Request: php-pear-Creole - A database abstraction layer for PHP5
* Bug 256521 -  Review Request: php-pear-Creole - A database abstraction layer for PHP5
* Bug 166207 -  Review Request: rekall : A KDE database front-end application
* Bug 175895 -  Review Request: perl-DBD-XBase - Perl module for reading and writing the dbf files
* Bug 201437 -  Review Request: Glom - Database designer
* Bug 471522 -  Review Request: otl - OTL library for database connections and queries
* Bug 471522 -  Review Request: otl - OTL library for database connections and queries
* Bug 477570 -  Review Request: couchdb - A document database server, accessible via a RESTful JSON API
* Bug 477570 -  Review Request: couchdb - A document database server, accessible via a RESTful JSON API
* Bug 461376 -  Review Request: itzam-core - Library for creating and manipulating keyed-access database files
* Bug 491425 -  Review Request: R-RODBC - An ODBC database interface for R
* Bug 260441 -  Review Request: pguiman - The PostgreSQL database server managing tool  
* Bug 260441 -  Review Request: pguiman - The PostgreSQL database server managing tool  
* Bug 479895 -  Review Request: perl-DDL-Oracle - DDL generator for Oracle databases  
* Bug 479895 -  Review Request: perl-DDL-Oracle - DDL generator for Oracle databases  
* Bug 250093 -  Review Request: dbxml - An embeddable XML database
* Bug 250093 -  Review Request: dbxml - An embeddable XML database
* Bug 251419 -  Review Request: mdbtools - Access data stored in Microsoft Access databases
* Bug 175896 -  Review Request: perl-SQL-Statement - SQL parsing and processing engine
* Bug 209965 -  Review Request: ruby-bdb - Berkeley DB is an embedded database system that supports keyed access to data
* Bug 229478 -  Review Request: qdbm - Quick Database Manager  
* Bug 229478 -  Review Request: qdbm - Quick Database Manager  
* Bug 251020 -  Review Request: libflaim - Flaim Database Engine
* Bug 251020 -  Review Request: libflaim - Flaim Database Engine
* Bug 434691 -  Review Request: ocaml-postgresql - OCaml library for accessing PostreSQL databases
* Bug 434699 -  Review Request: ocaml-mysql - OCaml library for accessing MySQL databases
* Bug 434703 -  Review Request: ocaml-sqlite - OCaml library for accessing SQLite3 databases
* Bug 440679 -  Review Request: lua-sql - Database connectivity for Lua
* Bug 454564 -  Review Request: pymssql - A simple database interface to MS-SQL for Python
* Bug 459881 - Review Request: rubygem-sqlite3-ruby - Allows Ruby scripts to interface with a SQLite3 database
* Bug 199784 -  Review Request: python-psycopg2 - A PostgreSQL database adapter for Python
* Bug 427171 -  Review Request: sqliteman - Manager for sqlite - Sqlite Databases Made Easy  
* Bug 427171 -  Review Request: sqliteman - Manager for sqlite - Sqlite Databases Made Easy  
* Bug 494148 -  Review Request: soci - The database access library for C++ programmers
* Bug 402141 -  Review Request: tokyocabinet - A modern implementation of a DBM
* Bug 402141 -  Review Request: tokyocabinet - A modern implementation of a DBM
* Bug 231753 -  Review Request: perl-DBD-Mock - Mock database driver for testing
* Bug 231753 -  Review Request: perl-DBD-Mock - Mock database driver for testing
* sedna XML database: http://modis.ispras.ru/sedna/
* xindice: http://xml.apache.org/xindice/
* http://basex.org/
* MonetDB: http://monetdb.cwi.nl/XQuery/
* Duro: http://duro.sourceforge.net/
* EnterpriseDB (as opposed to postgres): http://www.enterprisedb.com/products/download.do
* http://www.heidisql.com/ - Win32 only?
* http://www.mcobject.com/perst
* http://www.db4o.com/
== Frontends ==
* Bug 201437 -  Review Request: Glom - Database designer
* knoda: http://knoda.sourceforge.net/
* knoda: http://knoda.sourceforge.net/
* kexi
* kexi
* Bug 484511 -  Review Request: crunchyfrog - A multi-engine SQL client and database front-end
* Bug 487978 - Review Request: sqlitebrowser - Design and edit database files compatible with SQLite
* Bug 496688 -  Review Request: monodevelop-database - Addin for MonoDevelop for an integrated database explorer and editor
* Bug 477818 -  Review Request: gsql - Integrated database development tool for GNOME 
* Bug 166207 -  Review Request: rekall : A KDE database front-end application
* [http://www.squirrelsql.org/ SQuirreL SQL Client]
== Language/RDBMS Connectivity ==
Under construction: the giant connectivity Matrix of Doom (why does every language/runtime need to have its own set of connectivity routines for each type of database?)
{|
| backend/runtime
! perl
! python
! ocaml
! ruby
|-
! mysql
|
|
| [[rhbug:434699|ocaml-mysql]]
|
|-
! postgres
|
| [[rhbug:199784|python-psycopg2]]
| [[rhbug:434691|ocaml-postgresql]]
| [[rhbug:437574|ruby-pg]]
|-
! sqlite
|
|
| [[rhbug:434703|ocaml-sqlite]]
| [[rhbug:459881|rubygem-sqlite3-ruby]]
|-
|}
* Bug 440679 -  Review Request: lua-sql - Database connectivity for Lua
* Bug 454564 -  Review Request: pymssql - A simple database interface to MS-SQL for Python
* Bug 438587 -  Review Request: libsqlite3x - C++ Wrapper for the SQLite3 database engine
* Bug 494148 -  Review Request: soci - The database access library for C++ programmers
* Bug 491425 -  Review Request: R-RODBC - An ODBC database interface for R
* Bug 209965 -  Review Request: ruby-bdb - Berkeley DB is an embedded database system that supports keyed access to data
== Reading database files ==
* Bug 175895 -  Review Request: perl-DBD-XBase - Perl module for reading and writing the dbf files
* Bug 251419 -  Review Request: mdbtools - Access data stored in Microsoft Access databases
* Bug 461376 -  Review Request: itzam-core - Library for creating and manipulating keyed-access database files
== Parsing the SQL language ==
* http://code.google.com/p/python-sqlparse/  I've submitted this for review here: https://bugzilla.redhat.com/show_bug.cgi?id=500928
* Bug 175896 -  Review Request: perl-SQL-Statement - SQL parsing and processing engine


== Review Stalled ==
== Review Stalled ==

Latest revision as of 13:05, 7 August 2009

Towards creating a list of Free database software..

RDBMS

  • postgres
  • mysql
  • sqlite
  • mingw32-sqlite : Bug 467407 - Review Request: mingw32-sqlite - MinGW Windows port of sqlite embeddable SQL database engine
  • bdb
  • firebird 498790
  • Apache Derby

What about the MySQL diaspora?

Tools for working with databases

Schema Visualizers

Test Suites

Other stuff

  • squeal
  • Tutorial D?
  • XML databases?
  • SPARQL?
  • Object databases?
  • buzhug a pure-Python database engine with a Pythonic syntax, not SQL

Various packages

  • Bug 446990 - (python-axiom) Review Request: python-axiom - An in-process object-relational database
  • Bug 474044 - Review Request: libzdb - A small, fast, and easy to use database API
  • Bug 166201 - Review Request: perl-Ima-DBI : Database connection caching and organization
  • Bug 239156 - (DBIx-SQLite-Simple) Review Request: perl-DBIx-SQLite-Simple - Easy access to SQLite databases using objects
  • Bug 196793 - (php-pear-MDB2) Review Request: php-pear-MDB2 - Database Abstraction Layer
  • Bug 256521 - Review Request: php-pear-Creole - A database abstraction layer for PHP5
  • Bug 471522 - Review Request: otl - OTL library for database connections and queries
  • Bug 477570 - Review Request: couchdb - A document database server, accessible via a RESTful JSON API
  • Bug 260441 - Review Request: pguiman - The PostgreSQL database server managing tool
  • Bug 479895 - Review Request: perl-DDL-Oracle - DDL generator for Oracle databases
  • Bug 250093 - Review Request: dbxml - An embeddable XML database
  • Bug 229478 - Review Request: qdbm - Quick Database Manager
  • Bug 251020 - Review Request: libflaim - Flaim Database Engine
  • Bug 427171 - Review Request: sqliteman - Manager for sqlite - Sqlite Databases Made Easy
  • Bug 402141 - Review Request: tokyocabinet - A modern implementation of a DBM
  • Bug 231753 - Review Request: perl-DBD-Mock - Mock database driver for testing
  • sedna XML database: http://modis.ispras.ru/sedna/
  • xindice: http://xml.apache.org/xindice/
  • http://basex.org/
  • MonetDB: http://monetdb.cwi.nl/XQuery/
  • Duro: http://duro.sourceforge.net/
  • EnterpriseDB (as opposed to postgres): http://www.enterprisedb.com/products/download.do
  • http://www.heidisql.com/ - Win32 only?
  • http://www.mcobject.com/perst
  • http://www.db4o.com/

Frontends

  • Bug 201437 - Review Request: Glom - Database designer
  • knoda: http://knoda.sourceforge.net/
  • kexi
  • Bug 484511 - Review Request: crunchyfrog - A multi-engine SQL client and database front-end
  • Bug 487978 - Review Request: sqlitebrowser - Design and edit database files compatible with SQLite
  • Bug 496688 - Review Request: monodevelop-database - Addin for MonoDevelop for an integrated database explorer and editor
  • Bug 477818 - Review Request: gsql - Integrated database development tool for GNOME
  • Bug 166207 - Review Request: rekall : A KDE database front-end application
  • SQuirreL SQL Client

Language/RDBMS Connectivity

Under construction: the giant connectivity Matrix of Doom (why does every language/runtime need to have its own set of connectivity routines for each type of database?)

backend/runtime perl python ocaml ruby
mysql ocaml-mysql
postgres python-psycopg2 ocaml-postgresql ruby-pg
sqlite ocaml-sqlite rubygem-sqlite3-ruby
  • Bug 440679 - Review Request: lua-sql - Database connectivity for Lua
  • Bug 454564 - Review Request: pymssql - A simple database interface to MS-SQL for Python
  • Bug 438587 - Review Request: libsqlite3x - C++ Wrapper for the SQLite3 database engine
  • Bug 494148 - Review Request: soci - The database access library for C++ programmers
  • Bug 491425 - Review Request: R-RODBC - An ODBC database interface for R
  • Bug 209965 - Review Request: ruby-bdb - Berkeley DB is an embedded database system that supports keyed access to data

Reading database files

  • Bug 175895 - Review Request: perl-DBD-XBase - Perl module for reading and writing the dbf files
  • Bug 251419 - Review Request: mdbtools - Access data stored in Microsoft Access databases
  • Bug 461376 - Review Request: itzam-core - Library for creating and manipulating keyed-access database files

Parsing the SQL language

Review Stalled

  • Bug 239968 - Review Request: mdbtools - tools for extracting things from Access databases
  • Bug 443578 - Review Request: monodevelop-database - database plugin for monodevelop
  • Bug 253191 - Exist XML database

Can't include

  • Bug 201489 - Review Request: FreeTDS - libraries for MS SQL and Sybase databases