BTW I run Arch Debian NixOS
  1. 📄
  2. 📄
  3. 📄
  4. 📄
  5. 📄
  6. 📄
  7. 📄
  8. 📄
  9. 📄
  10. 📄
  11. 📄
  12. 📄
  13. 📄
  14. 📄
  15. 📄
  16. 📄
  17. 📄
  18. 📄
  19. 📄
  20. 📄
  21. 📄
  22. 📄
  23. 📄
  24. 📄
  25. 📄
  26. 📄
  27. 📄

Comments

INSERT INTO comment(nickname, visitor_url, contact, show_contact, comment, public) VALUES (
, , , , ,
);
(Will await approval before becoming public) 

SELECT id, nickname, comment, page_url, visitor_url, (CASE WHEN show_contact THEN contact ELSE NULL END) as contact_info, created_at
FROM comment WHERE approved AND public AND page_url = '/' ORDER BY created_at DESC;

      
+------+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+-------------------------+------------------------------+-------------------------------+
|   id | nickname       | comment                                                                                                                                                                                                                                                                                       | page_url   | visitor_url             | contact_info                 | created_at                    |
|------+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+-------------------------+------------------------------+-------------------------------|
|    2 |                | Test private means of contact                                                                                                                                                                                                                                                                 | /          |                         |                              | 2024-10-20 12:57:31.500978+02 |
|    1 | user@node5.net | Hello world!                                                                                                                                                                                                                                                                                  | /          | https://blog.node5.net/ | Leave a comment on this blog | 2024-10-20 12:57:31.498685+02 |
|   11 | user@node5.net | Well @kekuolis technically GNU/Linux/systemd-boot/systemd-creds/systemd-cryptenroll/systemd-firstboot/systemd-homed/systemd-logind/systemd-networkd/systemd-nspawn/systemd-resolved/systemd-stub/systemd-sysusers/systemd-timesyncd/systemd-Journal/systemd-Timers is a more apt description. | /          | https://blog.node5.net/ | Comment on this site         | 2024-03-02 22:10:32.52923+01  |
|   10 | kekuolis       | uhmm achstually, it's "on my GNU/Linux* distro machines"                                                                                                                                                                                                                                      | /          |                         |                              | 2024-03-02 17:48:51.563175+01 |
|      |                |                                                                                                                                                                                                                                                                                               |            |                         |                              |                               |
|      |                | Linux is not an operating system unto itself, but rather another free component of a fully functioning GNU system made useful by the GNU corelibs, shell utilities and vital system components comprising a full OS as defined by POSIX.                                                      |            |                         |                              |                               |
|    6 | kekman         | epic                                                                                                                                                                                                                                                                                          | /          |                         |                              | 2024-02-27 17:07:04.170849+01 |
|    5 | user@node5.net | Prod test                                                                                                                                                                                                                                                                                     | /          | https://blog.node5.net/ | Don't                        | 2024-02-27 16:54:30.502173+01 |
+------+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+-------------------------+------------------------------+-------------------------------+