Newbie Area Revolution

aku pengen pake json di mariadb, yang bukan hanya alias dari longtext. untungnya mereka punya plugin untuk itu, namanya "mysql_json". setelah baca2 panduan, ada beberapa metode yang digunakan untuk install plugin. .\mariadb-plugin.exe --basedir="C:\Program Files\MariaDB 11.1" --datadir="C:\Program Files\MariaDB 11.1\data" --plugin_dir="C:\Program Files\MariaDB 11.1\lib\plugin" --my-print-defaults="C:\Program Files\MariaDB 11.1\bin" mysql_json enable gagal terus, error: Cannot read plugin config file mysql_json. File does not exist. .\mariadbd.exe --load-plugin=mysql_json .\mariadbd.exe --load-plugin=type_mysql_json .\mariadbd.exe --load-plugin-add=mysql_json .\mariadbd.exe --load-plugin-add=type_mysql_json gak fungsi, ketika dieksekusi blank saja INSTALL SONAME 'type_mysql_json berhasil, untuk ngecek bisa eksekusi "show plugins"

\copy transaksi FROM '/path/to/import.csv' WITH DELIMITER AS ';' NULL AS 'NULL' CSV HEADER

CREATE ROLE jonathan LOGIN; CREATE USER davide WITH PASSWORD 'jw8s0F4'; CREATE ROLE miriam WITH LOGIN PASSWORD 'jw8s0F4' VALID UNTIL '2005-01-01'; CREATE ROLE admin WITH CREATEDB CREATEROLE; CREATE USER testges WITH CREATEDB PASSWORD 'testges'; https://www.postgresql.org/docs/current/sql-createrole.html https://www.postgresql.org/docs/current/sql-createuser.html

psql --host=127.0.0.1 --username=postgres --password --dbname=mydb --file="/path/to/file/database.sql" lalu kamu akan dimintai password nya.

pg_dump --username=postgres --schema-only --no-comments --no-owner --format=plain --file=./structures.sql mydb

$ sudo -u postgres psql -p 5433 # jika port beda $ sudo -u postgres psql # \password postgres # \q Tested on Debian 11/bullseye (unstable). (referensi) https://stackoverflow.com/a/12721020/3036312

https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-debian-10

https://jira.mariadb.org/browse/MDEV-20687 it is still a bug my friend, because on mysql it is just work.

I just known, that Firebird have DDL (Data Definition Language) for DROP+CREATE store procedure in one go. so instead of "CREATE PROCEDURE test; ALTER PROCEDURE test;" or "DROP PROCEDURE test; CREATE PROCEDURE test;" you can just "RECREATE PROCEDURE test;" and boom! done 😎.

https://grokbase.com/t/couchdb/user/13858rcwhz/sample-couchdb-data https://github.com/cloudant/mango singkatnya, bisa disebut, sql untuk nosql dalam bentuk json. https://github.com/apache/couchdb-fauxton singkatnya, bisa disebut, phpmyadmin untuk couchdb. http://docs.couchdb.org/en/latest/cve/index.html https://www.cvedetails.com/vulnerability-list/vendor_id-45/product_id-19046/Apache-Couchdb.html (untuk sekarang) sudah fixed semua di versi terbaru. termasuk, https://www.exploit-db.com/exploits/44913/ (invalid) https://stackoverflow.com/questions/121599/couchdb-backups-and-cloning-the-database https://wiki.apache.org/couchdb/How_to_make_filesystem_backups?action=show&redirect=FilesystemBackups aneh. kok saya tidak bisa menemukan file binary nya ya?. didalam folder-folder yg disebutkan, hanya ada _users.couch dan _replicator.couch saja. file database yg saya cari tidak ketemu. referensi lainnya, https://www.cvedetails.com/vulnerability-list/vendor_id-74/product_i...

https://www.drupal.org/docs/develop/coding-standards/list-of-sql-reserved-words https://www.ibm.com/support/knowledgecenter/en/SSULQD_7.2.1/com.ibm.nz.dbu.doc/r_dbuser_sql_common_reserved_words.html https://www.google.com/search?q=sql+common+reserved+words

select * from information_schema.tables a where a.table_catalog = 'YOUR_DB_NAME' -- optional and a.table_schema != 'information_schema' and a.table_schema not like 'pg_%' and a.table_type = 'BASE TABLE' -- table and a.table_type = 'VIEW' -- view

Saya sudah cukup lama belajar Firebird , tapi masih saja lupa bagaimana caranya membuat database baru. Agar tidak lupa, saya dokumentasikan di blog ini.

http://www.dragonbe.com/2014/01/pdo-sqlite-error-unable-to-open.html

http://use-the-index-luke.com/no-offset http://mysql.rjweb.org/doc.php/pagination