Recent

Author Topic: SQLite on server  (Read 3618 times)

MarkMLl

  • Hero Member
  • *****
  • Posts: 8515
Re: SQLite on server
« Reply #15 on: March 24, 2022, 02:11:01 pm »
Is it possible to encrypt database in FireBird or Postgre?

It's called PostgreSQL, often abbreviated to Postgres, and a trivial Google search directs ones attention to https://www.postgresql.org/docs/14/encryption-options.html

MarkMLl
MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Logitech, TopSpeed & FTL Modula-2 on bare metal (Z80, '286 protected mode).
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories: https://github.com/MarkMLl?tab=repositories

amir.eng

  • Full Member
  • ***
  • Posts: 103
Re: SQLite on server
« Reply #16 on: March 26, 2022, 08:57:24 am »
Thank you all for supporting,
PostgreSQL will be my choice.
Lazarus 3.0 , FPC 3.2.2 , Windows 10 64, Excel 2016 64

MarkMLl

  • Hero Member
  • *****
  • Posts: 8515
Re: SQLite on server
« Reply #17 on: March 26, 2022, 10:25:06 am »
Thank you all for supporting,
PostgreSQL will be my choice.

I believe it's a good choice. The one thing that I'd add is that in my experience Firebird offers a moderate amount of compatibility, in particular both have notification mechanisms which allow the database server to tell the client(s) that something's changed: this is an extremely useful facility since even if running single-user it allows you to separate programs which enter and manipulate data and programs which rely on it in the background.

MarkMLl
MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Logitech, TopSpeed & FTL Modula-2 on bare metal (Z80, '286 protected mode).
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories: https://github.com/MarkMLl?tab=repositories

 

TinyPortal © 2005-2018