in reply to Re: How to interpolate sql-output
in thread How to interpolate sql-output
I'm quite aware how dangerous is to let pp make own queries.
This is only for admins of that software.
Why two tables? There are one table which contains only id of that item and its' activity.
Other table contains all fields in key-value-way, so one can add fields as many as one wants without altering db-schema.
That order and limit gets only latest value, cause there is no alter or delete, just inserts, so it builds history of changes.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^3: How to interpolate sql-output
by chacham (Prior) on Jan 14, 2015 at 22:46 UTC | |
by Seq (Novice) on Jan 14, 2015 at 23:15 UTC | |
by chacham (Prior) on Jan 15, 2015 at 00:25 UTC | |
by Seq (Novice) on Jan 15, 2015 at 01:17 UTC | |
by chacham (Prior) on Jan 15, 2015 at 02:39 UTC | |
|