Jul 19Member-onlyPseudo Change Timestamp-Finding recently changed table rows using Flashback Version Query to provide a surrogate last_changed columnMy challenge: replicate changes from database A to database B, once per day. The tables involved are pretty big (100M records). I really would not want to process them all into database B. However, the tables do not have a LAST_DATE_MODIFIED column that has a timestamp that is updated with…Oracle5 min read
Jul 15Member-onlyQuick Start with initially free Low Code Front End Development using Retool against ElephantSQL PostgreSQLFront end development can be an art. An almost pixel by pixel design, a careful crafting UX or even CX. And there is a time and place and technology set for that. And there is a range of front end applications that may not require or even justify that same…Low Code9 min read
Published in Towards Dev·Jul 14Member-onlyQuick start with free managed PostgreSQL database on ElephantSQLThis article shows you can quickly get started with a free, managed PostgreSQL database with a table full of country data (using ElephantSQL). ElephantSQL is a hosted, managed PostgreSQL service from the team that also provides CloudKarafka and several other nice services. It is a breeze to get going. …Elephantsql5 min read
Published in JavaScript in Plain English·Jun 5Member-onlySupabase for Persistence & Server-to-Client Push in Vanilla HTML/JS Web AppA step-by-step guide on how to use Supabase for persistence and server-to-client push in a vanilla HTML/JavaScript web app. — Supabase provides a cloud-based backend service to web applications. That means that any (static) web application can use Supabase for user authentication and data persistence. Supabase provides a server-to-client push notification service and it has server-side serverless functions that can, for example, handle webhooks (triggers from many different internet services)…Supabase11 min read
Published in Towards Dev·May 28Member-onlySteampipe-analyze data from cloud, files, platform, IaC using SQL queriesIn our daily work, we are dealing with data from many sources. Data in CSV files, from Cloud APIs, in mail servers, configuration files, Terraform plans, in logging systems, source code repositories, and many more. Different formats, access methods, and tools. …Steampipe6 min read
May 3Member-onlyCreating a minimal container image for a Go applicationHow hard can it be — to create the smallest possible container image to run a Go application? It is not hard to create a container image that contains an binary executable file — and that is what a Go application turns into during the build process. However, that does…Go3 min read
Published in Oracle Developers·Mar 22Member-onlyMarrying Fn Functions to Dapr.io-leverage the power of the proxyProject Fn provides a framework for creating and running serverless functions. It is the foundation for the Functions service on Oracle Cloud Infrastructure. Dapr.io is an open source project that provides a powerful personal assistant for any application and a distributed application runtime that especially shines with microservices. Some aspects…Dapr9 min read
Published in Towards Dev·Mar 14Member-onlyQuery Past Generations in Oracle Database SQL — PI Day SpecialToday is PI Day. March 14 or: 3–14 in the US. Of course it can be March 14th 2015–3–14–15 — only once but for some reason March 14 is baptized PI Day and is not unlike April Fool’s day the international day for nerdi stuff. You may want to check…Sql4 min read
Published in Oracle Developers·Jan 14Member-onlyConnecting a Go application to Oracle DatabaseIn this article, I want to walk you through connecting a Go app to a local Oracle Database and to Autonomous Database on OCI (both on-prem and autonomous, with and without Oracle Client libraries). That’s sounds like a lot, but I promise it’s easier than it sounds. One application uses…Go9 min read
Jan 9Member-onlyDapr and Kafka-easy bindingDapr is a runtime framework for distributed applications. Dapr also provides a personal assistant to any application and environment that offers standardized access to different facilities (state, secrets, configuration, pub/sub, actors) and technologies. Simply by using Dapr we can leverage a large number of Dapr components that through the Dapr…Dapr7 min read