news
Databases: PostgreSQL's external_file v1.2, 30 years of MySQL
-
PostgreSQL ☛ external_file v1.2 has been released
PostgreSQL external file access extension
The external_file extension allows access to "external files" from PostgreSQL server file systems.
This extension adds the same functionalities given by the Oracle's BFILE data type that stores unstructured binary data in flat files outside the database. A BFILE column stores a file locator that points to an external file containing the data: (DIRECTORY, FILENAME). Here the data type is called EFILE.
-
The Register UK ☛ 30 years of MySQL, the database that changed the world
The arrival of MySQL coincided with the dotcom boom, which heralded the arrival of technologies and businesses that, for better or worse, became known as Web 2.0. Loosely speaking, a more programmable and interactive version of its 1990s predecessor, Web 2.0 saw a flurry of organizations building systems to try to capture the millions of people flooding online in the early-to-mid Noughties. Since the dotcom bubble burst, the paucity of investment pushed them towards open source software. MySQL became the M in LAMP, the de facto standard used to build web-facing systems, which also included the Linux operating system, Apache web server, and programming languages Perl, PHP, or Python.