Hoekstra (UK)

Home

How to open .bin & .cue Files?

  • Print
  • Email

So, you downloaded a torrent expecting a nice AVI- or MPG-file for instant-action AV entertainment, and all you got was a big .bin file and a funny little .cue file? Here's the Linux-way of how to extract the content from them:

Read more: How to open .bin & .cue Files?

How to open .daa Files?

  • Print
  • Email

Yet another bespoke file format that unsuccessfully attempts to futher the agenda of vendor lock-in: If you are running Windows, you need to purchase PowerISO from poweriso.com , if you are running X86-based Linux flavour, the same people offer a free program to read and write .daa files. Go figure...

Read more: How to open .daa Files?

How to open .nrg Files?

  • Print
  • Email

A well-meaning person gives you a .nrg file and you will not invest in a piece of expensive bespoke software to read it. After all, you run free, open-source software and never have and never will pay for software. What to do with this stupid .nrg file?

Read more: How to open .nrg Files?

Unix Utilies for Windows

  • Print
  • Email
If you want to install Perl on Windows or do anything vaguely sophisticated in the brain-dead command line shell of Windows (a.k.a. the DOS prompt), then you need a collection of commonly used UNIX utilities that can run under Windows.

I have put together such a collection of the most popular UNIX utilities and a few other command-line programs. Most of these are GPL-licensed (i.e. open source) and the remaining few are free-ware (but not open source). Either way, you can do with these programs whatever you want.

You can download the bundle of utilities from here.

These utilities are particularly useful for installing Perl on your Windows PC. Download Perl for Windows from http://www.activeperl.com. 

Read more: Unix Utilies for Windows

Product Quickcode Generator

  • Print
  • Email

How to generate a Base36 quick code sequence using the SHA2 hash

On a 'slowish' 2GHz machine it can generate 20,000 quickcodes per minute. The spread of the resulting quickcodes is near-perfectly even, which means that substrings of the quickcode can be used to construct a hashed directory tree for holding, for example, the huge amount of product image files associated with a product catalog. Using a hashed directory tree is a quick and efficient method to host millions of separate files for quick, random access, as most file systems only perform optimally with less than 1,000 contained in a directory

This deterministic techique uses a hash of the sequential Integer Id of an item to generate a typical product quickcode for it, as found in many shopping catalogues. Example of how a quickcode is generated from its primary key integer Id:

  • 1 => 8M9LFLN2
  • 2 => HZ40H3K0
  • 3 => 02LUJYQ2
  • etc..

You can download the Base36 Quickcode Generator test script, which demonstrates an implementation in Perl and MySQL.

Read more: Product Quickcode Generator

Oracle DBMS_PIPE - why you should abandon it

  • Print
  • Email
A classical method of getting Oracle-based processes communicating with the outside world is by using the DBMS_PIPE package: Typically, we write to a pipe from an Oracle PL/SQL-based process, and then we continuously run an asynchronous Oracle PL/SQL process which reads the pipe and processes what it reads. A common use of DBMS_PIPE is for debugging, logging and launching external processes.

Read more: Oracle DBMS_PIPE - why you should abandon it

Oracle External Procedures

  • Print
  • Email

It is possible to call O/S commands or third-party programs from within SQL or PL/SQL with external procedures. This guide describes how to build, install and use such an ExtProc and shows an exploit on how to grant yourself Oracle sysdba rights. Think of an ExtProc as an Oracle root kit.

Read more: Oracle External Procedures

Oracle server construction guide on Linux

  • Print
  • Email
A step-by-step construction guide to install and configure a Linux server from scratch and how to then install the Oracle 10g RDBMS on it.
 

Read more: Oracle server construction guide on Linux

Page 2 of 2

  • 1
  • 2
  • You are here:  
  • Home

Main Menu

  • Home
  • Software
    • SSIS
    • SSRS
    • Oracle
    • Linux HowTo's
    • Scheduler
    • Perl
    • Windows
    • Joomla
    • MySQL
  • Idle thoughts...
    • Crap Jokes
    • Philosophy
    • Travel
  • Evil Food Recipes
  • Languages
    • Afrikaans
    • Deutsch

Movie Posters

da Vinci Code.png

Auction Affiliate

Click to view details on eBay
Click to view details on eBay
RDGTOOLS WHEEL MARKING GAUGE METRIC / IMPERIAL ADJUSTMENT 0-125MM 0-5"
Location:YORKSHIRE
Price:925.00 GBP
Bids:0
End date:2021-05-17
End time:11:28:03 GMT
Time left:26 days 5:28:40
Status:Active
Buy It Now

Back to Top

© 2021 Hoekstra (UK)