Databases@FCSE

Databases@FCSE News

World News

Student DB Projects

Databases and Programming

This page tries to gather all the most important links on developing applications that are using databases or running inside databases that we recommend to  students to check-out. Please contact us if you have any suggestions, but do note that only technologies that are mature and long in the market are listed.

Server-side (In-database) Programming

Direct links to the most important parts of the documentation of various RDBMS systems, during database design and constraints programming. Use these as starting points to investigate further.

Want another database listed? URLs have changed? Contact me and send me the updates in the format used above.

Programming Applications that use a Relational Database

Standard Interconnection APIs

The basic layer that enables connection to the database. They can be used directly within your applications, or as part of a higher-level tools (like ORM).

ODBC - basic layer that exists for many operating systems, supported by many programming languages and used by many applications (even office applications) when the user wants to connect to a database and extract data via SQL

PosgreSQL
ODBC Driver

https://odbc.postgresql.org/

JDBC - Java virtual machine basic layer - it is a Java world (and virtual machine) alternative to ODBC, but it can also work on top of ODBC if some very specific database or scenario is not directly supporter

PosgreSQL
JDBC Driver

https://jdbc.postgresql.org/

Object-relational mapping (ORM)

Object-oriented software uses Classes of objects to organize the code and data. Relational databases organize the data in tables (relations). ORM is a software that act as a translator between object-oriented concepts and relational concepts and can be used to look at a relational database as if it was not relationally organized but organized in an object-oriented way.

There are many ORM software libraries and platforms that enable ORM. Here we will include some of the most popular ones. For an extensive list see the respective wikipedia article.

Hibernate and NHibernate (.Net)

EclipseLink

LINQ to SQL

WebObjects Enterprise Objects