Overview of Repositories and Tools

The following list provides an overview of tools and applications that make use of or are connected to the lbsn-structure.

Repository/Link	Version	Description
		LBSN Base Structure:
RAW SQL		Relational PostgresSQL implementation of LBSN Structure
HLL SQL		A Privacy-aware version of RAW SQL, e.g. for visual analytics
Protocol Buffers		Definition of LBSN Structure in Protocol Buffers, e.g. for use in RPC
Python Compiled		A Python compiled version of Protobuf LBSN Structure
PHP Compiled		A PHP compiled version of Protobuf LBSN Structure
		LBSN Docker Container:
RAW DB		A ready to use Docker Container using the LBSN RAW SQL structure
HLL DB		A ready to use Docker Container using the (privacy-aware) LBSN HLL SQL structure
pg-hll-empty		An empty Postgres Docker container with HLL extension installed, e.g. used in lbsntransform to anonymize data
jupyter lab		A containerized version of Jupyter Lab, used for interactive visualization purposes, e.g. in the tutorial section
		LBSN Tools:
lbsntransform		A python package for bulk data migration to and from lbsn structure (both Postgres and ProtoBuf specification)
twitterparser		An example python program that uses lbsntransform as a package to process twitter jsons stored in custom structured zip files from a remote server
lbsn-ctl		An easy to use shell-script to setup RAW DB and HLL DB Docker Container, including data export and import
		LBSN API (theplink-docker):
Alembic Migrations		Automatic migrations of live PostgresSQL with updates to the RAW LBSN Structure
Backend		Backend using Fastapi and LBSN Structure implemented as a SQLAlchemy model
Frontend		Frontend as a progressive web app based on VueJS and Mapbox GL JS, a prototype for local community discourse using the LBSN Structure