Posts Tagged Database

Trailing comma in IEEEXplore BibTeX

Posted by on Friday, 28 September, 2012

As a frequent user of the IEEEXplore database to search for literature concerning wireless networking, I often export a citation to BibTeX for use in my papers.

One of the things which has puzzled me for a long time, is why the BibTeX exporter adds a trailing comma after the last field.

Read the rest of this entry »

NAS: Ubuntu Server on Intel ATOM

Posted by on Saturday, 12 February, 2011

Time to attach some storage to your home network! I used to have a web / samba server for over five years running Slackware at first but Ubuntu since version 4.04. Given the noise and energy consumption I got rid of the large server system and decided to go for a more energy-efficient solution: a NAS. Read the rest of this entry »

phpmyadmin on (K)Ubuntu 10.10 not working?

Posted by on Tuesday, 8 February, 2011

phpMyAdmin is just about the greatest tool if you want to manage your MySQL database. Installation is quite simple, but somewhere something went wrong somehow… Read the rest of this entry »

OMNeT++ and how to use it with a database

Posted by on Monday, 7 February, 2011

There are four things you’d like to do with a database when it comes to simulation:

  1. Read topology from database in stead of NED file
  2. Read omnetpp.ini config from database
  3. Write Vector output to database
  4. Write Scalar output to database

Read the rest of this entry »

PHP & MySQL – sorting / order by multiple columns

Posted by on Thursday, 30 December, 2010

Ok so I have a website with news entries. They look something like [id, year, month, day, newsitem]. Now, I want them to be listed in descending order (most recent first). A way to do this is to convert the [year,month,day] tuple into a php date() and then sort it using php’s sort() function. An alternative is to let MySQL do the sorting for you.
Read the rest of this entry »