Managed Hosting



DataFaucet ORM
Project Home Blog Forums Wiki Known Issues External Project Link Contact Project

Author: Samuel Isaac Dealey (All RIAForge projects by this author)
Last Updated: September 9, 2015 9:12 AM
Version: 1.3 RC
Views: 151,569
Downloads: 2,848
License: BSD


Data Faucet is a SQL/Database abstraction and Object Relational Modeling (ORM) tool.

Why DataFaucet? The goal is to make data access as simple as getting water from your kitchen sink: a faucet for your data.


- Traditional ORM object-synchronization
- ActiveRecord objects
- Simple Gateway Objects
- Low-level abstraction of the SQL language, e.g. ds.select_col_from_table_where_col2_is(url.x)
- Makes complex query tasks simple, e.g. getSelect(table="mytable").andOrFilter("col1,col2,col3", form.search).execute()

Check out the official site http://www.datafaucet.com for documentation and code samples

Recent Blog Entries:

Last Update:

Version 1.3 RC

Sep 9 2015 - FIX - and/or filter separating keywords when locale-specific and/or keywords are found within a word, e.g. "sandman" produces a search for "s and man" or "ford" produces a search for "f or d" - fix requires white-space on both sides of the keyword


ColdFusion 7

Issue Tracker:

8 IN filter foreign keys in CollectionFilter Fixed 04/29/14 11:02 PM
11 Filters = URL creates incorrect filter sql Open 05/05/12 9:13 PM
10 Binary columns not saving data during insert/update Open 02/06/09 11:10 AM
9 waterlog calling non-existent method Fixed 11/06/08 3:11 PM
2 Feature Request - Collection Filters - Dates and Numbers Fixed 08/09/08 10:18 PM

View All Issues

To enter issues for this (or any other) project, you must be logged in.

Subversion Access:

You may access this project's Subversion repository with your client here: http://svn.riaforge.org/datafaucet.

To view files and changelists associated with this repository, go here: http://datafaucet.riaforge.org/index.cfm?event=page.svnbrowse.

Anonymous users have read access to the repository while the administrator has write access.

This project is sharing its code via Subversion. Subversion is an open source source control method. You may find more information about Subversion here: http://subversion.tigris.org/