Reflections // Images And Words

Here is a work-around for the insufficiently-functioning Mendeley bibtex export for web page/URL citations. The issue is that a) the URL is exported as ‘url =’ and not ‘howpublished =’ and b) there is no ‘last accessed’ (aka ‘last viewed’ or ‘last checked’) field…

This little workflow and command line might help someone.

• Continue reading or Leave a comment...

Yesterday, somebody asked me how much traffic a Shotcast server produces. And I though I might as well share the computation:

Stream @ 128 kbps (Kilo Bit per second) on in average 30 days of a month
n = average number of users that listen 24h per day
s = 1.1 = Shoutcast overhead factor (10%)

So to calculate the traffic in Terabyte:

(((128 / 8) * 60 * 60 * 24 * 30) * n * s) / 1024 / 1024 / 1024

Examples:

n = 10
((((128 / 8) * 60 * 60 * 24 * 30) * 10) * 1.1) / 1024 / 1024 / 1024 = 0.42 TB = 420 GB

n = 50
((((128 / 8) * 60 * 60 * 24 * 30) * 50) * 1.1) / 1024 / 1024 / 1024 = 2.12 TB

The amount of traffic rises linearly with each additional user. So operators: plan ahead!

• Leave a comment...

After looking around for a while, here is a little recipe to efficiently drop all tables from a MySQL database.

Background story: If you have sufficient access rights to the MySQL server, you could easily drop database dbname; and create database dbname;

If circumstances don’t allow you to drop and create this way, here are two ways on how you could do it from the (Gnu/Linux) shell:

$ mysql -u<dbuser> -p<dbpass> -e “show tables” -N <dbname> | sed -e “s/.*/DROP TABLE IF EXISTS \`&\`;/” | mysql -u<dbuser> -p<dbpass> <dbname>

or

$ mysqldump -u<dbuser> -p<dbpass> –no-data –add-drop-table <dbname> | grep ^DROP | mysql -u<dbuser> -p<dbpass> <dbname>

Of course, you have to replace the following:

<dbuser>: Database user; e.g. “testuser” (without the quotes)
<dbpass>: Database password; e.g. “test1ng” (without the quotes)
<dbname>: Database name; e.g. “testdatabase” (without the quotes)

Cheers!

PS: [Compiled from post and comments under http://edwardawebb.com/linux/drop-tables-mysql-database-deletion]

• Leave a comment...

Soo…I move this from a former page to a post.

At some point last year, I needed a solution for a problem in LaTeX, where I wanted to continue an enumeration over several paragraphs.

Read on and find out how I did it.

Cheers!

• Continue reading or Leave a comment...