{"repo":"Defacto2/database","free":true,"listed":false,"github":"https://github.com/Defacto2/database","clone":"git clone https://github.com/Defacto2/database.git","description":"The database for Defacto2, a website conserving defunct software, wares, and elite digital subcultures of the PC.","language":null,"stars":11,"topics":["defacto2","database","defacto2-website"],"license":null,"category":"databases-storage","readme_excerpt":"Defacto2, database The Defacto2 database collects thousands of records documenting the history of the PC Scene and is the data powers the famed Defacto2 website. There are daily exports of the SQL database . DOWNLOAD : defacto2.net/sql/files.sql. PostgreSQL 16+ is recommended for compatibility. [!TIP] There is a RESTful API available. defacto2.net/api. First time setup These instructions are for a Linux or macOS environment with a running PostgreSQL application and assumes the postgres username. 1. Download the SQL export file 2. Create a new database in your PostgreSQL server 3. Import the SQL export file into the new database 4. Test the table creation and data To test the table creation and data. [!TIP] The count result will depend on the latest export which will not be 50000 exactly. Update records with the latest data Download and import the latest SQL file. Update a Docker container with the latest data These instructions are for a Linux or macOS environment with a running a Docker PostgreSQL container with the following assumptions: - Container name: pgdb - Database name: defacto2 ps - Database username: postgres To test the data import.","default_branch":null,"files":null,"tree":[],"storefront":"/r/Defacto2","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Defacto2/database/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}