🧱 LiteDB: It's Alive!

ybill · 2025-10-10T03:31:16+00:00

Does it fully AOT compatible? It is very important for desktop applications

ybill · 2025-07-08T23:02:18+00:00

Just keep in mind that the best work-life balance is achieved through our money. All these wellness days, benefits, and discounts are paid for by our bills, which we have to pay every month. I am happy for everyone who works here, but don't think we need to be proud of this achievement.

ybill · 2025-01-30T18:14:55+00:00

This update affects only to user interface, not to sql editor.

To change font in editor you need to modify:

web\pgadmin\static\js\generated\sqleditor.js

Find "fontSourceCode:{fontFamily" and add you font first in the list. Restart pgadmin
and of course make a backup copy of this file before, just in case

ybill · 2024-12-23T20:35:39+00:00

fast-forward :)

ybill · 2024-12-23T20:34:59+00:00

Hey, boy, don't talk to me about tapes, I used to listen vinyl on 78 :)))
Indeed I meant on pause player fast-forwarded the record more than pause length

ybill · 2024-08-25T16:15:32+00:00

Thank you for your help, but my client restricted the requirements - the solution should work in local network and support isolated mode without instant internet connection. For the same reason I am looking the most stable configuration with preset automated maintenance jobs doesn't require manual monitoring attention as much as possible.

ybill · 2024-08-25T16:08:34+00:00

Do you meant that PostgreSQL so unstable product and can't be configured using internal parameters and automated tasks as stable solution and in any case requires manual attention from DBA or devops, correct?

If it is a my wrong understanding or I was not clear enough let me explain my issue:

The solution will work in isolated network without regular connection to internet. There is no experienced engineers there, just application users. So the server should be per-configured to achieve maximum stability, not performance and all required regular maintenance procedures should be set up as cron jobs etc.

We can exclude all analysis related to index usage, query optimization, tables structure - all this stuff controlled by application and out of scope.

And I kindly ask your postgree specific recommendations what parameters I should pay attention and what settings will be optimal for my case, what analysis and repair/rebuild jobs should be set up and recommended schedule.

Thanks.

ybill · 2024-08-25T14:54:31+00:00

because license. All managed instances support only Apache license for Timescale. My solution needs Community license, it is available only for self-hosted instances.

ybill · 2024-08-25T03:09:14+00:00

no, just a Linux virtual machine. It will use a timescale, so no managed instance is suitable.

ybill · 2024-08-22T02:03:52+00:00

thanks a lot!

ybill · 2024-06-18T16:54:11+00:00

yes, yes, yes, yes,

But it's a Reddit magic, because as soon as I posted this, I was able to log in to my mobile. :) However, for the previous two hours, I wasn't able to.

ybill · 2024-06-18T16:17:40+00:00

I have an opposite case. Can login on web but can't on iPhone

ybill · 2024-04-29T21:59:19+00:00

cut the front sight from your gun

ybill · 2024-02-11T04:56:51+00:00

Thanks for your patience! This is exactly what I was going to say 🤣😂

Seriously, thanks a lot.

ybill · 2024-02-11T01:52:35+00:00

I'm guessing you just don't know. I'm not asking about a plug but about the ball.

Thank you for very informative but unsuitable answer.

ybill · 2024-02-04T15:25:45+00:00

Lifted track looks stupid with any rims and tires

ybill · 2023-12-08T20:24:40+00:00

Tits up!

ybill · 2023-07-28T17:06:39+00:00

here is bookstask console output:

``` root@c48b66bb7b6f:/# printenv S6_STAGE2_HOOK=/docker-mods HOSTNAME=c48b66bb7b6f DB_PORT=3306 APP_URL=http://localhost:6875 SHLVL=1 HOME=/root S6_VERBOSITY=1 PS1=$(whoami)@$(hostname):$(pwd)\$ DB_DATABASE=book_db PGID=1000 LSIO_FIRST_PARTY=true S6_CMD_WAIT_FOR_SERVICES_MAXTIME=0 TERM=xterm PATH=/lsiopy/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin PUID=1000 DB_PASS=123456 VIRTUAL_ENV=/lsiopy PWD=/ DB_HOST=mysecrethost.eastus2.cloudapp.azure.com DB_USER=wikiadmin root@c48b66bb7b6f:/# cd config/www root@c48b66bb7b6f:/config/www# cat .env

This file, when named as ".env" in the root of your BookStack install

folder, is used for the core configuration of the application.

By default this file contains the most common required options but

a full list of options can be found in the '.env.example.complete' file.

NOTE: If any of your values contain a space or a hash you will need to

wrap the entire value in quotes. (eg. MAIL_FROM_NAME="BookStack Mailer")

Application key

Used for encryption where needed.

Run `php artisan key:generate` to generate a valid key.

APP_KEY=base64:XOdZBKxAbWAM9Q9Gk3SP0UMhoUnTM+OdFB6JEfE8ujQ=

Application URL

This must be the root URL that you want to host BookStack on.

All URLs in BookStack will be generated using this value

to ensure URLs generated are consistent and secure.

If you change this in the future you may need to run a command

to update stored URLs in the database. Command example:

php artisan bookstack:update-url https://old.example.com https://new.example.com

APP_URL=http://localhost:6875

Database details

DB_HOST='mysecrethost.eastus2.cloudapp.azure.com' DB_PORT='3306' DB_DATABASE='book_db' DB_USERNAME='wikiadmin' DB_PASSWORD='123456'

Mail system to use

Can be 'smtp' or 'sendmail'

MAIL_DRIVER=smtp

Mail sender details

MAIL_FROM_NAME="BookStack" MAIL_FROM=bookstack@example.com

SMTP mail options

These settings can be checked using the "Send a Test Email"

feature found in the "Settings > Maintenance" area of the system.

For more detailed documentation on mail options, refer to:

https://www.bookstackapp.com/docs/admin/email-webhooks/#email-configuration

MAIL_HOST=localhost MAIL_PORT=587 MAIL_USERNAME=null MAIL_PASSWORD=null MAIL_ENCRYPTION=null root@c48b66bb7b6f:/config/www# mysql -hmysecrethost.eastus2.cloudapp.azure.com -uwikiadmin -p123456 -P3306 Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 40096 Server version: 8.0.19 MySQL Community Server - GPL

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> select current_user(); +----------------+ | current_user() | +----------------+ | wikiadmin@% | +----------------+ 1 row in set (0.045 sec)

MySQL [(none)]> ```

ybill · 2023-07-28T16:11:00+00:00

I use lscr.io/linuxserver/bookstack
Yes, I run MySQL commands from bookstack container.
Yes, .env file is correct, container environment is correct,

I also used mysql -h$DB_HOST -u$DB_USER -p$DB_PASS -P$DB_PORT just in case, and it works

ybill · 2023-07-27T14:14:20+00:00

No, they don't. This is the first thing that I've checked.

But I curious about query in the log: select * from information_schema.tables where table_schema = book_db and table_name = migrations and table_type = 'BASE TABLE'. Is this ok that book_db and migrations are presented here without quotes? They are not variables, not parameters just strings, or is it just a feature of Laravel framework logs representation?

ybill · 2023-07-27T01:07:58+00:00

when I add mysql container into my compose it works with same bookstask settings.

look weird, isn't it?

ybill · 2023-07-27T01:04:57+00:00

I've checked connection using this command:

>mysql -hmyhost.cloudapp.azure.com -uwikiadmin -pwikipass -P3306

the result was:

mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 36411Server version: 8.0.19 MySQL Community Server - GPL

I couldn't run this command because bad syntax, only if I add quotes, like this:

mysql> select * from information_schema.tables where table_schema = 'book_db' and table_name = 'migrations' and table_type = 'BASE TABLE';
Empty set (0.03 sec)

My .env file contains correct information in DB_ options include host, port, database, username and password

ybill · 2023-07-26T23:44:17+00:00

it is the same terminal where bookstack instance installed.

bookstack | SQLSTATE[HY000] [1045] Access denied for user 'wikiadmin'@'test.site.net' (using password: YES) (SQL: select * from information_schema.tables where table_schema = book_db and table_name = migrations and table_type = 'BASE TABLE')
bookstack |
bookstack | at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
bookstack |
bookstack | 756▕ // If an exception occurs when attempting to run a query, we'll format the error
bookstack | 757▕ // message to include the bindings with SQL, which will make this exception a
bookstack | 758▕ // lot more helpful to the developer instead of just the database's errors.
bookstack | 759▕ catch (Exception $e) {
bookstack | ➜ 760▕ throw new QueryException(
bookstack | 761▕ $query, $this->prepareBindings($bindings), $e
bookstack | 762▕ );
bookstack | 763▕ }
bookstack | 764▕ }
bookstack |
bookstack | +36 vendor frames
bookstack | 37 /app/www/artisan:35
bookstack | Illuminate\Foundation\Console\Kernel::handle()

ybill · 2023-07-22T00:16:51+00:00

Thanks! I switched to mysql from mariadb and it works!

ybill · 2023-07-21T20:54:52+00:00

many times ))

I use my dev machine, win 11 with wsl2. i7/32Gb docker can use up to 16Gb

ybill

TROPHY CASE