TraceTogether: under the hood

#1 — TraceTogether is Serverless

#2 — Data Records & SQLite Storage

TraceTogether SQLite DB Queries
  1. id, integer, primary key, autoincrement, not null
  2. timestamp, integer, not null
  3. v, integer, not null
  4. msg, text, not null
  5. org, text, not null
  6. modelP, text, not null
  7. modelC, text, not null
  8. rssi, integer, not null
  9. txPower, integer

Mar 23, 2020 Update: 1.0.30

#3– [RESOLVED] 21 Day Data Retention Policy?

The only destructive reference to record_table, very destructive

Mar 23, 2020 Update: 1.0.30

Apr 9, 2020 Update: 1.5

#4 — Jargons & Protocols: StreetPass, GATT, BLE

TraceTogether Code References to ‘StreetPass’

#5 — Proudly Made in Singapore 🇸🇬

WTF?
Alamak 🤦

--

--

--

Full-Stack & DevOps Engineer, Certified Ethical Hacker, GeoSpatial Enthusiast. https://linkedin.com/in/frankliauw/

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How we made a unique skill for kids — “ Make your own Superhero”

What is Josephus Problem and how to solve it without any in-built function?

Django + mySQL Workbench 紀錄

The Angular CLI is Creating Your Unit Tests Wrong

Monitoring vs observability

What’s more perplexing, sometimes these patients have oxygen levels that low and have absolutely…

How to Perform POST, DELETE, PUT, GET Method in Rest Assured?

How to sort result set in custom order in SQL?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
🇸🇬 Frank Liauw

🇸🇬 Frank Liauw

Full-Stack & DevOps Engineer, Certified Ethical Hacker, GeoSpatial Enthusiast. https://linkedin.com/in/frankliauw/

More from Medium

So why am I here?

Director’s Bulletin | November/December 2021

A drake and hen blue-winged teal flying

The Burning Bear Problem: Russian Cyberwarfare Unleashed

What’s Happening in Afghanistan Threatens Women Everywhere.