The Database Preservation Toolkit allows conversion between Database formats, including connection to live systems, for purposes of digitally preserving databases. The toolkit allows conversion of live or backed-up databases into preservation formats such as DBML, an XML format created for the
... [More] purpose of database preservation. The toolkit also allows conversion of the preservation formats back into live systems to allow the full functionality of databases. For example, it supports a specialized export into MySQL, optimized for PhpMyAdmin, so the database can be fully experimented using a web interface.
Furthermore, developments are being made in order to add support of SIARD database preservation format, along with the addition of import/export modules of more database management systems. [Less]
Loading data into PostgreSQL
pgloader is a data loading tool for PostgreSQL, using the COPY command.
Its main avantage over just using COPY or \copy and over using a Foreign Data Wrapper is the transaction behaviour, where pgloader will keep a separate file of rejected data and continue trying
... [More] to copy good data in your database.
The default PostgreSQL behaviour is transactional, which means that any erroneous line in the input data (file or remote database) will stop the bulk load for the whole table.
pgloader also implements data reformating, the main example of that being a transformation from MySQL dates 0000-00-00 and 0000-00-00 00:00:00 to PostgreSQL NULL value (because our calendar never had a year zero). [Less]
The PostgreSQL Extension Installer.
PostgreSQL 9.1 brings in a new concept of Extensions, an SQL object that packs together a bunch of other SQL objects. The aim of extensions is to allow for easy dump and restore of SQL objects managed externally, such as... extensions.
In PostgreSQL, the
... [More] CREATE EXTENSION command installs the SQL objects of an extension by running a SQL script. This script and some more files must be available at the right place on the PostgreSQL server's file system for the CREATE EXTENSION command to be successful.
The PostgreSQL Extension Installer software is an Extension Repository Manager. [Less]
Workshop Organizer is light-weight, cross platform inventory controller for home-workshops. This application is specifically design to manage electronic/electrical components at home-workshops, but it can use to manage other areas of workshop including tools, machinery and mechanical components, etc.
This site uses cookies to give you the best possible experience.
By using the site, you consent to our use of cookies.
For more information, please see our
Privacy Policy