Skip to content

Obviate.io

To anticipate and prevent

  • Home
  • About Us
  • History
  • Privacy Policy
  • Toggle search form

Category: Database

Wrapping my brain around DynamoDB

dynamodb At work I’ve been working on a big Amazon Web Services related project. For part of this project, I wanted to record some information in a database. Previously, all I’ve used has been relational databases like MySQL. One could use AWS Relational Database Service, but that’s expensive if you’re only storing a small amount…

Read More “Wrapping my brain around DynamoDB” »

Cloud

(Re-)Introducing PDNSOps

By Dsv (Own work) Public domain, via Wikimedia Commons For the last few years, my DNS server of choice (when I run my own) is PowerDNS. It is very simple to use, and the ability to run multiple “backends” makes it wonderfully configurable. My choice setup is PowerDNS running the MySQL backend. Of course the…

Read More “(Re-)Introducing PDNSOps” »

Code

Error: SQL1159 Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 9.7.0

This past weekend I spent way too much time with Jon while trying to get our new work machines setup. Normally most of the time is spent waiting for Visual Studio to install (seriously that thing takes forever), but not so this time. DB2 kept refusing to work and play well with others. Specifically the…

Read More “Error: SQL1159 Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 9.7.0” »

Database

Serendipity to WordPress – Changing table prefix

While this isn’t strictly part of the migration process from S9y to WordPress, I decided to take some advice I read on the net and change the prefix for WordPress tables.  Most use this feature for when they have to share a database, but the suggestions I read said to do it to help prevent…

Read More “Serendipity to WordPress – Changing table prefix” »

Database

DB2 LUW vs zOS: Selecting from nested subselect

SQL0104N An unexpected token “” was found following “”. Expected tokens may include: “CORRELATION NAME”. SQLSTATE=42601 This was the error that I got while attempting to execute a stored procedure under DB2 v8.1 for z/OS. Being quite confused about it, I googled for the answer. I didn’t find one, but I did find this google…

Read More “DB2 LUW vs zOS: Selecting from nested subselect” »

Database

In MySQL: x^y != x raised to the y

As the title states, the caret (^) is not used as an exponent in MySQL. I’m not certain what exactly it does (and couldn’t find any documentation after a quick search), and would love to find out what its purpose is. I ran into this problem today when I noticed that MySQL’s math results (using…

Read More “In MySQL: x^y != x raised to the y” »

Database

Posts navigation

1 2 Next

Copyright © 2022 Obviate.io

Powered by PressBook Premium theme