Projects tagged ‘db’

NEW: Latest release can be downloaded from http://dist.wso2.org/products/wsas/wso2wsas-2.2.zip * Data Services provides a simple mechanism to expose data stored in a relational data via a Web service API. • Data is no longer locked away in a ... [More] database but also available for mashing up with other data on the Web. * XML response is generated using database data. * Expose CRUD operations performed on a relational database to the outside world • Ability to use full power of the WS-* security stack • WSAS allows you to deploy data services in two ways •Deploy data service configuration file directly •Create the service using the UI wizard WSO2 Data Services specification - http://wso2.org/wiki/display/wsf/Data+Services+and+Resources [Less]

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.)

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

GreenSQL is a database firewall engine used to protect Open Source Databases from SQL injection attacks. It works in proxy mode. Application logics is based on evaluating of SQL commands using risk score factors, as well as blocking of administrative commands.

Sometimes, I need to store an eeny-weeny bit of data, but I want it nicely structured with Moose, but I don't want to mess with a bunch of setup and bootstrapping and blah blah blah. I just want to write my script. This provides a mechanism to do ... [More] that with very little overhead. There are aren't many frills either, so if you want something nicer, you'll have to build on or look into something else. [Less]

A binding to the tinycdb library by Michael Tokarev, which is a public domain implementation of Daniel J. Bernstein's Constant Database. Includes the tinycdb source so there are no external dependences.

KiokuDB is a persistent object graph manager for Perl. It uses multiple backends and layers on Moose's introspection and Search::GIN for indexing.

This is the PostgreSQL backend driver for the HDBC database infrastructure for Haskell.

This package provides an ODBC database ackend for the HDBC Haskell database infrastructure. It works on Windows as well as POSIX (Unix/Linux/BSD/Mac) platforms via unixODBC, iODBC, etc. This driver is the preferred way to access MySQL from HDBC.

This is the Sqlite version 3 backend for the Haskell HDBC database infrastructure.

As stated in the summary, this simple library allows you to access your MySQL (you can modify it to use other databases) tables, and at the same time, protect yourself from SQL Injections. Other features include type checking, and error exceptions ... [More] that makes it simple to return errors to your forms (Like Django) This library is inspired by Django models. [Less]

Logs Django exceptions to your database handler. Installation InstructionsDownload and install the package using distutils: If you are using any version of Django 1.0 or newer (newforms-admin): svn checkout ... [More] http://django-db-log.googlecode.com/svn/branches/newforms-admin/ django-db-log cd django-db-log sudo python setup.py installFor older versions: svn checkout http://django-db-log.googlecode.com/svn/trunk/ django-db-log cd django-db-log sudo python setup.py installUpdate your settings.py and add the middleware and installed apps settings: MIDDLEWARE_CLASSES = ( 'django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'djangodblog.DBLogMiddleware', ) INSTALLED_APPS = ( 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'djangodblog', )Finally, run python manage.py syncdb to create the database tables. UsageYou will find two new admin panels in the automatically built Django administration: Errors Error batchs It will store every single error inside of "Errors", and it will store a collective, or summary, of errors inside of Error batchs (this is more useful for most cases). [Less]

A new Framework that called project emr. It has many new functions that mixes all of the other web frameworks

A Django Crash Logger Derived from django-db-log by David Cramer.

Zend Framework library extension

DescriptionSimilar to 'rake migrate' for Ruby on Rails this library lets you manage database upgrades for your Java applications. SetupChoose a version table name for your database. The default is db_version. Choose a package within which you will ... [More] store all your classes and scripts for migrations. Create a directory within that package named after your database (in lowercase, e.g. mysql). Create a script in that directory named migrate0.sql and in that script create the version table and insert version 1, e.g: CREATE TABLE db_version (version integer not null) ENGINE=InnoDB; INSERT INTO db_version VALUES (1);RuntimeBefore accessing your database in your programs you need to create a Migrate instance with the appropriate database configuration. Make sure the version is set to the version of the program accessing the database. Call migrate() on your Migrate instance to ensure that your client version matches the database version. If you have enabled 'auto' and don't specify a client version it will look at the database version it will scan for more recent migrations. You have a few options for defining migrations. As far as code they can be either Java, Groovy or SQL. As far as version transition they can define either 'to' or 'from' flavors. The 'from' flavor is used when you may want to skip versions while the 'to' flavor is for when you want the target database version to be the same as the version number in script and don't mind the reduced flexibility. Attempt to use a migration class: packageName + databaseName + ".Migrate(To/From)" + dbVersion If class in 1 not found, use a migration script: pacakge dir + "/" + databaseName + "/migrate(to/from)" + dbVersion + ".sql" If script in 2 not found, attempt to use a generic migration class: packageName + ".Migrate(To/From)" + dbVersion If class in 3 not found, use a generic migration script: pacakge dir + "/migrate(to/from)" + dbVersion + ".sql" It will return once the client version and database version are equal. It will throw an exception if anything happens that stops that from being true. It is safe to run the migration from many different programs at the same time due to the locking that it does (in most databases). It is also safe to run it multiple times. ImplementationAlways migrate before the first access to your database in a program Never upgrade a database in use without a strategy for discovering that its been upgraded Try to use generic DDL whenever you can if you expect to use more than one type of database with your application FutureDDL layer that understands different databases Integration with JPA and other data access frameworks LOC [Less]

An implimentation of the object relational mapping idea in ruby.

Allows easy creation and manipulation of database records. Inspired by Ruby on Rails. The class will be updated in January 2007

RestDB is a framework, means you can expose any database with a RESTful service. The main concept of RestDB is CoC (Convention over Configuration), With the framework, you can access your database with a RESTful URI, For example, you have a ... [More] MySQL database, and the database name is Blog, it contains a table named Users, and you suppose to access the data in the users with the following URI: http://localhost/blog/usersAnd if in a browser, it should return a page to you, and it's just like the Scaffolding you ever seen in other frameworks like RoR(Ruby on Rails) You can also work with RestDB in a programmatic way. Read more in our wiki Page. All in all, with RestDB, you can expose your database as a simple web service. [Less]

GWT-PFGWT Pleso Framework is a high-level framework based on Google Web Toolkit (GWT) for creating visual AJAX database front-end user interfaces. It's some a kind of more complex CRUD framework. GWT Pleso Framework enables you to create ... [More] automatically generated user interface based on business-logic classes. It provides control panel solutions for: database enterprise projects; other relation-based projects. web-site management; It has a set of components for manipulating user data such as DataGrid, DataTextBox, DataComboBox etc. Project highlightsclear, Java interfaces based model customizable automatically generated user forms user-input validation system flexible support for related data (child forms) authentication, authorization system error handling replaceable windows manager localization system paged data view text, numeric, date, time, enumeration, selection data controls ScreenshotsScreen from demo app - validation in add form, more - in gallery: Overview of GWT application architecture based on GWT-PFTypical example of GWT application architectureOne of the classical approaches in the software design is a three-level architecture, where higher levels depend on lower: presentation layer - user interface (UI); business logic layer (BL); data access layer (DAL). In GWT application those layers can be shared between client and server as follows: On client-side: presentation layer business logic layer data access interfaces (GWT-RPC Client), data classes On server-server: data access layer implementation (GWT-RPC server) database The scheme below clearly shows the dependence between packages of each layer on client and server sides. Component scheme of GWT application architecture based on GWT-PF. Source code allocation example (click on scheme to view full size image). GWT-PF role in GWT applicationA typical requirement for information systems is the development of a large number of similar reference books and forms for data manipulation. These elements are presentation layer components. There are two general approaches to develop them: Creating of separate classes which represents visual component for each form. Creating universal visual components that can represent any form of the system. The obvious is the fact that the first variant more labor for a large system. gwt-pf-ui package is a set of universal visual components, which can be used to display almost any reference books and forms. So when building a system it is possible to use those components, significantly reducing the resources for the development of a presentation layer. Visual components in gwt-pf-ui works with the business logic via interfaces of gwt-pf-core package. The implementation of business logic and data access layer of the application ill be presented by set of classes implementing interfaces from gwt-pf-core. Rapid development with GWT-PFIt is obvious that gwt-pf-ui is profitable in terms of code reuse and mostly implemented presentation layer. Moreover the existence of business logic interface with gwt-pf-core applies tested business logic development methodology. [Less]

Guice container を使用した Web-DB フレームワークHTML/SQLにコメントの形でプログラム的な要素を埋め込むテンプレートエンジン intarface と SQL のみによる O/Rマッパー uri と process ... [More] を紐付ける形でのルーター process を多段で uri に紐付ける事が可能 repository/core でフレームワークのソースコード /text でフレームワークを使用したサンプルコードがチェックアウト可能です [Less]

Persephone is a data abstraction mechanism. Its purpose is to remove all the tedious parts of working with databases and lets you focus on real code. Standard searching, loading, and saving of data to/from databases is handled automatically -- along ... [More] with protection for data types and incorrect operations. Beyond persistence Persephone can also generate HTML listings and Forms for your data. Unlike ActiveRecord style systems, Persephone assumes you have a lot of existing code and/or and existing database and have no ability, nor desire, to completely replace it. Thus Persephone operates in a miminally invasive manner, by being very clear about what it is doing, and operating happily alongside alternate solutions. There are no method assumptions, no prescriptive behaviours, and basically nothing that will make curse the solution. Currently Persephone supports PHP code generation. Other targets are possible, the source schema language is not PHP specific. [Less]