Categories
Tools

subverted git?

Ever wanted to use SVN to grab code from GitHub? Well, now you can, and just like that GitHub is the world’s biggest Subversion host. Here’s a few things you might like to do with it:

via Announcing SVN Support.

oh, cool, thank you. Works for me.

svn checkout http://svn.github.com/schacon/simplegit.git

Categories
MySQL Tools

restoring a single table from mysqldump

Following Restore one table from an ALL database dump and Restore a Single Table From mysqldump, I would like to add my own thoughts and comments on the subject.I also wish to note performance issues with the two suggested solutions, and offer improvements.

via On restoring a single table from mysqldump | code.openark.org.


face@mac:V:150 $ sed -n “/^– Table structure for table `mx_categories`/,/^– Table structure for table/p” wordpress_2009-12-02_02h15m.Wednesday.sql
— Table structure for table `mx_categories`

DROP TABLE IF EXISTS `mx_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mx_categories` (
`cat_ID` int(4) NOT NULL AUTO_INCREMENT,
`cat_name` varchar(55) NOT NULL DEFAULT ”,
`category_nicename` varchar(200) NOT NULL DEFAULT ”,
`category_description` text NOT NULL,
`category_parent` int(4) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`cat_ID`),
UNIQUE KEY `cat_name` (`cat_name`),
KEY `category_nicename` (`category_nicename`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


— Dumping data for table `mx_categories`

LOCK TABLES `mx_categories` WRITE;
/*!40000 ALTER TABLE `mx_categories` DISABLE KEYS */;
INSERT INTO `mx_categories` VALUES (1,’General’,’general’,”,0),(2,’Unix Notes’,’unix-notes’,”,0),(3,’AppleScript Notes’,’applescript-notes’,”,0),(4,’Misc Notes’,’misc-notes’,”,0),(5,’System Software Notes’,’system-software-notes’,”,0),(6,’Applications Notes’,’applications-notes’,”,0),(7,’Web Serving’,’web-serving’,”,0),(8,’Utilities Notes’,’utilities-notes’,”,0);
/*!40000 ALTER TABLE `mx_categories` ENABLE KEYS */;
UNLOCK TABLES;


— Table structure for table `mx_commentmeta`

Categories
Tools

Welcome to the SICP Web Site

This site is a companion to the influential computer-science text Structure and Interpretation of Computer Programs, by Abelson, Sussman, and Sussman. Its purpose is to demonstrate the Web’s potential to be a channel for innovative support for textbook users.

The material on this site is aimed at instructors using SICP as a course text, and at people using the book for self-study.

via Welcome to the SICP Web Site.

Video lecture

Categories
Tools

CSS Font Size Conversion Chart

For those of you who are still using pixels, it’s about time you made the switch to ems or points.  It allows users who have a hard time reading small type to enlarge the font.  Here is a little trick that will help you so you don’t have to remember the chart above.

body { font-size: 62.5% }

This will make 1.0 em the same as 10px.  So if you wanted 12 px. would be 1.2em, nice and easy.  Hopefully this will help you out, I know I use it all the time.  Enjoy.

via CSS Font Size Conversion Chart.

Categories
Practice Tools

Mobile Usability

Mobile use is one of the biggest challenges now facing many websites. Its also important for some intranets, particularly in companies with many traveling employees.

via Mobile Usability Jakob Nielsens Alertbox.

The challenge has been around since the PalmPilot + application specific tools.

I suspect the success rate for doing “phone” tasks or “address book” tasks is much higher than the “web” tasks.

A custom application (which is all that a “Mobile Site” is, really) is going to provide a better experience.

Simple example? Google Maps – can’t use it on a “mobile” browser. The custom application for my phone works quite well.

Categories
Forward Directions MySQL Tools

MySQL Enterprise for Amazon EC2

MySQL :: MySQL Enterprise for Amazon EC2:

Amazon EC2 is a web service that allows organizations to right size their computing capacity on demand using Amazon’s proven computing environment. Using MySQL Enterprise for Amazon EC2, developers can cost-effectively deliver web-scale database applications in the “cloud”, fully backed by the database experts at MySQL. Amazon EC2 and MySQL are a great fit for organizations that want to reduce the capital expenditures and operating costs required to build out and run their IT infrastructure. The benefits of MySQL Enterprise for Amazon for EC2 include:

Categories
Data Warehouse Forward Directions Tools

Gartner's Don Feinberg on Database as a Service and Cloud DBs

IntelligentEnterprise : Q&A With Gartner’s Don Feinberg on Database as a Service and Cloud DBs (printable version):

Microsoft, IBM, Oracle and Sun are now fueling the growing fire around the database-as-a-service and cloud database markets, but what’s the difference between these offerings and what’s the appeal? Database guru Don Feinberg defines terms and raises important questions about reliability and security.

Categories
Miscellaneous Tools

How to Kill Your Book Sales

How to Kill Your Book Sales | Carsten’s Random Ramblings

I believe the first time I heard about using publically-available Flightstats database for teaching databases was when Jeremy Cole suggested using it in the MySQL training program to demonstrate working with large data sets. I’m not sure it ever got used for that purpose, but others have followed up on the same idea in other contexts. The Flightstats database contains 10 years of US airline flight information, consisting of several Gigabytes of data in a fairly wide table, and so is excellent for talking about optimizations and search strategies.

The article is about book sales, but it really talks about sample databases for demonstration purposes.

Categories
MySQL Tools

For a given value of natively

For a given value of “natively”… | Carsten’s Random Ramblings

A quick (but somewhat simplistic) way to test performance of different methodologies is to turn off the query cache and use the BENCHMARK function. BENCHMARK loops over an expression a given number of times, and always returns 0, which is in itself quite uninteresting. But we can then look at the execution time to see how long things took.

I love it when the verbose expressions turn out wicked fast.

Categories
Data Warehouse Tools

Should You Use An ETL Tool?

IntelligentEnterprise : Kimball University: Should You Use An ETL Tool?

You can still hand-code an extract, transform and load system, but in most cases the self-documentation, structured development path and extensibility of an ETL tool is well worth the cost. Here’s a close look at the pros and cons of buying rather than building.