Past Meetup

Open-Source Projects from Israel, Based on PostgreSQL

This Meetup is past

57 people went

Location image of event venue

Details

Agenda (all the lectures - in Hebrew):

• 17:45-18:00: Meet & Greet

• 18:00-18:10: Introduction

• 18:10-18:55: Npgsql - open source .NET support for PostgreSQL, by Shay Rojansky

• 18:55-19:05: YOUR chance to share important things with the audience, like "looking for a PG expert", or announcement of a RELATED event; each speaker is limited to 2 minutes.

• 19:05-19:20: Break ("DELETE * FROM google.refreshments").

• 19:20-20:10: DaTableSQL - Lecture and Live Coding by Eli Marmor

• 20:10-20:15: RAFFLE of 2 JetBrains licenses (and maybe more prizes, if we get them on time)

Npgsql:

After some introductory comments, the .NET open-source driver for PostgreSQL, Npgsql, will be introduced. We will focus on features that are mostly unique to Npgsql, or are made possible by .NET specifically. This part will include comparisons with drivers in other languages/environments. Next, Microsoft's new O/RM - Entity Framework Core - will be presented along with its PostgreSQL support, with an emphasis on exposing PostgreSQL-specific features. Finally and as time allows, some of the challenges of developing a PostgreSQL driver will be discussed (e.g. the frontend/backend protocol).

http://www.npgsql.org (http://www.npgsql.org/)

DaTableSQL:

An ultra thin transparent layer over PostgreSQL that doubles its functionality; instead of 4 main actions (CRUD) on 1 type of element (DATA), it enables more actions, and on many other element types of the app (schemas, users, views (of the app), code, etc.).

It makes PostgreSQL’s tables 3D tables, by adding the time dimension (“temporality”), in order to support features like “travel in time” and check “who changed what and when”, out of the box, with no need for anything in the app level.

When it’s usable (hopefully in February), it will allow the development of much easier yet powerful full-stack frameworks.

https://github.com/marmor/datable.sql