DuckDB 2.0 Alpha Triggers: BEFORE Row-Level Support Missing, Row Triggers Cost 3x

·1 views

A developer tested the DuckDB 2.0 alpha build's trigger feature against the stable 1.5 development build on the same machine. Most BEFORE FOR EACH ROW triggers fail with a 'not yet supported' error, and AFTER FOR EACH ROW triggers work for INSERT and DELETE but not UPDATE. Statement-level triggers functioned for both BEFORE and AFTER across all tested events. Benchmarks on 500,000 inserts showed a row-level AFTER INSERT trigger was about 3.0 times slower than no trigger, while a statement-level equivalent added only about 1.3 times overhead. The tester also found undocumented restrictions, including that statement and row triggers cannot be mixed on one table, and that the DROP TRIGGER syntax in the preview post fails on this build.

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)

Developer builds Duo-Man, a virtual Walkman app for the foldable iPhone Duo

Developer Vidit Bhargava has created Duo-Man, an app for the foldable iPhone Duo using the new BitRig development environment. The app uses hinge state events to mimic the cassette-door behavior of classic Walkman players. Its features include interface control through APIs for the 7.6-inch internal display, and audio feedback built from real field recordings. It also integrates with Apple Music and local files, and supports Apple Pencil to simulate physically spinning a cassette tape reel.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

CSS alpha(): serve davvero o è solo zucchero sintattico?

Il testo analizza tre modi per ottenere una variante trasparente di un colore definito in una custom property CSS. Per anni la soluzione più diffusa è stata scomporre il colore in canali, con il limite di vincolare il formato colore e rendere il codice fragile. Le alternative moderne sono color-mix() con transparent, che miscela il colore verso la trasparenza, e i colori relativi, che ricostruiscono il colore in un'altra funzione impostandone l'alpha. La nuova funzione alpha() svolge esattamente il compito di impostare un'opacità, senza scegliere spazi colore né riscrivere i canali, rendendo il codice più leggibile.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

AI, Quantum Computing and Biotech Seen as Key Technologies for the Next Decade

Emerging technologies such as artificial intelligence, quantum computing and biotechnology are increasingly moving from research labs into commercial products. AI is evolving from single-task tools toward agentic systems that can plan steps, use tools and revise their own results toward a goal. Quantum computers exploit superposition and entanglement to tackle specific hard problems like molecular simulation, though qubits remain fragile and error-prone. Biotechnology, now heavily data-driven, depends on bioinformatics, which makes it a valuable skill for computer science students. The article also highlights that all three fields demand large computing power, which cloud infrastructure increasingly provides.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

RecallForge: an offline, open-source study workspace with source-linked practice

The developer built RecallForge, a free and open-source tool that helps learners repeat cycles of practice, mistake review and revision. The browser-based viewer works without an account, storing study data locally in the browser and functioning offline once opened. It includes sample packs on investment fundamentals, technical analysis, financial risk and Cell Biology, though these are demonstrations rather than official exam material. Learners can study with immediate feedback or sit timed exams, and can build focused retests from wrong or skipped questions. The article also stresses that browser-local data can be lost when browser data is cleared or devices change, which is why portable encrypted or plain JSON backups are provided.

0 comments Read more at DEV Community