insert - Laur's blog

Sign in Subscribe

insert

A collection of 4 posts

Insert in PostgreSQL in (Almost) Constant Time

Insert in PostgreSQL in (Almost) Constant Time

One of the things I did was to write a script to insert records in a PostgreSQL database. The records have with a quite simple structure: * id - char(20) * content - XML field * aside - XML field I was working with a sample of 10,000 entries out of

Use Oracle's RegisterSchema with Large Schemas (from Python)

Use Oracle's RegisterSchema with Large Schemas (from Python)

An important note when loading XSDs in Oracle is that DBMSXMLSCHEMA.registerSchema() requires the actual content of the _xsd is loaded in a string. A side effect is that strings in Oracle have limits and schemas can exceed those limits. Therefore, such strings must be fragmented. In this case, we

UPSERT (update or insert) in Oracle with Python

UPSERT (update or insert) in Oracle with Python

One of the things I had to do is to build a script to upload data (e.g. the content of a list of files) into a database with a single table. My table has 3 columns: 1. ID - a 20-character string identifier with PK properties (unique) 2. ARTICLE-

Simulate INSert key on mac OSX

Every once in a while I use MC (Midnight Commander) on OSX, simply because after all these years the two-pane file manager is still easier and quicker to use than the Finder. TL;DR: use <CTRL>+T to simulate INS key. Origins In my PC days, I used