Skip to content

Content Tagged "insert"

Page 1 of 1

Content Tagged "insert"

Insert in PostgreSQL in (Almost) Constant Time

May 15, 2014Category: Software
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 40 million and the script went through several…

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

April 1, 2014Category: Software
An important note when loading XSDs in Oracle is that DBMS XMLSCHEMA.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…

UPSERT (update or insert) in Oracle with Python

March 24, 2014Category: Software
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: ID - a 20-character string identifier with PK properties (unique) ARTICLE - an XMLType element with the article details CITEDBY - an…

Simulate INSert key on mac OSX

December 3, 2013Category: IT
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 Norton Commander to do file operations. In my…

All tags