DBeater

S73jk0h54ywbju6xvgmo
Database structure management and versioning without headache
Qcjzyuxp9wxgvggnyt9v
Aurimas Niekis
Technology
Kaunas
Lithuania
1 Team Member

2014-01-10 Update: screencast for basic usage of DBeater




DBeater

Database structure management and versioning without headache

What is DBeater?

DBeater is a multi-database syntax and abstraction layer for managing MySQL, PostgreSQL, SQLite, Oracle, SQLServer, DB2 and FireBird databases for web applications.

DBeater allows you to make iterative changes to your database. Using migration files, you can manipulate and version your database scheme with ease.

Migration files are based on XML. Anyone with XML or HTML knowledge can work with them. Every kind of operation can be accomplished with generic, DB-independant actions, and dialect-specific column types are automatically mapped to generic ones.

Migration between databases is made as easy as copying migration files to another database folder and running DBeater.

In depth

DBeater is written in Ruby and will be distributed as a Ruby Gem, so it will work on every platform. Via its modular architecture, it can support every database adapter that Ruby can support. Support for custom actions may also be included.

The directory structure


In the root project folder, there's a config file and DBeater folder where all migrations files are stored.

The syntax for creating a table called 'products'

The syntax for adding a new field to a table

Currently supported field types

  • Primary key
  • String
  • Text
  • Integer
  • Float
  • Decimal
  • Datetime
  • Timestamp
  • Time
  • Date
  • Binary
  • Boolean

Current supported actions

  • Create Database
  • Create Table
  • Drop Table
  • Change Table
  • Rename Table
  • Add Column
  • Rename Column
  • Change Column
  • Remove Column
  • Add Index
  • Remove Index

Currently supported Events

  • Change (Up & Down in one)
  • Up (For loading a new schema)
  • Down (For downgrading to an old schema)
  • Raw SQL

The best part

DBeater will be entirely open source (under the MIT license). Nothing will be hidden; it will be completely free and open for everyone.

What is already done?

The core functionality of DBeater is already finished. What's left is writing all the adapters and actions, fixing the bugs, improving performance, writing documentation, and making a website.

Where's my money going?

The greatest part of your money will be used to pay database developers to help write adapters for various types of databases. Some of the rest will be to pay the documentation writer. Anything remaining will help me finish all the work.

When will DBeater be released?

Everything should be done by May. At that point, all of the source code will be released to Github and an installable package will be available on RubyGems.

Other ways you can help

After the public release, you will be able to help us by:
  • Making extensions for custom database adapters
  • Making extensions for custom database actions

£0GBP
raised in 1 month
0% funded
0 time left
£50,000 GBP goal
Flexible Funding This campaign has ended and will receive all funds raised.
Campaign Closed
This campaign ended on February 8, 2014
Select a Perk
  • £5GBP
    A little help to us

    Name in the list of sponsors in website

    0 claimed
    Estimated delivery: February 2014
  • £15GBP
    Certificate + Sticker

    Same as previous reward plus a certificate of contribution and a first-edition backers-only sticker so you can show your support

    0 claimed
    Estimated delivery: February 2014
  • £50GBP
    Certificate, Sticker, T-Shirt

    Same as previous rewards plus a t-shirt

    0 claimed
    Estimated delivery: February 2014
  • £200GBP
    Silver Sponsor status

    Your name in the list of Silver Sponsors in released gem and website

    0 claimed
    Estimated delivery: February 2014
  • £500GBP
    Silver sponsor + umbrella

    Same as previous rewards plus a umbrella

    0 claimed
    Estimated delivery: February 2014
  • £1,000GBP
    Gold sponsor + Banner

    Your name in the list of Gold Sponsors within every source file in released gem and your banner/logo in website for one month. Please note that your banner must be safe for kids, sans fraud and not for competing solutions. Additionally, you'll get a certificate.

    0 claimed
  • £10,000GBP
    Gold Sponsor + Banner on top

    Your banner on the top of the website for 2 months as well as special mention in the release announcement. Additionally, your (company's) name in the list of Gold sponsors within every source file in the released gem. Please note that your banner must be safe for kids, sans fraud and not for competing solutions. Of course, a certificate is included.

    0 claimed
Do you think this campaign contains prohibited content? Let us know.