Tag - SQLite

Sudoku Recursive Common Table Expression Solver

Recursive Common Table Expressions

In this blog post, we’ll look at a solving Sudoku using MySQL 8.0 recursive common table expression.
Vadim was recently having a little Saturday morning fun solving Sudoku using MySQL 8. The whole idea comes from SQLite, where Richard Hipp has come up with some outlandish recursive query examples — WITH clause.
The SQLite query:

Shell

WITH RECURSIVE
 input(sud) […]

Read more

ProxySQL Admin Interface Is Not Your Typical MySQL Server!

ProxySQL Admin

In this blog post, I’ll look at how ProxySQL Admin behaves in some unusual and unexpected ways from a MySQL perspective.
ProxySQL allows you to connect to its admin interface using the MySQL protocol and use familiar tools, like the MySQL command line client, to manage its configuration as a set of configuration tables. This […]

Read more