CSE organized a workshop on postgreSQL to keep students updated

The Department of Computer Science and Engineering organized a workshop on postgreSQL on August 1st 2015, conducted by Mr. Dapinder Singh Virk, Assistant Professor at CSE.

PostgreSQL, often known as simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and on standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. It can handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

PostgreSQL implements the majority of the SQL:2011 standard, is ACID-compliant and transactional (including most DDL statements) avoiding locking issues using multiversion concurrency control (MVCC), provides immunity to dirty reads and full serializability. It is capable of handling complex SQL queries using many indexing methods that are not available in other databases; has updateable views and materialized views, triggers, foreign keys; supports functions and stored procedures, and other expandability.
Proprietary extensions in databases such as Oracle can be emulated by built-in and third-party open source compatibility extensions. Recent versions also provide replication of the database itself for availability and scalability. With the technology advancing every minute, it is important that our students are aware of these advancements and this is the prime reason for us to carry out extensive workshops, interactions, discussions and more.