2020-02-20

phpmyadmin: add a table (or a view) to "favorites" (bookmarks)

In tables (or views) click on the star next to his name.

2019-12-30

rclone and symlinks: a good news

with -l you can copy (i.g. on Mega) your symlinks (as a file with .rclonelink as extension).
When you will sync from remote, that symlink will be created in your local system as symlink.

2019-12-26

groups in nextcloud

Nextcloud is a very interesting, open source online platform. With /e/ you have a cloud of 5 free Gb with calendar, contacts and tasks shareable between PC and smartphone.
1) First of all you should export your data (calendar, tasks, contacts) from Google; a problem arises with contacts because Google export your contacts in a vcf file without groups.
2) So you have to import your contacts from vcf google file in nextcloud and re-create groups, which this time could be saved in a vcf file with groups (as categories).
3) To see your contacts and groups you have to use DAVx5 and in account settings - > cardDAV -> group organization you have to choose as in the following image:

not [ ] groups are separated vcards
but [x] groups are per-contact categories
4) This way you will be able to see your contacts and groups in your phone app (or in whatever other app).

2019-12-14

edit views in phpmyadmin

You can go in view -> structure and find (below) "edit view". Then you can change something, i.g. adding a nuew field, not yet present when that view was created.

2019-12-13

test sddm screen, without logging out

this is the code (in terminal):
sddm-greeter --test-mode --theme /usr/share/sddm/themes/breeze

2019-12-12

phpmyadmin relations in views

You can create a relation between two tables, or better between a table and a view (more flexible), so that you can use data of related table/view in the table you are using.

But if you create a view from that table (a table whose structure is "related" to another one) you have to repeat (in structure view) the relation settings.

2019-12-11

field name containing "-" not accepted in a mysql query

You have to put the field name into quotes "`" some-text (not working) -> `some-text` (working)

Translate

Blog Archive