Posted on

Exploring Shift-Symmetry in Two-Dimensional CAs

To better explain the enumeration and probability calculation part of our paper “Shift-Symmetric Configurations in Two-Dimensional Cellular Automata: Irreversibility, Insolvability, and Enumeration,” which is currently under preparation (preprint available here), I’ve created a little supplementary web page and added it to COEL project as a new Symmetry section:

https://coel-sim.org/symmetry

It’s freely accessible so go ahead and give it a try!

Posted on

Collaboration with GridGain

Thanks to a GridGain academic licence the COEL framework enjoyes a scalable zero-deployment computational grid, which flawlessly fits to our Spring-backed IoC container. The grid can employ up to 512 cores to run mainly chemical simulations, dynamics analyses, and evolutionary optimizations of rate constants.
In Sept ’13 GridGain and PSU released a short press statement (260 pick-ups) describing our colaboration:
prnewswire.com, bio-medicine.org, hpcwire.com

Posted on

MySQL Create DB Script with Linux Variables

Recently I was trying to set up a MySQL database for one of my projects. The major difficulty I’ve faced is that MySQL apparantly does not provide any support for Linux (user-defined) variables… or maybe I’m just lame since I was not able to find that. So after I’ve spent a couple of hours browsing and cursing, I decided to write a bash script that parses a given SQL file, replaces (evaluates) all ${..} ocurrences with the values of Linux variables, and finally runs the adjusted SQL.

It worked well on Ubuntu 11.10 with MySQL 5.1.63.

If you want to use it replace the assigments of all DB variables such as DB_HOST and DB_USER in the following bash script (create_DB.sh) with your own setting.

#!/bin/bash

# The name of the script
SCRIPT_NAME=create_DB.sql

# Variables
DB_HOST=localhost
DB_PORT=3306
DB_ADMIN=root
DB_USER=dbadmin
DB_USER_PASSWORD=xxxx
DB_NAME=db

# Collect variables and substitute
for var in `grep -o "\\$*{\([^{]*\)}" $SCRIPT_NAME`
do
val=`eval echo ${var}`
vars+=("-e s/$var/$val/g")
done

# Run the SQL script
sed "${vars[@]}" $SCRIPT_NAME | sudo -u $DB_ADMIN mysql -v -p -h $DB_HOST -P $DB_PORT

Here is the referenced MySQL script (create_DB.sql):

-- CREATE USER
CREATE USER '${DB_USER}'@'%' IDENTIFIED BY '${DB_USER_PASSWORD}';</code>

-- CREATE DB
CREATE DATABASE IF NOT EXISTS ${DB_NAME} CHARACTER SET utf8;

-- GRANT PRIVILEDGES
GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '${DB_USER}'@'%' WITH GRANT OPTION;

eNjOY!