Lightnews — Scholar-powered news

Adding Custom Snippets in VS Code for SQL Developer

Reposted by Robert Marz

Jeff Smith @thatjeffsmith.com · 20d

Previously on @thatjeffsmith... Adding Custom Snippets in VS Code for SQL Developer

Previously on @thatjeffsmith... Adding Custom Snippets in VS Code for SQL Developer

On REST APIs and Oracle Database 23ai JSON native types

Reposted by Robert Marz

Jeff Smith @thatjeffsmith.com · Sep 9

Previously on @thatjeffsmith... On REST APIs and Oracle Database 23ai JSON native types

Previously on @thatjeffsmith... On REST APIs and Oracle Database 23ai JSON native types

Navigating your schemas/databases in SQLDev for VS Code

Reposted by Robert Marz

DLR-next @dlr-next.bsky.social · Sep 6

+++ Wichtiger Hinweis für alle Fußballfans: Wir haben den Ablauf der #Mondfinsternis morgen Abend so organisiert, dass die spektakulärste Phase mit dem Kernschatten rechtzeitig vor dem Anstoß stattfindet. +++ #Service

14 40 300

Reposted by Robert Marz

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · Sep 6

Different approaches to monitoring, according to @jasminfluri.bsky.social at #POUG2025

(The Poland version is applicable in many countries 😇)

1 3 10

Reposted by Robert Marz

Luiza Nowak @luizafrompoland.bsky.social · Sep 6

This is the #POUG essence. You can drink beer, you can party late, but you will also show up at 9 am the next day in the venue because the sessions are that good.

4 12

Reposted by Robert Marz

Connor McDonald on Database and SQL @connormcd.bsky.social · Sep 6

Why take an outage to deploy applications when you don't need to

3 6

Reposted by Robert Marz

Jeff Smith @thatjeffsmith.com · Sep 5

Previously on @thatjeffsmith... Navigating your schemas/databases in SQLDev for VS Code

Previously on @thatjeffsmith... Navigating your schemas/databases in SQLDev for VS Code

Reading List – August 2025 #4

Reposted by Robert Marz

Øyvind Isene @oyvindisene.bsky.social · Sep 3

Insulting the AI.

1 3

Reposted by Robert Marz

Gerald Venzl @gvenzl.bsky.social · Sep 1

📚 A rather mixed bag of items is in this week's reading list:

🔐 #security, ⚒️ #internals, 💡 #insights, and a by many long-awaited 🎉 #announcement are all included

Happy reading 🤓

📰 💡 Using a modern database? You might not need that ORM anymore - Anders Swanson shares his thoughts on potential ORM alternatives 📰 ZDLRA - How to manually register databases - Byran Grenn gives step-by-step instructions to manually register an Oracle Database with Zero Data Loss Recovery Appliance 📺 OCI Network Firewall - SSL Inspection - Oracle Learning demonstrates the SSL Inspection feature of the OCI Network Firewall…

www.geraldonit.com

How to manually configure DNS on your Windows 11 Wifi connection

Reposted by Robert Marz

Orin Thomas @orinthomas.com · Sep 1

How to manually configure DNS on your Windows 11 Wifi connection. youtu.be/YW6dFVwddpY

YouTube video by ITOpsTalk

youtu.be

Reposted by Robert Marz

Tim Hall @oraclebase.bsky.social · Sep 1

A little story of Oracle APEX (Low Code) for the win

oracle-base.com/blog/2025/09...

@OracleAPEX #orclapex

5 4 10

Reposted by Robert Marz

Chris Saxon @chrisrsaxon.bsky.social · Aug 27

Get faster PL/SQL in #SQL with

alter session set sql_transpiler = on

=> database will convert eligible functions to SQL

Read my latest post for details on

What can be transpiled
Transpiler vs scalar macros
Functional differences
Impact of function-based indexes

blogs.oracle.com/sql/post/fas...

blogs.oracle.com

6 12

Reposted by Robert Marz

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · Aug 28

Fast=true

(Almost, at least 😇)

Read Chris’s blog post and learn how.

Organize VS Code Database Environments: Connection Folders

Reposted by Robert Marz

Marie von den Benken @regendelfin.bsky.social · Aug 28

Der Friseur, der Merz in nicht mal vier Monaten 12.000 Euro für DIESE Frisur abgenommen hat, sollte umgehend Finanzminister werden. Der Junge saniert Deutschland im Schlaf.

83 220 900

Reposted by Robert Marz

Jeff Smith @thatjeffsmith.com · Aug 23

Previously on @thatjeffsmith... Organize VS Code Database Environments: Connection Folders

Previously on @thatjeffsmith... Organize VS Code Database Environments: Connection Folders

JSON Relational Duality view & API for an ‘EMPLOYEES’ entity

Reposted by Robert Marz

pamelafox.bsky.social @pamelafox.bsky.social · Aug 23

New video: deploy a Python MCP server (FastMCP SDK) to Azure Functions (key auth), with optional APIM in front (Entra OAuth, following MCP auth spec).
Video: www.youtube.com/watch?v=PAxB...
Code: github.com/Azure-Sample...

Still from video where I'm using GitHub Copilot to make a call to the server

1 2 5

Reposted by Robert Marz

Jeff Smith @thatjeffsmith.com · Aug 23

Previously on @thatjeffsmith... JSON Relational Duality view & API for an ‘EMPLOYEES’ entity

Previously on @thatjeffsmith... JSON Relational Duality view & API for an ‘EMPLOYEES’ entity

Reposted by Robert Marz

Andrea Dengel @dengel-consulting.com · Aug 23

Hier kann man den Status der IT Sicherheit in Deutschland bei Tageslicht sehen. Dienstleister die wie getroffene Hunde reagieren, Gesetze die von Leuten formuliert wurden die das Problem nicht verstehen. So erreichen wir nie das #Cybersec Niveau das wir brauchen.

https://heise.de/-10569034

Oracle Database Materialized Columns – a closer look

Reposted by Robert Marz

Gerald Venzl @gvenzl.bsky.social · Aug 19

Materialized Columns are new in #Oracle #Database 23.7

Let's take a closer look at them!

⚠️ Lots of code coming next! 🤓

My recent blog post about Oracle Database 23.7 has generated significant interest in one particular feature: materialized columns. In this post, I’ll dive deeper into what materialized columns are, how they work, and when you might want to use—or avoid—them.

www.geraldonit.com

4 9

Reposted by Robert Marz

Jeff Smith @thatjeffsmith.com · Aug 19

Having a go with Windsurf and Cascade, to generate a new 23ai schema, complete with test data and JSON Relational Duality Views...made possible in part with our MCP Server.

How did it go?

www.thatjeffsmith.com/archive/2025...

Building a new app schema database using Windsurf and GPT-5

How good is ChatGPT 5 at generating an oracle data model using 23ai syntax, and can Windsurf successfully implement it with our Oracle Database MCP Server?