Projects tagged ‘database’, ‘postgres’, and ‘sql’

phpPgAdmin is a fully functional PHP-based administration package for PostgreSQL. It has all the basic functionality you need to completely administer a PosgreSQL server and/or database, including the ... [More] ability to administer views, sequences, stored procedures, and triggers. Features include the ability to create and drop databases; create, copy, drop, and alter tables/views/sequences/functions/triggers; edit and add fields (to the extent Postgres allows); execute any SQL-statement, even batch-queries; manage keys on fields; create and read dumps of database and tables; and administer one single database, multiple servers, and Postgres users/groups/roles. [Less]

BlackRay is a relational database system designed to offer performance features commonly associated with search engines. It offers SQL support and sophisticated operational and management features. ... [More] Load-balancing and operational stability by means of N+1 redundance are included. BlackRay is called a "Data Engine" since it combines traditional, relational database features and SQL with the power and flexibility of search engines. It is a true hybrid, offering transaction support, data-versioned snapshots, and sophisticated function-based indices. Wildcards, phonetic, and fuzzy logic searches are supported, as well. Commercial support is available, and the project is released under a the GPLv2 license. [Less]

Django External Schema Evolution Branch Django, via the command ./manage syncdb, can automatically build a database schema based on your applications models.py file. However, after you've done this ... [More] once, it leaves you with two unpleasant follow-up options if you ever make any changes to your model structure: 1. destroy your existing schema (along with all your data) and let ./manage syncdb rebuild it for you 2. manage your own schema upgrades by writing your own SQL Project deseb aims to fill this void by providing s third option: 3. generate schema upgrades via the command: ./manage evolvedb [Less]

The PostgresKit set of frameworks is "yet another" way to interface your Objective-C applications (Cocoa- or Foundation- based) to the wildly popular and extraordinary PostgreSQL database. This ... [More] project compiles to two frameworks and some example applications: PostgresServerKit provides an emdedded PostgreSQL database which runs locally. You can start and stop the database programatically, edit access control and perform data backups of the database. PostgresClientKit provides an embedded client library, which is simply an interface to the normal postgres "libpq" library. Most of the in-build postgres types and mechanisms are supported, especially the "bytea" (binary large objects) type. in development - no bindings yet, some data types TBD PostgresDataKit provides sets of classes for persistent object storage and retrieval (similar to ActiveRecord or CoreData I guess). in development PostgresPrefPane is an example Preference Pane with embedded PostgreSQL server. It includes facilities for installing the server, access control and data backup. EmbeddedServer is an example console-like Cocoa application which embeds a server within an application. It works a but like psql, but in a GUI window, and has data backup integrated, for testing purposes. These binaries compile to Intel 64-bit for Snow Lepoard, so you will need 10.6 and XCode 3.2. This project is currently in alpha development state, which means that features are still being added For more information, please read the Introduction. For a list of recent changes, see Changelog. [Less]

A Postgres database driver for the original AOLserver/NaviServer nsdb driver interface. See also: nsdbipg

This is a new intiative to develop a unique Dashboarding application. The development will be in PHP. The studio will allow to connect to any database and Excel files. It will allow you to create ... [More] reports and Dashboards. Dashboard Studio will be able to import dashboard definitions directly from InfoCaptor Designer. It will also have in-built role and security mechanism. This will be a totally new application from InfoCaptor which is a java based Dashboard application. [Less]

PgPatcherMaintaining a live PostgreSQL database is easier when you create patches - this way you can keep track of everything you've done to the database and replay each patch on another installation ... [More] (dev, test, live, etc). And also having transactional DDL (thanks Postgres) means this is a whole lot easier. By placing patch files (patch_0_1.sql, patch_1_0.sql) into a directory and pointing pgpatcher at them, you can patch - and reverse patch - to your hearts content. [Less]

A Postgres database driver for the AOLserver nsdb driver interface. Includes additional Tcl commands not specified in the nsdb interface which emulate bind variables.

DescriptionThis project is targeted on transferring data changes in tables from one database to another. All changes are monitored using trigger mechanism in database. Runs both on Linux and Windows. All suggestions welcome.

Connect to various database running on different OS using a single driver.