Comments (12)
I think this would require a new column on the caches table. , I won't
implement this until such column exists, for performance reasons.
Original comment by rygielski
on 26 Aug 2011 at 9:48
from okapi.
log.php need modified to add this entry i caches table but what we do when user
(owner cache or owner log) delete last log entry by removelog.php
Original comment by sp2ong
on 26 Aug 2011 at 10:00
from okapi.
"logged_since" is a bad name for it, maybe "logs_changed_since" would be better.
I think developer wants to know when logs had changed in general, he doesn't
care when the last log was submitted. Then, when user deleted a log entry,
"logs_changed_since" would bump up to the current time.
Original comment by rygielski
on 26 Aug 2011 at 10:37
from okapi.
Original comment by rygielski
on 26 Aug 2011 at 10:38
- Changed title: Add a "logs_changed_since" argument for services/caches/search/all method.
from okapi.
Also, this functionality could be incorporated into an already existing column
- the last_modified column. I think a "changed log" event may count as a "cache
modification". Some developers would want this cache refreshed upon such events.
Original comment by rygielski
on 26 Aug 2011 at 10:43
from okapi.
When we talking about possible applications using OKAPI to sync OC database
with local offline copy, all changes ( including new/modified logs ) should be
taken into account.
Original comment by miklobit
on 26 Aug 2011 at 11:39
from okapi.
I wouldn't encourage developers to download our entire database. OKAPI
is meant primarilly as a tool for online access. If developers want to
have dumps of data for offline use, I think we should think of a
special method for that - it would return a static JSON/XML/SQL dump,
generated once a day.
Original comment by rygielski
on 27 Aug 2011 at 9:27
from okapi.
Original comment by rygielski
on 29 Aug 2011 at 10:36
- Changed state: Blocked
from okapi.
Original comment by rygielski
on 1 Sep 2011 at 7:27
- Changed title: services/caches/search/all: last_modified should get modified on log entries
from okapi.
The best solution I can think of:
Add two things to OKAPI db-update chain:
- Add a column "really_last_modified" of MySQL type "timestamp" to table
"caches". Columns of "timestamp" type get automatically updated when anything
in a row changes.
- Update existing "really_last_modified" columns based on caches.last_modified
AND cache_logs.last_modified.
Original comment by rygielski
on 1 Sep 2011 at 7:30
from okapi.
Update: Added a new module 'replicate' to OKAPI. Now external developers may
keep their database in sync with ours. This is somewhat relevant to this issue.
Original comment by rygielski
on 12 Mar 2012 at 1:42
from okapi.
It appears we won't be changing this. "last_modified" will still be modified
ONLY when the owner of the cache OR system administrator changes something
significant. It will NOT change in cases such as log entry.
BUT additional field to the database was added (caches.okapi_syncbase) which IS
updated every time ANYTHING is changed in the row (i.e. after adding a log
entry). We MAY think about using this field in conjunction with
'modified_since' parameter IF some developer think they could use it. However,
I assume that these developers will be much happier in using 'replicate' module
instead. That's why I close this issue. If anyone thinks it necessary, please
reopen.
Original comment by rygielski
on 13 Apr 2012 at 9:17
- Changed state: WontFix
from okapi.
Related Issues (20)
- Add new cache capabilities method(s) HOT 2
- Differenent cache capabilities at different OCPL sites HOT 2
- Improve admin-errormail antispam mode for Facade calls
- OC NL table okapi_diagnostics not found HOT 3
- Make download link(s) vissible on OKAPI search result page HOT 2
- OAuth2 protocol support HOT 1
- different use of services/apisrv/installation value registration_url HOT 1
- ACODE duplicates HOT 13
- Cache attribute in native language returned by OKAPI HOT 5
- OKAPI (update) cannot handle CREATE TABLE when there is a same table. HOT 2
- OCPL: Cache types HOT 6
- There is no way to remove blocked geocache from watched geocaches
- Accessing locked cache
- Upload field note file via OKAPI HOT 7
- PHP 7.4+ and 8.0 support HOT 3
- Make authorization page responsive HOT 2
- Reactivation rules automatically added to the end of the geocache description
- OKAPI Method Error - MainMapAjax HOT 3
- OCPL fulldump generation issue HOT 2
- imagegd2(): GD2 image support has been disabled HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from okapi.