SShortSingh.
TopTechnologyAI & MLStartupsProgrammingScienceBusinessFinanceCrypto & Web3World
Back to feed
Programming

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

0
·1 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)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

Developers Use Partition Key Sharding to Bypass DynamoDB Vector Search 100-Result Cap

DynamoDB added vector search support in August 2026, but limits each query to a maximum of 100 results (TopK=100), restricting use cases that require broad retrieval before reranking. A developer published a workaround using partition key sharding, splitting data across multiple shard groups using a SHA-256 hash of each item's ID. Queries are fired in parallel against all shards simultaneously, and results are merged and sorted by distance score on the application side. With five shards, this approach effectively raises the practical result ceiling to 500 per search. The method contrasts with Amazon S3 Vectors, which raised its own TopK limit from 100 to 10,000 in June 2026, highlighting an ongoing gap in DynamoDB's vector search capabilities.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Beginner's Guide: Setting Up Playwright for Browser Automation in VS Code with Python

Playwright is an open-source browser automation and end-to-end testing tool that supports Chromium, Firefox, and WebKit through a single API. It is compatible with multiple programming languages, including Python, JavaScript, Java, and .NET, making it versatile for developers. Installation requires running a pip command in the VS Code terminal followed by a separate command to download the necessary browsers. Users can verify a successful setup by running a short Python script that navigates to a webpage and prints its title. Best practices include using virtual environments per project and keeping Playwright updated regularly to avoid compatibility issues.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Network Engineer Joins DEV to Document Hardware, Software, and Infrastructure Projects

A network engineer going by the handle 1ndiehacker has joined the DEV Community platform to share their work on personal tech projects. Their interests span networking, embedded systems, wireless communication, microcontrollers, and security. One ongoing project evolved from an attempt to route IP traffic over a low-bandwidth wireless link, which failed but sparked a new idea focused on transmitting only the specific data needed. The engineer plans to document not just completed projects but also the failures, debugging sessions, and design decisions behind them. They are looking to connect with others interested in networking, embedded systems, and hands-on building.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Developer Builds Accessible Browser Scaling Game Using Astro and React Islands

A developer has created 'Size It Up Party', a browser-based game where players visually estimate size ratios between silhouettes rather than typing numeric answers. The project uses Astro for static pages and a focused React island solely for the interactive gameplay area, keeping the site fast, crawlable, and accessible. Scoring, validation, and normalization logic are housed in a separate TypeScript package, making the rules reusable across Daily and Unlimited game modes and testable independently of the DOM. Accessibility was a core design priority, with keyboard navigation, labeled buttons, and touch-friendly controls ensuring all users can interact without relying on precise pointer movement or color alone. The build demonstrates that a single interactive component can coexist with ordinary static content without requiring a fully client-rendered application.

0 comments Read more at DEV Community