databases

I'm having quite a slog trying to find working guis for sql development in FreeBSD. The best I've found are: 1. sqlitebrowser (for SQLite) 2. PhpMyAdmin (for MySQL) What I'd like to have is DBeaver or something similar that can handle multiple databases or MySQL Workbench, or... What other...

https://ronaldduncan.wordpress.com/2009/10/31/text-file-formats-ascii-delimited-text-not-csv-or-tab-delimited-text/ WHY AREN'T THESE USED MORE ?

Greetings. I have few jails running nginx on my FreeBSD 13.1 host. I'd like to create another jail for their SQL database needs. I'd like to create ZFS dataset for this purpose (for MySQL jail) but should I create it on host? If the dataset is created within the host, could the Jail access it...

Recently, a very exciting database has been open-sourced by Yandex. Apparently they have battle-tested it internally for years before making it open-source recently as part of the launch of their managed database-as-a-service offering (Apache License). Some of the cool features include...

Greetings. Having mariadb105-server-10.5.13 running on FreeBSD 13 with ZFS. (A physical, dedicated server: CPU: AMD Ryzen 5 3600 6-Core 3593.32-MHz CPU and 64 GB RAM) My WordPress website sometimes getting random-visitors attacks/DDoS (hundreds of http GET requests instantly towards randomly...

Is there a database system which is created, developed and/or designed more "in the spirit" of FreeBSD? Obviously, Berkley DB was originally created and developed as part of BSD, so is probably a strong contender. If the question was about Unix rather than FreeBSD specifically, would the...

Hi. Does anybody know of a good solution to set up a guaranteed allocation of physical drive space for a ZFS pool? Ideally I would like my database pool to allocate-from and use only the first third (for example) of the physical sectors of all my drives so that all data lives in the "fast...

I am learning how to install and use PostgreSQL server and I have run across a few different tutorials. One of them had me running postgresql commands from /usr/local/etc/rc.d. However, I initially didn't see the directory and the command wasn't working so I ended up finding pg_ctl and doing the...

I've just installed databases/mysql57-server on a new server, but can't see the example config files in /usr/local/share/mysql or anywhere to copy to run the server. I've used: $ sudo find / -name "mysql*" 2>/dev/null and /usr/local/share/mysql/ has: my-default.cnf mysql-log-rotate...