Tinkerbell SQL

This library embeds SQL right into the Haxe language. Think LINQ (not the syntax sugar, but the framework).

Motivation

Most developers tend to dislike SQL, at least for a significant part of their career. A symptom of that are ever-repeating attempts to hide the database layer behind ORMs, with very limited success.

Relational databases are however a very powerful concept, that was pioneered over 40 years ago.

Define a database like so:

import tink.sql.*;

typedef User = {
  id:Id<User>,
  name:String,
  email:String,
  password:String,
}

typedef Post = {
  id:Id<Post>,
  author:Id<User>,
  title:String,
  url:String,
}

typedef Tag = {
  id:Id<Tag>,
  name:String,
  desc:Null<String>,
}

typedef PostTags = {
  post:Id<Post>,
  tag:Id<Tag>,
}

class BlogDb extends tink.sql.Database {
  @:table var user:User;
  @:table var post:Post;
  @:table var tag:Tag;
  @:table var postTags:PostTags;
}

... to be continued ...