Re: Listen/Notify?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Manlio Perillo wrote:
> SQLite does not support this.
> However you can just define a function for sending a packet via UDP to 
> registered listeners.

If you have other programs accessing the database over the network, then
that approach would work, but UDP is not reliable and SQLite should not
be used over the network.

Since SQLite uses a single, you can use the operating system facilities
to notify you about the database changing.  For example dnotify/inotify
under Linux.

Depending on what you are looking for, the schema_version and
user_version pragmas may be useful.

  http://sqlite.org/pragma.html

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGBvFkmOOfHg372QQRAklOAJ4lhwJf8hyHepbPtDu2g+pxOBBsMACg0HTV
qzoign3sU9Y2+xswp+CQRyY=
=kiqn
-----END PGP SIGNATURE-----