Projects

sqlscripter

SQLScripter speeds up schema scripting and content dumping process form MS SQL Server databases. Once a project (one XML file), a simple commandline tool can provide you with easily deployable scripts.

adventureworks-db-4-all

The goal of this project is to construct OpenAdventureWorks and OpenAdventureWorksDW databases for MySQL, PostgreSQL, and Apache Derby that are comparable to the AdventureWorks OLTP and AdventureWorks DW databases provided at http://www.codeplex.com/MSFTDBProdSamples. The assets produced in this ... [More] project shall include: DDL scripts to produce the necessary schema objects (tables, views, sequences, etc) DML scripts to populate the databases user documentation [Less]

dmlspec

Repository for DML Spec and Schema documents

sqandal

SQandaL is a SQL Query Building Java API that allows intuitive creation of SQL Queries without need for ugly SQL text Strings among the Java Code. Initial GoalsCreating a good core-API for general-purpose SQL Query Building; Generating clean and readable SQL Queries; Creating objects that can be ... [More] manipulated in different ways, depending on how many control of the Query the developer wants; Creating a good structure for easy Query Building even for developers who doesn't know so much about SQL developing; Developing code that is easy to extend itself for new functions or as part of other tools. Current StageI'm at the very beginning of the developing. Until I have at least Where, Join and Group By support on the Select query builder, there will not be any release. Related ProjectsThe following projects have the main initial idea as SQandaL. Until the API is ready for use, check them out: squiggle-sql sql-dsl sqlck Why a new Project?I have great ideas to extend it to new ways when the main core-API is finished. Until then, the main goal is to work on the Query Building core. Code SampleThe following Java code will create a (very) simple Select Query that shows Persons Name and Age, based on the DB Table definition: // SQL Select Query builder Select selectQuery = new Select(); Table tbPerson = selectQuery.addTable("Person", "p"); // Note the Columns Names and Aliases selectQuery.addOutputColumn("PersonName", "Name", tbPerson); selectQuery.addOutputColumn("PersonAge", "Age", tbPerson); System.out.println(selectQuery);Should give us the following output: SELECT p.PersonName AS Name, p.PersonAge AS Age FROM Person AS pIn a real scenario, the String generated by the selectQuery.toString() method should be passed to a JDBC Statement and executed. Note: Like I've said, there are other ways to do the same thing depending on how many query control you need. [Less]