The greyhound from priestd09

greyhound's Introduction

#Greyhound

Greyhound is a tiny ORM-ish for Free Pascal.

It is fast, clean and simple to use.

program t1;
{$mode objfpc}{$H+}
uses
  SysUtils, ghSQL, ghSQLdbLib;
var
  Co: TghSQLConnector;
begin
  Co := TghSQLConnector.Create(TghSQLite3Lib);
  try
    Co.Database := 'DB.sqlite';
    with Co.Tables['compilers'] do
	begin
      Select('*').Where('lang = :lang');
	  Params['lang'].AsString := 'pascal';
	  Open;
      Append;
      Columns['name'].AsString := 'FPC';
      Columns['description'].AsString := 'FreePascal Compiler';
      Commit;
	end;
  finally
    Co.Free;
  end;
  writeln('Done.');

end.

##Features

It will help you with a thin layer to read/write data in a DBMS, but don't trying to simulate a pure object model;
It use SQL as query language and does not try to create a complex abstraction between objects and tables;
It implements relationship between tables using "Links" property (1-n, n-1, m-n... whatever you want);
It implements constraints for tables (default, check and unique);
It was inspired in ActiveRecord pattern;
It allows developers to have greater control of SQL rather than relying on the framework to generate it automatically;
It has easy transaction support;
It has the ability to add support for other databases libraries like SQLdb (default), ZEOS or whatever you want;
It works with IDENTITY columns (AutoInc) automatic and Sequence values (generators);

##System requirements Greyhound requires Free Pascal 2.6.2 or newer.

##Who uses?

Recommend Projects