RikWare
...

RikMigrations 0.2 Released

Tuesday, 13 May 2008 18:08 by Richard Mason

There's a new release of RikMigrations available. This includes a lot of bug fixes from the original release and is the first since the development team expanded.

Big thanks to Andy Stewart in particular who has pushed the release out the door and is actively working on more improvements, particularly cleaning up my original messy code.

This also marks the official move of the codebase from CodePlex to Google Code. This change is mainly to get around problems with CodePlex's source control.

kick it on DotNetKicks.com

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

TimeSpanPicker released under BSD

Wednesday, 30 April 2008 22:49 by Richard Mason

A request via email has encouraged me to release the TimeSpanPicker control I blogged about a few years ago. The details are available at http://www.rikware.com/page/TimeSpanPicker.aspx but I've copied them in here for ease of reading: 

The TimeSpanPicker is a Windows Forms UpDown control for editing TimeSpan values. It is currently used in RikPVR (http://www.rikpvr.com/)

The control is provided, as is, under a BSD license (meaning it's free to use and alter in free or commercial projects). Any improvements will be greatly appreciated.

A Visual Studio 2008 solution (including binaries) containing the project is available here: TimeSpanPicker.zip (121.65 kb)

The project targets .NET 2.0 and should be simple to recompile in Visual Studio 2005.

The control supports input via keyboard, mouse wheel or via the up/down buttons. It is also theme aware.

kick it on DotNetKicks.com

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

RikMigrations - There was movement at the station

Friday, 28 March 2008 11:17 by Richard Mason

RikMigrations has started rolling again recently. It appears some posts on the alt.net mailing list prompted a few people to check it out and even better some have signed on to contribute as well. This prompted me to commit the changes I've made in the last few months (I'd been meaning to do it but had been lazy).

There's already the start of an msbuild task for RikMigrations and rumblings of a NANT one as well. Plus, a nice little tweak to use generics to define column types so you can do this:

t.AddColumn<int>("ID"); 

And there's also discussion starting around adding some ability to populate the database with initial values in migrations as well (https://www.codeplex.com/Thread/View.aspx?ProjectName=RikMigrations&ThreadId=24868)

PS. For the non-Australians out there the title refers to a famous Australian poem.

kick it on DotNetKicks.com

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

RikMigrations - Starting from an existing database

Thursday, 20 December 2007 11:44 by Richard Mason

RikMigrations includes support for generating an initial migration from an existing database. Currently this only supports SQL Server databases. The feature was included in the initial release, but hadn't had much testing. Since then I've tested it on a database at work and confirmed it's working correctly (at least to some extent). The migration generator attempts to ensure tables are created in the correct order, but this feature was hacked in and needs improving. In doesn't support circular dependencies so don't even try.

The generator only supports generating in C# at the moment, however it uses CodeDom so other support for other languages is simple to add and a quick hack of the code will provide a version for your favourite language. 

To generate a migration from a database use the following command line:

RikMigrations auto -s:(local) -db:Test -f:Migration.cs 

You can also add the "-sf" flag to write each table into a separate class, but make sure you include a "{0}" in the filename to indicate where to place the name of the table.

kick it on DotNetKicks.com

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

SQLite for RikMigrations

Tuesday, 27 November 2007 10:55 by Richard Mason

I've just added support for SQLite to RikMigrations. This was done mainly because I use SQLite to store data in RikPVR and I needed to expand the schema. I tossed up whether to go with the embedded sql scripts like I have been doing or put in the time to add support to RikMigrations so I could use it. Eventually I decided it would be worth the work of adding to RikMigrations, if only to test how well it would support alternate database providers.

As expected, I had to refactor the code to support the change - alternate database providers wasn't in the original RikMigrations design, though I had already started refactoring towards a provider pattern. However, the changes were actually fairly minimal. I encourage others to sign up and start adding support for other engines.

Unfortunately, SQLite is a bit limited in some areas so not all features are supported. The biggest one is probably the inability to drop columns. There are workarounds for this in SQLite which I may look in to, but for the moment it will just throw an exception. Other ones I've run into is that you don't seem to be able to add columns with PRIMARY KEY or UNIQUE constraints on them once the table is created, but they work fine if they're added during the initial table construction.

In other news I've added a couple of extra pages to the RikMigrations doco. I'll keep adding to that bit by bit but if you have any specific questions drop me a comment or an email.

Finally, here's a quick bit of code in the meantime to show how to use SQLite instead of SQL Server. (This is only for programmatic access, I haven't added the command line interface yet)

DbProvider.DefaultConnectionString = @"Data Source=D:/TestDB.db";
MigrationManager.UpgradeMax(typeof(Joe1).Assembly, typeof(SqliteProvider));

The actual migrations stay exactly the same, except you may run into the limitations I mentioned earlier. I'll try to document them somewhere.

kick it on DotNetKicks.com

 

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Announcing RikMigrations

Thursday, 22 November 2007 09:45 by Richard Mason

Over the last couple of weeks I've been working on a migrations framework for .NET called RikMigrations. There's a couple of existing frameworks but they're mostly integrated in other large projects like SubSonic or didn't quite fit my needs/wants.

RikMigrations is currently relatively small and simple, but I am releasing it under a BSD license on CodePlex so others can jump on board and build it up. Check out the project homepage at http://www.rikware.com/RikMigrations.html to find out more, including a simple tutorial demonstrating its use. 

kick it on DotNetKicks.com

Currently rated 4.0 by 3 people

  • Currently 4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Redirect domain names using UrlRewrite.NET

Tuesday, 30 October 2007 16:43 by admin

UrlRewriter.NET is a great tool for url rewriting in .NET. It can even be used to redirect domain names with.

e.g. RikPVR's main address is http://www.rikpvr.com/, but it can also be found at http://www.rikdvr.com/,http://rikdvr.com/ or http://rikpvr.com/ but ideally these should just redirect to the primary address. Using a host condition in UrlRewriter.NET makes this easy:


<if header="HOST" match="^((www.rikdvr.com)|(rikdvr.com)|(rikpvr.com))$">
<redirect name="RikDVR" url="^(.*)$" to="http://www.rikpvr.com$1" />
</if>

Currently rated 3.5 by 2 people

  • Currently 3.5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Categories:   General
Actions:   E-mail | Kick it! | del.icio.us | Permalink | Comments (0) | Comment RSSRSS comment feed

RikPVR 1.0 Released

Friday, 19 October 2007 12:28 by admin

RikPVR is now available to everyone. After a beta program including testers throughout Australia, the UK and Europe, RikPVR v1.0 has been released.

And to celebrate the release a special introductory price of $30 (Australian) is available till the end of November. This gives you enough time to download the free 30 day trial and still purchase RikPVR at a discounted price.

Head over to http://www.rikpvr.com/ to find out more.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Categories:   General
Actions:   E-mail | Kick it! | del.icio.us | Permalink | Comments (0) | Comment RSSRSS comment feed

Herbie Hancock on Wired

Monday, 1 October 2007 12:37 by admin

There's a great interview with Herbie Hancock out on Wired - http://blog.wired.com/music/2007/10/herbie-hancock-.html

Herbie is one of my favourite artists. I can't say I like all of his work, but I like a lot of it... and in many cases I like it a lot! I like looking at jazz legends and picking similarities between myself and then so I can keep deluding myself that one day I'll be able to play something like what I'd like to play (I'm a loooong way off that at the moment). In the case of Herbie I of course pick the fact that he did electrical engineering for awhile, and he obviously did it for a love of technology which led him to his later work as a synth pioneer.

Anyway, the interview's good. One point he makes which is very important for both mussos and tech people is this:

My advice is, don't depend on the technology. 
The music has nothing to do with the technology.
If you're doing music, the music has to come first.
And the technology is a tool for being able to produce
the things that you feel. Not the other way around

This holds for programming too. The point is the end result, not what language or platform you use to get there. Obviously you need to choose the best tools for the job, but ultimately the focus should be on what you're actually trying to do, not insisting on using your favourite tool, or the latest fad.

The other good one is something I've noticed in my own experiences too:

Interviewer: As a young child, you had serious talent 
in the classical area, and a passion for electronics early too,
later double-majoring in music and electrical engineering. My
dad is also a pianist, and he also almost went into engineering
at one point.

Herbie: (laughs) I think there's a relationship: math.
Particularly with jazz, but not necessarily only with jazz,
with classical music too. There's also a sense of exploration
that's involved with science and with music that links them together.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Categories:   General
Actions:   E-mail | Kick it! | del.icio.us | Permalink | Comments (0) | Comment RSSRSS comment feed

Identity 2.0

Tuesday, 18 September 2007 14:31 by admin

Here's a somewhat interesting presentation about identity and the web which I felt was worth the time to watch (it wasn't too long) - http://identity20.com/media/OSCON2005/

Well presented too!

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Categories:   General
Actions:   E-mail | Kick it! | del.icio.us | Permalink | Comments (0) | Comment RSSRSS comment feed