Recent

Author Topic: PropStorage to a database  (Read 1755 times)

Sieben

  • Sr. Member
  • ****
  • Posts: 299
PropStorage to a database
« on: December 26, 2021, 06:31:28 pm »
When developing database applications I like to store SessionProperties and other values to the database as well. So I sort of rewrote additional PropStorage components for writing to a blob field instead of a file. Make sure that your database connection is up and alive when the components take action, and while they care for opening, editing and posting you will also have to make sure that updates are applied and committed. An inactive but connected TSQLQuery with sqoAutoApplyUpdates and sqoAutoCommit for instance should do fine.

If in doubt consult the source code. Or ask.
« Last Edit: January 12, 2022, 08:10:10 pm by Sieben »
Lazarus 2.2.0, FPC 3.2.2, .deb install on Ubuntu Xenial 32 / Gtk2 / Unity7

 

TinyPortal © 2005-2018