How to Query OCI Object Storage Bucket Files via SQL Using Resource Principals

·62 views

Oracle Cloud Infrastructure (OCI) allows database users to read object storage bucket files directly through SQL by leveraging resource principals. The process begins with creating a dynamic group in OCI and assigning it a policy that permits read access to the target bucket. A database administrator must then enable resource principal support and grant the relevant schema access to the DBMS_CLOUD package. Once configured, users can list and query bucket objects using the DBMS_CLOUD.LIST_OBJECTS function with the OCI$RESOURCE_PRINCIPAL credential. This approach works for both autonomous and non-autonomous Oracle Databases, provided they are hosted within OCI.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Jensen Huang Reportedly Described an Avalanche of Excess Wafers and Memory

A new report says Nvidia CEO Jensen Huang acknowledged his company was confronting a flood of surplus wafers and memory chips. The account reportedly sheds light on the broader GPU and RAM supply crisis affecting the chip industry. The details come from a respawnfirst.com article that was shared and discussed on Hacker News. The source material provided is limited, so the specifics of the surplus and its timing are not fully detailed here. The story has drawn modest attention so far, with a small number of points and comments.

0 comments Read more at Hacker News

ProgrammingDEV Community ·

A Practical Workflow for Writing Better AI Image Prompts

Detailed prompts help image generators better understand a visual's subject, location, composition, lighting, and style. The article recommends organizing prompts with a reusable template and avoiding excessive extra details, which can confuse the generator and dilute emphasis. It advises controlled testing, since different tools can interpret the same prompt differently, and suggests analyzing failed outputs to identify issues like poor subject recognition, background overemphasis, or stylistic mismatch. Prompts that produce useful results should be saved to avoid starting from scratch each time. Overall, the piece frames prompt writing as an iterative, repeatable creative process rather than a single perfect formula.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Subtitle Parser Passes Error Checks Yet Captions Remain Hard to Read

A developer building the SubtitlePop caption tool found that a subtitle file parsed with zero errors still produced hard-to-read captions. The sample had overlapping cues, a caption displayed for only 0.6 seconds that holds 61 characters, and a line exceeding the configured length limit. The author published an open-source companion tool, subtitle-timing-kit, that flags such timing problems as warnings rather than errors. The tool's reading-speed and line-length thresholds are adjustable review aids, not accessibility certifications. The post also notes that overlapping cues can be legitimate, so flagging them is not the same as rejecting them.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Guide Outlines Zero-Downtime Strategies for Migrating MySQL to PostgreSQL or MongoDB

A DEV Community guide explains how to move data from MySQL to PostgreSQL or MongoDB without interrupting service. It recommends replicating data in real time with tools such as MySQL replication, SymmetricDS, or Tungsten Replicator. Data consistency should be checked across both databases using utilities like pt-table-checksum or MySQL Workbench. The article also describes a cutover plan that switches applications to the new database once validation passes, followed by ongoing performance monitoring.

0 comments Read more at DEV Community