https://wiki.alf.digital/ 2026-04-24T01:54:01+00:00 https://wiki.alf.digital/ https://wiki.alf.digital/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2023-11-01T07:13:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.alf.digital/doku.php?id=database:liquibase&rev=1698822790&do=diff Liquibase Tool to track B changes TO clean up the checksum after the change do update databasechangelog set md5sum = null where filename = '2014_10_27.xml'; how it works Liquibase stores all metadata in 2 tables: CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK ... CREATE TABLE PUBLIC.DATABASECHANGELOG ... text/html 2023-11-02T11:04:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.alf.digital/doku.php?id=database:mysql&rev=1698923041&do=diff Mysql basic commands Fallpits * Quotes “ don't use it, it is disabled in some databases' wrap Strings` wrap table names or columns * Details The Details about MySQL are [ here]. Sample Database The tool, which generated the picture is called text/html 2023-11-01T07:13:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.alf.digital/doku.php?id=database:nosql&rev=1698822790&do=diff NOSQL NOT ONLY SQL Adds scalability, distribution to the databases. Makes DB Document-oriented. Allowing storage of data as “documents” with different structure in the same DB. E.g. following docs may be stored in the same DB: Details: <http://en.wikipedia.org/wiki/Document-oriented_database> { FirstName: "Jonathan", Address: "15 Wanamassa Point Road", Children: [ {Name: "Michael", Age: 10}, {Name: "Jennifer", Age: 8}, {Name: "Samantha", Age: 5}, … text/html 2023-11-01T07:13:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.alf.digital/doku.php?id=database:oracle&rev=1698822790&do=diff Oracle Installation The Installation for Windows is described here in detail. Syntax The syntax is listed here Commands Requirenments: * The environment variable should point to a tnsnames.ora: TNS_ADMIN = \\folder\of\tnsnamesora\location Ping the DB text/html 2023-11-01T07:13:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.alf.digital/doku.php?id=database:postgres&rev=1698822790&do=diff Postgres Docker The container in the hub: <https://hub.docker.com/_/postgres/> To query the postgres container connect to it using psql docker exec -it postgres psql -h postgres -U postgres Enter the password. To list all databases enter do postgres-# \l