Newspapers and the Web

Newspapers are in trouble, everyone seems to think this. Most newspapers have seen circulation declines of their paper editions and the web doesn’t pay that well for advertising.

What to do? Lots of obvious ideas like charging monthly fees or having per article charges.

Subscriptions overlook the fact that many people don’t subscribe to newspapers, they buy them each day. Sometimes they buy different ones on different days or go a week without buying one at all.

Per article charges are far too expensive, sometimes as much as 1 cent per word for say a 250 word article costing $2.50. If the article is critical to your business it may be affordable (The FT and the Wall Street journal seem to be doing well in this line) but if it’s about a political crisis or the actions of the local council?

So my first idea on this:

Sell the web based newspaper as an digital artifact, not just a bundle of content or a website subscription.

Allow access to single editions of the newspaper on the internet.

Give away a code inside each paper copy of the newspaper which would be good for reading the articles in that edition online forever. Once you’ve got the code (say in the morning), you can enter it into the newspaper website and your account is then authorized to read the articles from that day’s edition on any device you own.

Maybe you could also buy the codes online without having to buy the paper edition, plus if you got a subscription the content would be authorized automatically. Don’t want a particular day? Don’t need to pay.

Sell blocks of days prepaid in advance for a marginal discount. Because it’s buying a bundle of days rather than a monthly access subscription you should be able to get a slightly higher price, especially since it’s more flexible.

Plus you could make more money by allowing people to buy codes to access previous days, even after the event. Want to read the newspapers from the last major election, buy it now for 2.50. (You could charge more for old editions obviously)

Whether this is the idea to save the newspaper industry or not, I think it will take a lot of clever thinking to solve the problems.

Posted in General | Leave a comment

Drawing all of the states

This is a brilliant video of Senator Al Franken of Minnesota drawing a map of the United States entirely freehand and  including all of the states.

YouTube Video

(via NGM)

Posted in General | Leave a comment

Good reasons to read Ars Technica

Fortunately, we were able to re-solder the USB connector back to the PCB and continue testing.

[Ars Technica]

How many websites would bother doing this, and more to the point how many websites have reviewers who could do this?

Posted in General | Leave a comment

SQLEditor 1.6

The SQLEditor 1.6 public beta has been available now for about 3 weeks and I’m getting more hopeful about a final candidate release.

SQLEditor 1.6 is required for Mac OS X 10.6 Snow Leopard support, but because major sections needed rewriting to get this compatibility, there are also improvements to the core of the application.

There is a brand new SQL parser which is based on ANTLR and a new, more extendible, export system. Plus there are lots of other improvements in both user interface and functionality.

Best of all, it’s going to be a free upgrade for existing SQLEditor customers.

The beta is currently at version 1.6b7 but 1.6b8 will probably be out very soon.

I hope that you like it.

:-)

Download
SQLEditor 1.6b7
(DMG file | 4.2MB)

Posted in Company News, SQLEditor | Leave a comment

Criticism

I just saw this comment while reading an article about David Letterman:

This article is poorly done. It uses sweeping generalizations, it is factually incorrect in several areas, and shows a general misunderstanding of television. …

I  enjoyed reading the article anyway, but should I have done?

Posted in General | Leave a comment

The Brothers Bloom?

I’m puzzled that this doesn’t seem to have a uk release date (or even a distributor as far as I can see)

The trailer looks great:

http://www.apple.com/trailers/summit/thebrothersbloom/

http://www.brothersbloom.com/

Posted in General | Leave a comment

SQLEditor 1.4.4 Released

SQLEditor 1.4.4 was just released on Tuesday, the main feature improvement is the support for compound foreign keys. I posted a bit about this before and the final version is pretty much the same as I described.

Unfortunately there were a couple of bugs that slipped through relating to clicking objects. :-(

These are going to be fixed in a point release that should appear soon.

The new version is available from the automatic update system or download here:


3.9MB dmg File
Change Log
Product Notes
Expires
21st January 2009
Posted in Company News, SQLEditor | Tagged , | Leave a comment

Wired UK first impressions

I picked up a copy of Wired UK yesterday and I started reading it this morning while I was eating my breakfast.

So far I’m impressed, it feels solid, there’s plenty of interesting looking stuff and I liked the infographics (which I spent some time interpreting). The pictorial on the 3d printer that uses regular paper was really clever too.

I hope to offer more thoughts on this once I’ve read more, but my first instinct is to subscribe for the year.

Which is good; because I was really hoping that it would be good, and it is.

Posted in General | Leave a comment

SQLEditor: Compound Foreign Keys

The newest version of SQLEditor (1.4.4b1) now has support for compound foreign keys. This is something that people have been asking about for a while now, so I’m pleased that it got included.

There are some things that may need to be improved, but I’m fairly happy with the first revision of this.

Diagram showing compound foreign key

Diagram showing compound foreign key

The compound foreign key object is a new table level object that you can add from the Object menu just like a field or index. Then you drag from the foreign key to the target table. Finally you use the inspector to create pairs of columns to link together.

When importing from a database SQLEditor will try to create field-to-field links on foreign keys with only 1 pair of columns unless you tell it otherwise. (There is a new preference to do this)

Support is fairly complete, SQL parsing, database import, database export and SQL export are all available so it should work fairly well. I think the only thing it doesn’t do is auto-create indexes, so you may need to do this by hand on referenced columns (for those databases that need this)

There is naturally a new inspector palette to go with the table object.

Compound foreign key inspector

Compound foreign key inspector

This allows you to add pairs of columns using the + button at the bottom. Choose your columns using the little popup menus.

The whole thing is completely new, so please send in your thoughts to the usual address.

Download SQLEditor 1.4.4b1

(or enable the “Check for beta versions” preference and then use the check for updates feature)

Posted in SQLEditor | Tagged , , , | Leave a comment

DRM?

DRM is stealing stories from the eyes of children.

Spotted recently while reading a forum
(which sadly doesn’t allow direct linking as far as I can see)

Posted in General | Leave a comment

Recently seen in a Reddit thread:

Upvoted for completely incomprehensible analogy.

Posted in General | Leave a comment

Recovery in Detroit

Interesting early signs of improvement in Detroit. People are buying and renovating the unoccupied and abandoned houses:

Mitch and Gina have already been approached by some Germans who want to build a giant two-story-tall beehive.

Posted in General | Leave a comment

Everything on YouTube unavailable

I ran into a problem in the last few days with YouTube. I would visit the site, but every video I tried to watch displayed the message “we’re sorry the video is no longer available”.

Other people seem to have noticed something like this too.

The answer, as found in the last message in the thread, is to update to the newest version of Flash player, which appears to fix the problem.

However it makes me ponder something: what changed in the latest version of Flash and why does YouTube not recommend this upgrade to users? (Ideally with a large and obvious message)

Posted in General | Leave a comment

No freshly squeezed orange juice?

I was in the supermarket the other day looking for juice, only to find that the regular own brand wasn’t available! A disaster that was only averted when I realized that they were carrying a new branded juice instead. But why?

I had no idea until I came across this article which describes the financial difficulties of SunJuice, which unfortunately now seems to be in Administration.

SunJuice apparently provided 50% of all uk own-label juice.

I guess the costs were rising, prices weren’t and they got pushed a bit too hard by the buyers.

:-(

Posted in General | Leave a comment

3g mobile internet limitations

SamKnows has an article on some limitations that exist for 3g mobile internet access. (using usb dongles).

The killer is the limit for total bandwidth, as low as sharing 6.75 Mbits/s between everyone connecting to a single base station.

I knew the situation couldn’t be the same as land line, but this is much less than I expected.

Posted in General | Leave a comment

Northern Lighthouse Board Lecture

I happened to attend a lecture today at the RSSA given by Roger Lockwood who the head of the Northern Lighthouse Board. The board manages and maintains lighthouses and other navigational aids around Scotland (and for various reasons the Isle or Man)

It was a brilliant lecture, the speaker was great and the topic was very interesting. It started with a discussion of existing lighthouses; then the switch to automation and the story of the last manned light house at Fair Isle South Lighthouse (only automated in 1998).

Interesting was the fact that they can run lighthouses on solar panels in Scotland with good reliability (although batteries were mentioned too of course for storing the power). Wind power has proved to be less effective, with the windmills tending to get damaged by bad weather. The panels also have no moving parts and require less maintenance.

Moving on to the importance of not relying solely on GPS and the importance of the lights and aids. This included some cautionary tales of vessels that have got into difficulty by assuming that the GPS was right and the beacons, buoys and light houses were wrong.

Then a discussion of the e-loran system which will give much better positioning information for vessels at sea, the progress made and the work still to do. (Apparently more base station beacons needed to improve coverage).

Some very interesting questions at the end including a discussion on jamming of GPS interfering with navigation (which is apparently seen as a real and serious problem), plus several cautionary tales about the importance of checking your navigation systems.

Posted in General | Leave a comment

Randall Munroe talk at Google

Randall Munroe (of xkcd) gave a talk at Google.


Posted in General | Leave a comment

Macbook Wheel (by the Onion)

The Onion on a new Mac

:-)

They got that Mac tradeshow look so perfectly too.

Posted in General | Leave a comment

SQLEditor 1.4.3b3

So, it’s coming up to the holidays, but there is time for another SQLEditor release.

1.4.3b3 (snappy numbering, yes?) is pretty much a bug fix release. I think that the index creation problems that were happening have now been fixed, plus better handling of when to create indexes. It should now correctly figure out if fields are indexed and shouldn’t now add duplicates (or worse attempt to add duplicates)

There is also the addition of the simulate mode for database export. This isn’t exactly new, because it’s been available in some development builds, but it has now appeared in a release version. Simulate mode runs the entire export as normal, except that instructions that alter the database aren’t actually sent to the database to be executed. The instructions are recorded though, so you can see what would have happened in the status window log view.

There is also a new feature which prevents fields and indexes being dropped (although it doesn’t prevent modification, use simulate if that’s what you want)

SQLEditor also now adds a line in the status window when an export fails complete with the instructions that were actually executed and the error that occurred. This information was always in the log, but it should be easier to see how SQLEditor has gone wrong (in the event that it does of course)

Finally some fixes for a few (hopefully unlikely) crashing bugs.

3.6MB dmg File

Change Log
Product Notes
Expires
21st January 2009

Posted in Company News, SQLEditor | Tagged | Leave a comment

iPhone Shuffle?

The iPhone Shuffle,
(Advert 1)

(Advert 2)

(Advert 3)

:-)

Plus the obligatory Wired.com article (a bit more serious though)

Posted in General | Leave a comment