Writing

Release 26.3 of the modular Fusabase JavaScript SDK adds a local cache, queued writes, and sync, so web apps keep reading and writing documents when the network drops.

How to configure a Google OAuth web client, connect it to Fusabase, and add Google popup sign-in with the Fusabase JavaScript SDK.

How to configure a GitHub OAuth App, connect it to Fusabase, and add GitHub popup sign-in to a web app with the Fusabase JavaScript SDK.

How to put an OCI API Gateway in front of an existing Fusabase environment, so your app gets a public HTTPS endpoint while ORDS stays private behind it.

Read-only partitions and subpartitions let you block inserts, updates, and deletes. How to create, check, and change them in the Oracle Database.

Real-time materialized views give you fresh results from a stale materialized view at query time. A demo of ON QUERY COMPUTATION and the FRESH_MV hint.

How Global Temporary Tables work in the Oracle Database, including ON COMMIT DELETE and PRESERVE ROWS, and how they differ from Private Temporary Tables.

Virtual columns in the Oracle Database aren't stored physically but are calculated on the fly when selected. A quick example using NHL shooting percentage.

PIVOT rotates rows into columns and UNPIVOT turns columns back into rows. A simple Oracle Database example using quarterly sales data by region.

Identity columns give you an easy way to create unique numeric IDs without sequences and triggers. Covers GENERATED ALWAYS, BY DEFAULT, and ON NULL.

The PL/SQL Function Result Cache lets you easily cache commonly calculated function results. This blog walks through a practical example with timings.

What APPROX_COUNT_DISTINCT is and how it's used in the Oracle Database, with demos comparing exact COUNT(DISTINCT) to faster approximate counts.

What Advanced Index Compression is and how it's used, covering the LOW and HIGH levels, the Compression Advisor, and a demo comparing index sizes.

Invisible indexes let you test index changes safely in the Oracle Database without impacting normal operations. A quick demo, plus invisible vs unusable.

DBMS_CLOUD lets your Oracle database work with object storage like OCI, Amazon S3, and Azure Blob. Examples of loading, exporting, and external tables.

What Hybrid Partitioned Tables are and how to use them: keep recent data in internal partitions and older data in external files, queried as one table.

What SQL Macros are in the Oracle Database, with practical examples of scalar and table SQL Macros that give you function-like reuse without the overhead.

What Private Temporary Tables are in the Oracle Database, with practical examples of the ORA$PTT_ prefix, transaction vs session duration, and savepoints.

This blog highlights 10 Oracle Database features that might fly under your radar, from Flashback Time Travel and SQL Macros to invisible indexes.

What are Invisible Columns? Invisible columns are exactly what they sound like: columns that exist in your table but don’t show up in a...

Online Table Move lets you move a table, its partitions, and subpartitions without downtime. A demo moving and compressing a table under a live workload.

What Flashback Time Travel is in the Oracle Database, with a small demo that sets up a Flashback Archive, tracks changes, and queries historical data.

A high level look at how AI Vector Search in Oracle Database 23ai works: vectors, embedding models, and VECTOR_DISTANCE, with a cocktail app example.

Extend the Coffee Brew Tracker Node.js app with JSON Relational Duality Views in Oracle Database 23ai, querying and inserting JSON through node-oracledb.

This blog walks through how to build a simple coffee brew tracking Node.js app and store your data in a free Oracle Cloud Database using node-oracledb.

We're setting up a free Oracle Database 23ai on Oracle Cloud in less time than it takes to make a latte, from sign-up to a running Autonomous Database.

If you're building a python app and need a database, you can connect to a free cloud hosted Oracle Autonomous Database with 5 lines of...

A small reflection after ~2 years as an Oracle Product Manager: the point isn't to achieve mastery and stop. There's always something new to learn.

The shrink_tablespace procedure in Oracle Database 23ai offers a simple way to reclaim unused space in your tablespace. A demo of analyze and shrink modes.

Hey, I'm Killian. A bit about me, what I'll be writing about (mostly the Oracle Database), what a Product Manager does, and why I'm starting this blog.