Database – ObidosTech Knowledge Base

Fixed: Maria DB – Row size too large (> 8126) – Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED

January 11, 2023

1 min read

When trying to import an SQL file with InnoDB, Maria DB users can see the following message as an error or warning:. SQL Error (1118): Row size too large (>…

ColdFusion Database Lucee MySQL Server Tomcat Windows

Fixed: Lucee page rendering taking 2-3 seconds every time

December 14, 2022

1 min read

In one of our latest Windows servers, the latest version of Lucee (5.3.10.97) with default configuration was showing an apparent slowness. Every page, whether it is a single line output…

Integration JavaScript JSON Lucee Node.JS Oracle PHP Server Technology Windows

Using Server Sent Events (SSE) with Session

March 13, 2020March 13, 2020

2 mins read

SSE or server sent events are a great choice for pushing data from server to the clients. The benefit of SSE over web-sockets is that unlike web-sockets SSE is a…

ColdFusion Database Lucee PHP Railo Server SQL Server

Join separate Date and Time fields to one field in MS SQL Server

July 31, 2017

1 min read

When you have date and time separate in two fields, it becomes difficult to have date operation like add in them. To have a correct solution, we need to join…

Database Oracle

Optimize Oracle Database

June 3, 2017June 6, 2017

1 min read

Overtime, the Oracle DB will become sluggish with the insert/update/deletes. So we need to optimize the DB so that the queries are faster. To optimize a single table, use the…

ColdFusion Database JSON Technology

How to Store and Retrieve FORM variables or Objects to DB using Railo/ColdFusion

September 28, 2016

2 mins read

If we need to store all the URL variables to the DB, say, for tracking the user, it is easy. We can use a varchar field to store this information…

Database MySQL

Mysql join and sum is doubling result

August 23, 2016August 23, 2016

1 min read

The way to get around this is to create inline views of your aggregates and join on the those results. SELECT R.title_id, R.revenue, R.cost, F.interest FROM (SELECT title_id, Sum(revenue) revenue,…

Database MySQL PHP Server

Fixing error with MySQL “Headers and client library minor version mismatch.”

August 18, 2016

1 min read

With PHP and MySQL, if the MySQL is upgraded you may end up with this error on every request to the database from PHP. This error means the MySQL library…

Category: Database