Difference between revisions of "Applications and libraries/Database interfaces"
Jump to navigation
Jump to search
m (Added link to orphan "HDBC-Example" page) |
|||
| (12 intermediate revisions by 6 users not shown) | |||
| Line 8: | Line 8: | ||
;[http://hackage.haskell.org/package/DSH Database Supported Haskell] |
;[http://hackage.haskell.org/package/DSH Database Supported Haskell] |
||
| − | :DSH is a Haskell library for database-supported program execution. Using this |
+ | :DSH is a Haskell library for database-supported program execution. Using this library a relational database management system (RDBMS) can be used as a coprocessor for the Haskell programming language, especially for those program fragments that carry out data-intensive and data-parallel computation. |
| − | library a relational database management system (RDBMS) can be used as a |
||
| − | coprocessor for the Haskell programming language, especially for those program |
||
| − | fragments that carry out data-intensive and data-parallel computation. |
||
| ⚫ | |||
| − | Database executable program fragments can be written using the list |
||
| ⚫ | : HDBC is modeled loosely on Perl's DBI interface, though it has also been influenced by Python's DB-API v2, JDBC in Java, and HSQL in Haskell. Supports SQLite3, PostgreSQL, ODBC (including MySQL). ([http://hackage.haskell.org/cgi-bin/hackage-scripts/package/HDBC HDBC in Hackage]; [[HDBC-Example|an example of its use]].) |
||
| − | comprehension notation (with modest syntax changes due to quasiquoting) and |
||
| − | list processing combinators from the Haskell list prelude. Note that rather |
||
| − | than embedding a relational language into Haskell, we turn idiomatic Haskell |
||
| − | programs into SQL queries. |
||
| + | ;[https://github.com/m4dc4p/haskelldb HaskellDB] |
||
| − | DSH faithfully represents list order and nesting, and compiles the list |
||
| − | processing combinators into relational queries. The implementation avoids |
||
| − | unnecessary data transfer and context switching between the database |
||
| − | coprocessor and the Haskell runtime by ensuring that the number of generated |
||
| − | relational queries is only determined by the program fragment's type and not |
||
| − | by the database size. |
||
| + | : HaskellDB is a combinator library for expressing queries and other operations on relational databases in a type safe and declarative way. All the queries and operations are completely expressed within Haskell, no embedded (SQL) commands are needed. |
||
| − | DSH can be used to allow existing Haskell programs to operate on large scale |
||
| − | data (e.g., larger than the available heap) or query existing database |
||
| − | resident data with Haskell. |
||
| + | : Both the [http://www.haskell.org/haskellDB original version from Daan Leijen's] HaskellDB and the [https://github.com/m4dc4p/haskelldb HaskellDB more up-to-date GitHub version] (works with latest GHC versions) are relatively platform-independent. |
||
| ⚫ | |||
| ⚫ | |||
| + | : This close integration makes it possible to do arbitrary computations on the database (like computing the transitive closure). ([http://hackage.haskell.org/cgi-bin/hackage-scripts/package/haskelldb HaskellDB in Hackage]) |
||
| − | ;[[/HaskellDB/]] |
||
| − | :Daan Leijen's [http://www.haskell.org/haskellDB original] HaskellDB, and an [http://haskelldb.sourceforge.net/ updated] version that works with current Haskell implementations and is relatively platform-independent. HaskellDB is a combinator library for expressing queries and other operations on relational databases in a type safe and declarative way. All the queries and operations are completely expressed within Haskell, no embedded (SQL) commands are needed. This close integration makes it possible to do arbitrary computations on the database (like computing the transitive closure). ([http://hackage.haskell.org/cgi-bin/hackage-scripts/package/haskelldb HaskellDB in Hackage]) |
||
| + | ;[http://hackage.haskell.org/cgi-bin/hackage-scripts/package/BerkeleyDBXML-0.1 Berkeley DB/DB XML binding] |
||
| − | ;Berkeley DB/DB XML binding |
||
:See [http://hackage.haskell.org/cgi-bin/hackage-scripts/package/BerkeleyDBXML-0.1 BerkeleyDBXML in Hackage] |
:See [http://hackage.haskell.org/cgi-bin/hackage-scripts/package/BerkeleyDBXML-0.1 BerkeleyDBXML in Hackage] |
||
| − | |||
| ⚫ | |||
| ⚫ | |||
;[http://sourceforge.net/forum/forum.php?forum_id=350240 HSQL] |
;[http://sourceforge.net/forum/forum.php?forum_id=350240 HSQL] |
||
| − | :HSQL is a simple library which provides an interface to multiple databases. MySQL, PostgreSQL, ODBC, SQLite and Oracle are currently supported. It is part of [http://htoolkit.sourceforge.net/ HToolkit]. |
+ | :HSQL is a simple library which provides an interface to multiple databases. MySQL, PostgreSQL, ODBC, SQLite and Oracle are currently supported. It is part of [http://htoolkit.sourceforge.net/ HToolkit]. ([http://hackage.haskell.org/package/hsql HSQL in Hackage]) |
| + | ;[http://hackage.haskell.org/package/mysql-simple mysql-simple], [http://hackage.haskell.org/package/postgresql-simple postgresql-simple], [http://hackage.haskell.org/package/sqlite-simple sqlite-simple] |
||
| − | :HSQL's cabal package is not yet updated for GHC 6.8, but there are [http://berlinbrowndev.blogspot.com/2008/02/haskell-snippet-crud-operations-with.html install instructions for GHC 6.8] . ([http://hackage.haskell.org/cgi-bin/hackage-scripts/package/hsql HSQL in Hackage]) (''Package updated: 2007; Instructions updated: 2008'') |
||
| + | :The *-simple packages provide a mid-level database interface to MySQL, PostgreSQL and SQLite. They each have a similar API but do not attempt to generalize to cover multiple database implementations under a single library. This enables each library to expose database-specific features. These libraries rely on SQL queries embedded as strings but do support automatically converting fields to/from the database to Haskell types. |
||
| + | |||
| + | ;[http://hackage.haskell.org/package/hasql Hasql] |
||
| + | :A minimalistic general high level API for relational databases |
||
| + | |||
| ⚫ | |||
| ⚫ | |||
Revision as of 05:21, 24 April 2021
Libraries
Current
- Takusen
- A library to interface to Oracle, Sqlite, and Postgres, with an API based on a left-fold enumerator. Now hosted at code.haskell.org. (Takusen in Hackage)
- Database Supported Haskell
- DSH is a Haskell library for database-supported program execution. Using this library a relational database management system (RDBMS) can be used as a coprocessor for the Haskell programming language, especially for those program fragments that carry out data-intensive and data-parallel computation.
- HDBC
- HDBC is modeled loosely on Perl's DBI interface, though it has also been influenced by Python's DB-API v2, JDBC in Java, and HSQL in Haskell. Supports SQLite3, PostgreSQL, ODBC (including MySQL). (HDBC in Hackage; an example of its use.)
- HaskellDB is a combinator library for expressing queries and other operations on relational databases in a type safe and declarative way. All the queries and operations are completely expressed within Haskell, no embedded (SQL) commands are needed.
- Both the original version from Daan Leijen's HaskellDB and the HaskellDB more up-to-date GitHub version (works with latest GHC versions) are relatively platform-independent.
- This close integration makes it possible to do arbitrary computations on the database (like computing the transitive closure). (HaskellDB in Hackage)
- HSQL
- HSQL is a simple library which provides an interface to multiple databases. MySQL, PostgreSQL, ODBC, SQLite and Oracle are currently supported. It is part of HToolkit. (HSQL in Hackage)
- mysql-simple, postgresql-simple, sqlite-simple
- The *-simple packages provide a mid-level database interface to MySQL, PostgreSQL and SQLite. They each have a similar API but do not attempt to generalize to cover multiple database implementations under a single library. This enables each library to expose database-specific features. These libraries rely on SQL queries embedded as strings but do support automatically converting fields to/from the database to Haskell types.
- Hasql
- A minimalistic general high level API for relational databases
Non-current
Move these to [#Current] if they are updated.
Discontinued
- CoddFish
- PURe See a separate Haskell Wiki page on it. It is another type safe and declarative approach to database managament in Haskell. (Development discontinued in 2006)
- VooDooM
- PURe VooDooM reads VDM-SL specifications and applies transformation rules to the datatypes that are defined in them to obtain a relational representation for these datatypes. The relational representation can be exported as VDM-SL datatypes (inserted back into the original specification) or SQL table definitions (which can be fed to a relational DBMS). (Development discontinued in 2006)
- HaSQL
- HaSQL is a Haskell to ODBC interface. HaSQL allows Haskell program to run SQL queries against an ODBC compliant database. Queries with parameters are supported. Data is retrieved from the database as a lazy list. (Development dicontinued.)
- MySQL-HS
- MySQL-HS is an interface to the MySQL database.
- Note: Development was discontinued on 2004-09-21.
Hackage
Related concepts
This page contains a list of libraries and tools in a certain category. For a comprehensive list of such pages, see Applications and libraries.