Prometiam API Offers Single-Call Access to Irish CRO Company Data

·6 views

Developer and Prometiam founder Matías Maquieira has introduced a REST API that serves Ireland's Companies Registration Office register as JSON in a single call. The API draws from the CRO Open Data Portal, which is licensed under CC BY 4.0, and supports search by company name or CRO number. Each record includes the legal name, company number, legal form, status, registered address, Eircode, and key filing dates such as last annual return and next accounts due. The tool is positioned as a lightweight alternative to scraping the CRO website or subscribing to enterprise KYB platforms. A free 14-day trial offering 1,000 API calls without requiring a credit card is available at prometiam.com, though the API does not include directors, officers, or beneficial ownership data.

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)

Oracle SQL Statement Types Explained: DML, DDL, DCL, and TCL Defined

Oracle SQL statements are grouped into four main categories based on their function in database operations. Data Manipulation Language (DML) handles data retrieval and modification using commands like SELECT, INSERT, UPDATE, and DELETE, while Data Definition Language (DDL) manages database structures with commands such as CREATE, ALTER, and DROP. A key distinction is that DDL statements automatically trigger an implicit COMMIT and cannot be rolled back, unlike DML changes. Data Control Language (DCL) governs user access permissions through GRANT and REVOKE, while Transaction Control Language (TCL) manages DML transactions using COMMIT, ROLLBACK, and SAVEPOINT. Beyond classifications, core SQL SELECT capabilities include projection for choosing columns, selection for filtering rows, and joining for combining data across multiple tables.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Oracle SQL Environment Commands Every Developer Should Know for Interviews

Oracle SQL*Plus and SQL Developer offer several environment control commands that shape how scripts execute and how output is displayed. Commands like SET DEFINE OFF prevent the ampersand character from being misread as a substitution variable prefix, which is critical in automated deployment pipelines handling URLs or company names such as AT&T. Performance-related commands such as SET TIMING ON and SET FEEDBACK help developers benchmark queries and monitor result counts directly from the command line. Display commands including SET LINESIZE, SET PAGESIZE, and SET LONG control output formatting and the handling of large data types like CLOBs and XMLType. A key distinction for interviews is that these SET commands are client-side parameters and do not influence server-side execution plans, unlike bind variables which promote plan reuse in the database's Shared Pool.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Silent pg_restore Bug Can Lose Entire Tables When Restoring Supabase Backups

A developer discovered that restoring a Supabase database backup using standard pg_restore can silently drop entire tables without raising a fatal error. The issue occurs because Supabase-specific functions like auth.uid(), commonly used as column defaults, fail when restored into a plain PostgreSQL environment that lacks the auth schema. By default, pg_restore logs these errors but continues execution, leaving the affected tables and their data absent from the restored database. The bug is particularly dangerous because developers testing Supabase backups are already conditioned to ignore auth-related errors, making missing tables easy to overlook. The fix involves creating stub roles and a minimal auth schema in the target database before running pg_restore, ensuring dependent objects resolve correctly during restoration.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Dokwise Processes PDFs Entirely In-Browser, With CSP to Prove No Data Leaves

A developer has built Dokwise, a free browser-based toolkit offering 16 PDF and image processing tools — including merge, split, OCR, compress, and e-signature — that require no account and no server. All file processing runs locally using JavaScript libraries such as pdf-lib, tesseract.js, and native browser APIs, meaning files never leave the user's device. The site enforces a strict Content Security Policy (CSP) that blocks any network requests to unlisted hosts, preventing both first-party and third-party code from silently transmitting data. The developer acknowledged that tesseract.js originally fetched worker and language files from an external CDN, which was resolved by bundling all assets locally. The only external connections permitted are to Google Analytics for anonymous page-view tracking, which is disclosed in the site's privacy policy and visible in the CSP header.

0 comments Read more at DEV Community