DEV·4yDatabase GUIs in JavaScript
Traditional tools are often written in Java, C++ or Delphi and they use good old JDBC, ODBC or ADO.NET drivers for accessing database. Almost all tools are open-source. If you know about other tool not listed in this article, you could write about it in comments below. For SQLlite I actually use Firefox.
Better Programming·4yWriting My First Microservice Using Go
Go is an open source programming language supported by Google. The biggest companies using Go are Google, Netflix, Dropbox, Uber, Meta, Twitch, etc. With Go, you can create cloud & network services, web applications, and command-line interfaces. It’s a great solution to aggregate, collect, store and visualize logs from your applications.
LogRocket·4yPrisma vs. Thin Backend
Prisma enables you to access your database straight from Node.js and TypeScript application code. Thin Backend provides you with an IDE that has custom business logic and serverless functions. Prisma is a type-safe query builder that is an alternative to Sequelize and TypeORM.
TigerData (Creators of TimescaleDB)·4yPostgreSQL + TimescaleDB: 1000x Faster Queries, 90% Data Compression, and Much More
TimescaleDB can dramatically improve query performance by 1000x or more, reduce storage utilization by 90% or more. Timescale provides two methods to reduce the amount of data being stored, compression and downsampling using continuous aggregates.
LogRocket·4yComparing the 7 best ORM packages in Go
The GORM (Go-ORM) package is the most popular ORM package in the Go ecosystem. The SQLC package provides database queries, transactions, configurations, and functionalities. The Beego ORM is a powerful ORM inspired by popular Python ORMs, like the Django ORM and SQLAlchemy.
freeCodeCamp·4yCreate a Low-Code Ecommerce App with Stripe, Postgres, & REST API Backend
A low-code platform can give you pre-built UI components packed with functionality like tables, buttons, and text inputs. This allows you to skip the frontend templates and build your own quickly. We just published a tutorial on the freeCodeCamp.org YouTube channel.
Fly.io·4yIntroducing LiteFS
LiteFS works by interposing a very thin virtual file system between your app and your on-disk database file. The FUSE file system solves many of these usability issues by being a single point that all database calls go through. LiteFS also needs to run an API server to replicate data between nodes. It uses Hashicorp's Consul to determine the primary node in your cluster.
Pointer·4yPostgres Full Text Search is Awesome!
ElasticSearch has all kinds of best in class features, like a modified version of BM25 that is state of the art. But the ElasticSearch approach is a dead end for 2 reasons: Trying to improve search relevance with statistics like TF-IDF and BM25 is like trying to make a flying car.
Golang News·4yGolang Tutorial to setup a RESTful API Project with Postgres and GORM
Golang Tutorial to setup a RESTful API Project with Postgres and GORM Golang. Golang has impressive features that support the needs of microservice architecture, large-scale enterprise applications, and distributed systems.
