Personal tools

Web/Databases and Persistence

From HaskellWiki

< Web(Difference between revisions)
Jump to: navigation, search
m
m (Add acid-state)
(6 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
[[Category:Web|*]]
 
[[Category:Web|*]]
  +
{{Web infobox}}
   
 
Below is a list of databases that have been used or designed for web development. See also: [[Libraries_and_tools/Database_interfaces|Database Interfaces]]
 
Below is a list of databases that have been used or designed for web development. See also: [[Libraries_and_tools/Database_interfaces|Database Interfaces]]
   
== HDBC ==
+
== acid-state ==
   
HDBC (Haskell Database Connectivity) provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
+
acid-state is the successor of the now deprecated happstack-state and is completely free from any dependencies on happstack.
   
* HDBC provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
+
{| class="wikitable"
* 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.
+
! License
* HDBC is a from-scratch effort. It is not a reimplementation of HSQL, though its purpose is the same.
+
| Public Domain
  +
|-
  +
! Author:
  +
| David Himmelstrup
  +
|-
  +
! Home page:
  +
| http://acid-state.seize.it/
  +
|-
  +
! Documentation:
  +
| [http://mirror.seize.it/acid-state/examples/ Stand-alone examples], [http://happstack.com/docs/crashcourse/AcidState.html usage with Happstack] and [https://github.com/mightybyte/snaplet-acid-state/blob/master/examples/Site.hs usage with Snap].
  +
|-
  +
! Package & repositories
  +
| [http://hackage.haskell.org/package/acid-state Hackage] - [http://mirror.seize.it/acid-state/ Darcs]
  +
|}
   
'''License:''' LGPL
+
== happstack-state ==
   
'''Author:''' John Goerzen
+
happstack-state, also referred to as MACID, is a native Haskell persistent data store layer. It stores Haskell datatypes and queries are written in Haskell. Although it is part of the [[Happstack]] suite, it does not depend on happstack-server and can easily be used with other web frameworks.
   
'''Maintainer:''' John Goerzen <jgoerzen@complete.org>
+
In buzzword terms, happstack-state is a NoSQL, RAM-cloud which can store arbitrary Haskell datatypes.
   
'''Home page:''' http://github.com/jgoerzen/hdbc/wiki
 
   
'''Documentation:''' http://hackage.haskell.org/packages/archive/HDBC/latest/doc/html/Database-HDBC.html
+
{| class="wikitable"
  +
! License
  +
| BSD3
  +
|-
  +
! Author:
  +
| Happstack team, HAppS LLC
  +
|-
  +
! Maintainer:
  +
| Happstack team <[email protected]>
  +
|-
  +
! Home page:
  +
| http://happstack.com/index.html
  +
|-
  +
! Documentation:
  +
| http://happstack.com/docs
  +
|-
  +
! Package & repositories
  +
| [http://hackage.haskell.org/package/happstack Hackage] - [http://patch-tag.com/r/mae/happstack/pullrepo Darcs]
  +
|}
   
== Persistent ==
+
== HDBC ==
   
Persistent is a high-level, non-relational, type-safe persistence layer for Haskell. Its design allows it to be used on both SQL and non-SQL backends. Heavy usage of type families allows strong type guarantees, while usage of template haskell removes the need for boilerplate coding.
+
HDBC (Haskell Database Connectivity) provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
   
'''License:''' BSD3
+
* HDBC provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
  +
* 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.
  +
* HDBC is a from-scratch effort. It is not a reimplementation of HSQL, though its purpose is the same.
   
'''Author:''' Michael Snoyman <[email protected]>
+
{| class="wikitable"
  +
! License:
  +
| LGPL
  +
|-
  +
! Author:
  +
| John Goerzen
  +
|-
  +
! Maintainer:
  +
| John Goerzen <[email protected]>
  +
|-
  +
! Home page:
  +
| http://github.com/jgoerzen/hdbc/wiki
  +
|-
  +
! Documentation:
  +
| [http://hackage.haskell.org/packages/archive/HDBC/latest/doc/html/Database-HDBC.html Haddock]
  +
|}
   
'''Maintainer:''' Michael Snoyman <[email protected]>
+
== Persistent ==
   
'''Documentation:''' http://docs.yesodweb.com/persistent/
+
Persistent is a high-level, non-relational, type-safe persistence layer for Haskell. Its design allows it to be used on both SQL and non-SQL backends. Heavy usage of type families allows strong type guarantees, while usage of template haskell removes the need for boilerplate coding.
   
'''Packages & repositories'''
+
{| class="wikitable"
+
! License:
* Hackage: http://hackage.haskell.org/package/persistent
+
| BSD3
* Github: http://github.com/snoyberg/persistent
+
|-
  +
! Author:
  +
| Michael Snoyman <[email protected]>
  +
|-
  +
! Maintainer:
  +
| Michael Snoyman <[email protected]>
  +
|-
  +
! Documentation:
  +
| http://docs.yesodweb.com/book/persistent
  +
|-
  +
! Packages & repositories
  +
| [http://hackage.haskell.org/package/persistent Hackage] - [http://github.com/snoyberg/persistent Github]
  +
|}
   
 
== Takusen ==
 
== Takusen ==
Line 46: Line 46:
 
Currently we fully support ODBC, Oracle, Sqlite, and PostgreSQL.
 
Currently we fully support ODBC, Oracle, Sqlite, and PostgreSQL.
   
'''License:''' BSD3
+
{| class="wikitable"
+
! License:
'''Author:''' Alistair Bayley, Oleg Kiselyov
+
| BSD3
+
|-
'''Maintainer:''' [email protected], [email protected]
+
! Author:
+
| Alistair Bayley, Oleg Kiselyov
'''Announcement:''' http://www.haskell.org/pipermail/haskell-cafe/2010-July/081224.html
+
|-
+
! Maintainer:
'''Packages & repositories'''
+
| [email protected], [email protected]
+
|-
* Hackage: http://hackage.haskell.org/package/persistent
+
! Announcement:
* Darcs: http://code.haskell.org/takusen
+
| [http://www.haskell.org/pipermail/haskell-cafe/2010-July/081224.html Haskell-Cafe]
  +
|-
  +
! Packages & repositories
  +
| [http://hackage.haskell.org/package/Takusen Hackage] - [http://code.haskell.org/takusen Darcs]
  +
|}

Revision as of 19:41, 13 February 2012

Haskell Web Development

Software:
Servers - Libraries - Frameworks
Deploy - Cloud
Interfaces to frameworks
Databases and Persistence
Testing and Verification
Content Management

Community & Research:
Forums and Discussion
Literature (research, talks and blogs)
Existing Haskell web applications
Ongoing projects and ideas

Below is a list of databases that have been used or designed for web development. See also: Database Interfaces

Contents

1 acid-state

acid-state is the successor of the now deprecated happstack-state and is completely free from any dependencies on happstack.

License Public Domain
Author: David Himmelstrup
Home page: http://acid-state.seize.it/
Documentation: Stand-alone examples, usage with Happstack and usage with Snap.
Package & repositories Hackage - Darcs

2 happstack-state

happstack-state, also referred to as MACID, is a native Haskell persistent data store layer. It stores Haskell datatypes and queries are written in Haskell. Although it is part of the Happstack suite, it does not depend on happstack-server and can easily be used with other web frameworks.

In buzzword terms, happstack-state is a NoSQL, RAM-cloud which can store arbitrary Haskell datatypes.


License BSD3
Author: Happstack team, HAppS LLC
Maintainer: Happstack team <[email protected]>
Home page: http://happstack.com/index.html
Documentation: http://happstack.com/docs
Package & repositories Hackage - Darcs

3 HDBC

HDBC (Haskell Database Connectivity) provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)

  • HDBC provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
  • 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.
  • HDBC is a from-scratch effort. It is not a reimplementation of HSQL, though its purpose is the same.
License: LGPL
Author: John Goerzen
Maintainer: John Goerzen <[email protected]>
Home page: http://github.com/jgoerzen/hdbc/wiki
Documentation: Haddock

4 Persistent

Persistent is a high-level, non-relational, type-safe persistence layer for Haskell. Its design allows it to be used on both SQL and non-SQL backends. Heavy usage of type families allows strong type guarantees, while usage of template haskell removes the need for boilerplate coding.

License: BSD3
Author: Michael Snoyman <[email protected]>
Maintainer: Michael Snoyman <[email protected]>
Documentation: http://docs.yesodweb.com/book/persistent
Packages & repositories Hackage - Github

5 Takusen

Takusen is a DBMS access library. Like HSQL and HDBC, we support arbitrary SQL statements (currently strings, extensible to anything that can be converted to a string).

Takusen's unique selling point is safety and efficiency. We statically ensure all acquired database resources - such as cursors, connections, and statement handles - are released, exactly once, at predictable times. Takusen can avoid loading the whole result set in memory, and so can handle queries returning millions of rows in constant space. Takusen also supports automatic marshalling and unmarshalling of results and query parameters. These benefits come from the design of query result processing around a left-fold enumerator.

Currently we fully support ODBC, Oracle, Sqlite, and PostgreSQL.

License: BSD3
Author: Alistair Bayley, Oleg Kiselyov
Maintainer: [email protected], [email protected]
Announcement: Haskell-Cafe
Packages & repositories Hackage - Darcs