Differences

This shows you the differences between two versions of the page.

--- databases [2018/06/28 18:32] – donpdonp
+++ databases [2024/01/31 04:08] (current) – external edit 127.0.0.1
@@ Line 8: / Line 8: @@
   * https://db-engines.com/en/ranking
-Record: id, user, lat, lng, time
+  * Location: id, user, point, time
+  * User: id, username, email
+  * Fence: id, polygon
+== Queries
+| insert Location at time T |
+| read Locations in timespan and is user |
+| insert Fence |
+| read Fences containing point and is user |
+| insert User |
+| read User is username |
-| query | index |
-| insert record at time 1 | |
-| read record at latest time | time |