Mercurial > libervia-pubsub
view README @ 367:a772f7dac930
backend, storage(pgsql): creation/update date + serial ids:
/!\ this patch updates pgqsl schema /!\
Had to set 2 features in the same patch, to avoid updating 2 times the schema.
1) creation/last modification date:
column keeping the date of creation of items is renamed from "date" to "created"
the date of last modification of items is saved in the new "updated" column
2) serial ids:
this experimental feature allows to have ids in series (i.e. 1, 2, 3, etc.) instead of UUID.
This is a convenience feature and there are some drawbacks:
- PostgreSQL sequences are used, so gaps can happen (see PostgreSQL documentation for more details)
- if somebody create an item with a future id in the series, the series will adapt, which can have undesired effect, and may lead to item fail if several items are created at the same time. For instance if next id in series is "8", and somebody hads already created item "8" and "256", the item will be created with biggest value in items +1 (i.e. 257). if 2 people want to create item in this situation, the second will fail with a conflict error.
| author | Goffi <goffi@goffi.org> |
|---|---|
| date | Sat, 04 Nov 2017 21:31:32 +0100 |
| parents | 9fbb31ce495b |
| children | 618a92080812 |
line wrap: on
line source
SàT PubSub component v0.1.1 This program is heavily based on Idavoll (0.9.1), which was written by Ralph Meijer Copyright (c) 2012-2017 Jérôme Poisson Copyright (c) 2014-2016 Adrien Cossa Copyright (c) 2003-2011 Ralph Meijer Sàt PubSub is a PubSub component service for XMPP ** LICENSE ** Sàt PubSub is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. Sàt PubSub is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details. You should have received a copy of the GNU Affero General Public License along with Sàt PubSub. If not, see <http://www.gnu.org/licenses/>. ** ABOUT ** SàT PubSub is a XMPP PubSub service component (XEP-0060) It's based on Ralph Meijer's Idavoll, but provide special features necessary for the « Salut à Toi » project ( http://sat.goffi.org ), but it can also be used for any other XMPP project. The use of a standard external component allow to use this features with most XMPP servers. One of the main addition is fine access tuning for PubSub, which allow the publication of items for only some groups, even if the entire node is open. The protocol is explained on http://www.goffi.org/post/2012/06/24/Fine-access-tuning-for-PubSub for the moment, and a protoxep should be proposed to the XSF in the future... ** INSTALLATION ** Instructions for installation are the same as for Idavoll, so follow what is written in INSTALL and UPGRADING files. ** CREDIT ** The base project (Idavoll) was made by Ralph Meijer and can be found on http://idavoll.ik.nu/ ** CONTACT ** Goffi (Jérôme Poisson): goffi@goffi.org (e-mail) or goffi@jabber.fr (jid) Souliane (Adrien Cossa): souliane@mailoo.org (e-mail) or souliane@libervia.org (jid) XMPP MUC: sat@chat.jabberfr.org