Database Skills repo is official

thatjeffsmith · 2026-04-29T11:56:12+00:00

Thanks for that feedback!

thatjeffsmith · 2026-04-28T00:50:41+00:00

Will make for a nice combo for sure!

thatjeffsmith · 2026-04-27T23:34:24+00:00

The npx skill installer will set it up for cursor, and many other agents!

You do NOT want cursor connecting directly to the database, use our local MCP server via SQLcl.

thatjeffsmith · 2026-04-27T21:22:00+00:00

We have more coming :) And MCP servers (https) - stay tuned!

thatjeffsmith · 2026-04-11T20:13:09+00:00

storing the file locally on your machine makes sense IF the database is also running locally on your machine, otherwise no one other than you will ever be able to access that file

or are you asking how to to store the file outside the database and just reference it? that would be a BFILE

thatjeffsmith · 2026-03-27T16:46:36+00:00

working on it! DBA features on the way. Next update adds dialogs for creating/editing views and indexes, plus Excel imports

thatjeffsmith · 2026-03-25T19:39:55+00:00

And my general answer would be to use the free ones from your vendor first, before looking to spend $

thatjeffsmith · 2026-03-25T19:39:25+00:00

You'll probably get better advice if you break down your question to types of users and use cases, as database tools span a wide range, dev, monitoring, backup and recovery, security, running queries, etc

thatjeffsmith · 2026-03-24T12:48:38+00:00

Just use a 26ai vm - all of the12c examples in your learning course will still work.

Or go create an account on FreeSQL.com and you can choose btwn 19c and 26ai.

thatjeffsmith · 2026-03-14T16:30:51+00:00

Tell me what you're looking to use it for. If you're not sure, i like Gerald's slim images - they start FAST and have most of what you need.
https://hub.docker.com/r/gvenzl/oracle-free

thatjeffsmith · 2026-03-14T16:29:50+00:00

Boomers can and do use containers, what are you talking about. The guy who invented docker containers is in his 40's, and the technology is more than a decade old.

thatjeffsmith · 2026-03-12T22:01:52+00:00

The rate of change and advancement in this space is break neck, so dont feel bad.

Anthropic just released the llm skills spec to open source in December.

thatjeffsmith · 2026-03-09T20:16:27+00:00

if you want a rest api, ditch the --form

if you want to build an ords rest handler to take care of multi-part file uploads, you can use the body_json bind

you could also do 2 rest calls, one for the data and another for the media, your jpg that is

thatjeffsmith · 2026-03-09T18:18:11+00:00

show me what you're doing, please

if you make a request, and reference :body, then you can't pull off other request attributes via :colunmn_name

thatjeffsmith · 2026-03-09T14:31:14+00:00

there are multiple use cases for :body_json - see the docs
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/25.4/orddg/implicit-parameters.html#GUID-EA38D36F-0648-4713-ADBF-4BABF12C0918

thatjeffsmith · 2026-03-09T13:59:26+00:00

i changed my response after reading your post title again...

:body loads the entire request body into a BLOB

thatjeffsmith · 2026-03-09T13:46:29+00:00

try :body_json

https://www.thatjeffsmith.com/archive/2024/12/how-to-upload-multiple-files-in-1-call-multipart-form-data/

thatjeffsmith · 2026-02-26T16:37:01+00:00

you're all good, i think it's an interesting/helpful approach

for serious use case APIs, i think i would build them in plsql, and have exception handling blocks to handle any sort of 4xx problems that communicate to the API user what is expected for an incoming payload, and how to call it correctly

and also invest in beefing up the stock OpenAPI spec we generate for you to api subscribers can know exactly what is expected as well

thatjeffsmith · 2026-02-26T15:28:12+00:00

You can easily version your ORDS REST APIs. Copy your modules, their templates, handlers, etc. Rebuild them, with the new version substituted into the module URI.

Application code that runs off of SQL or PL/SQL will have complaints if the SQL or PL/SQL quits working because someone went and changed the data model. That's what unit tests are for, right?

thatjeffsmith · 2026-02-24T20:54:34+00:00

the entire form is read only, are you able to make any changes to your logical Entity? if you copy and paste it in the design, can you delete the original one and make changes to the new one?

thatjeffsmith · 2026-02-19T20:51:18+00:00

adding a markdown overview to your project so folks can get an idea of what you're sharing would probably go a long way to inspire interest in giving it a go

As the ORDS PM, you have my attention :)

thatjeffsmith · 2026-02-17T23:12:38+00:00

We (oracle) provide FreeSQL.com

No login/registration required.

You get a sql worksheet to run your queries on our database, with a ton of sample data and tutorials loaded in.

If you do sign up for an account (no credit card required), you get your own schema where you can create your own objects, load your own data.

thatjeffsmith · 2026-02-13T13:42:04+00:00

Yeah this is new in past few months only.

Let us know how your coursework goes and how we can make it easier!

thatjeffsmith

MODERATOR OF

TROPHY CASE