Thingsboard
postgrest
Our great sponsors
Thingsboard | postgrest | |
---|---|---|
17 | 100 | |
15,639 | 22,282 | |
2.9% | 1.9% | |
10.0 | 9.7 | |
4 days ago | 5 days ago | |
Java | Haskell | |
Apache License 2.0 | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Thingsboard
-
ThingsBoard Microservices Installation Update Problem
Until recently I was still using TB v3.2.1, now I've set about updating the installation to the latest version. I proceeded as described at https://github.com/thingsboard/thingsboard/tree/master/docker:
-
Looking to implement a real time tracking feature in my Django project and I dunno where to begin
You might find something more attuned to that use case to be more helpful out of the box (like thingsboard.io) but if you're committed to django, set up an API endpoint to receive json updates ('events') sent from the arduino.
- Sites to download source code from? (Leaked or not)
- Suitability of GCP pubsub or Firebase for IoT devices instead of AWS IoT Core?
-
Best Four IoT Platforms
Introduction:As a 100% open source IoT platform that can be hosted as a SaaS or PaaS solution, Thingsboard can provide device management, data collection, processing and visualization for your IoT project. The standard protocols that provide device connectivity such as MQTT, CoAP, and HTTP are all available on ThingsBoard. In addition, it supports cloud and local deployment and provides more than 30 customizable components that allow you to build end-user custom dashboards for most IoT cases. GitHub: https://github.com/thingsboardThingsboard: http://thingsboard.io/ Features:
-
Newbie: how important is aeration for small NAS / server room?
Then host a ThingsBoard server and use the HTTP API to push data from the device. You can send alerts with Pushover.
-
React component library Concis | Components break through 50+, mobile concis starts, new English documentation, continuous update...
**Source** [thingsboard (a foreign iot platform)](https://thingsboard.io/)
-
How to Access MQTT Data with ThingsBoard
ThingsBoard is an open-source IoT platform for data collection, processing, visualization and device management. It supports device connectivity via protocols, such as MQTT, CoAP and HTTP, and supports both cloud and private deployments. Deliver, monitor and control your IoT entities in a secure way using rich server-side APIs that define the relationships between your devices, assets, customers, or any other entities. Collect and store telemetry data in a scalable and fault-tolerant manner, visualize your data with built-in or custom widgets and flexible dashboards, and share the Dashboard interface with your customers.
-
Zelensky: “Ukraine has a lot to offer the world, products and services created by Ukrainians. Ukrainian companies – join. World – use. Tell your foreign friends about it. Spend with Ukraine to stand for Ukraine.“
The company I work for uses https://thingsboard.io and the team from Ukraine that built it are awesome and the company is still responding even though they are going through this hell of a war.
- ThingsBoard - Open-source IoT Platform
postgrest
-
Supabase – General Availability Week
hey hn, supabase ceo her
we just announced GA, after ~4 years of beta. for those who don't know: supabase is a postgres hosting company. we also host other open source "backend" tools that make it easy to get started with postgres (tools like PostgREST for auto-generate APIs [0])
we owe a lot to the HN community. you launched us 4 years ago [1], when we were just a few developers. since then HN has been a staple in our journey, one of the best sources of product feedback [2]
the GA badge is mostly to signify organizational readiness. we're at a stage where we can take any profile of customer. we have a support team that works 24/7, and a success team that will help customers improve their postgres usage. we released our Index Advisor [3] yesterday, and we'll be releasing a few more products this week that helps customer with performance and security.
on a personal note: i read HN most days, and love going through the ShowHN's to see what devs are building. thanks for being an awesome community and my favorite place to lurk on the internet. i'll stick around to answer any questions
[0] PostgREST: https://postgrest.org
[1] Launch: https://news.ycombinator.com/item?id=23319901
[2] HN journey: https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu...
[3] Index Advisor: https://news.ycombinator.com/item?id=40028111
-
The Many Ways Not to Build an API
If you use PostgreSQL and are proficient with using its row-level security feature, you can choose from several tools/services built above RLS, including Supabase, PostgREST, and PostGraphile. They all provide a way to expose database CRUD as a web API, assuming you've configured the RLS rules to properly secure the access.
- Soul: A SQLite REST and Realtime Server
-
Build a simple project management app with Neon, PostgREST, and DigitalOcean
wget 'https://github.com/PostgREST/postgrest/releases/download/v11.2.0/postgrest-v11.2.0-linux-static-x64.tar.xz'
-
Single Software Developer Projects
SupaBase is entirely based upon PostgREST. In fact, PostgREST is arguably 49% of their value proposition according to their own website. The other 49% is PostgreSQL. PostgreSQL of course is a super mature database, and some would argue the best RDBMS on the planet, so let's ignore that part for a moment, and consider it a mature thing and move on to PostgREST.
-
Oink: An API for PHP in a single file
You don't need this PHP snippet:
To get the same functionality without the extra step, simply use PostgREST [1]
[1] https://postgrest.org/
- Ask HN: Popular open source tool originally written in Haskell?
-
Use PostgREST and HTMX to Build RESTful APIs from PostgreSQL Databases
PostgREST is a standalone web server that turns your PostgreSQL database into a RESTful API using the database's structural constraints and permissions to define the API's endpoints and operations. In this tutorial, you will create a simple note-taking app by leveraging PostgREST to construct a RESTful API for the app and using htmx to deliver HTML content.
-
We built our customer data warehouse all on Postgres
You might find some info in the docs of PostgREST [1] or in the previous discussions on HN about it [2].
For the versioning, I just have a git repo where I keep every role, schema, table, view, function, trigger, etc. definitions. Every time I change something in the database I first change it in the git repo too to have an history.
[1] https://postgrest.org
[2] https://hn.algolia.com/?q=postgrest
-
Pandoc
Don't know if you would call this a "program" but PostgREST is written is Haskell too.
https://github.com/PostgREST/postgrest
What are some alternatives?
Grafana - The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
Thingspeak - ThingSpeak is an open source “Internet of Things” application and API to store and retrieve data from things using HTTP over the Internet or via a Local Area Network. With ThingSpeak, you can create sensor logging applications, location tracking applications, and a social network of things with status updates.
supabase - The open source Firebase alternative.
openremote - 100% open-source IoT Platform - Integrate your devices, create rules, and analyse and visualise your data
postgres-websockets - PostgreSQL + Websockets
DeviceHive - DeviceHive Java Server
Appwrite - Build like a team of hundreds_
Freeboard - A damn-sexy, open source real-time dashboard builder for IOT and other web mashups. A free open-source alternative to Geckoboard.
gotrue - An SWT based API for managing users and issuing SWT tokens.
Iotdashboard - Fast Django server for IOT Devices
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.