Tag: database

All the articles with the tag "database".

• Using Solr (Part 2): Full and Incremental Imports from MySQL

  2 May, 2020

  Explains how to configure Solr DataImportHandler for full and incremental imports from MySQL and periodically refresh data with operating-system scheduled jobs. It also covers tinyint fields, multivalued fields, and Transformers, and outlines DIH components and changes in later versions.

• Using Shiro: Password Hashing and Salting, with Authentication Troubleshooting

  20 Apr, 2019

  This article walks through password hashing, salted storage, and login verification in Shiro and uses its source code to explain credential comparison. It also covers troubleshooting passwords still stored as plaintext and authentication failures after salting, including the roles of the algorithm, salt, and hash iteration count.

• Oracle Query Notes (Part 2): INSTR, LPAD, and RPAD

  31 Jul, 2018

  This article introduces Oracle’s INSTR function through examples of its parameters, return values, and use in WHERE conditions. It then explains the padding directions of LPAD and RPAD, using a sequence value padded with zeros as an example.