Getting Ready for VistaDB 5: Compatibility Changes

As with any major release of a product there are a few changes to how VistaDB works with other components.  Many things are not changing; our goal was to ensure that if you were using VistaDB 4, you could upgrade to VistaDB5 with a minimum of fuss.  In particular: .NET 2.0 SP1 and Later Supported:…

Details
vistadb

VistaDB 5 Preview 3 Now Ready to Rock

VistaDB 5.0 Preview 3 is here with more query performance improvements. It’s file-compatible with VistaDB 4 so this the build to try out with your existing applications to be sure you’re ready for 5.0 and find out how much the performance gains will help you out.

Details
Chart1

VistaDB 5.0 is 1000x Faster for Some Queries

Minutes to Milliseconds We just published a second preview release of VistaDB 5.0 that includes support for paging result sets using OFFSET and FETCH as is done in SQL Server 2012 and other databases. It also slashes the execution time of some queries from minutes to milliseconds. The release notes include comprehensive information on everything…

Details

VistaDB: Scaling to MSSQL with no Code Change

Well if you are reading this then I guess the world didn’t end and it’s safe for me to welcome you to the tidbit behind door number 21 in the Gibraltar Software advent calendar. Today we’re going to look at scaling up from VistaDB to MSSQL and scaling down from MSSQL to VistaDB. What? I…

Details

VistaDB and C#: On Windows and Pi

Welcome to your treat for day 17 of the Gibraltar Software Advent Calendar! Today I’m going to share with you one of the great “ah ha” moments from my Raspberry Pi talk. It comes when I show the audience that you can write software for the Pi, using all the tools that you use right…

Details

VistaDB – Connections Strings

Hello there, and welcome to your tasty treat behind door number 15 of the Gibraltar Software Advent Calendar! In today’s post we’re going to look at VistaDB connection strings. The VistaDB connection string is made up of a number of parts, just as an MSSQL connection string is, each part is separated by a semi-colon.…

Details

VistaDB: Running on Mono

Behind door number 10, on the Gibraltar Advent Calendar, is this little treat showing you how to run VistaDB on Mono. For this example, I’ll be using the Raspberry Pi, as it’s my new favourite little toy right now, but this technique will work on any Mono installation. So, first thing we’re going to want…

Details
Gibraltar Advent Calender – Day 5

VistaDB: Five Performance Tips

This “treat sized” post is the tasty morsel behind door number 5 of our Gibraltar Software Advent Calendar and so I wanted to give you 5 tips for VistaDB performance: Use connection pooling to aid performance in ASP.net applications. Use the Disconnected ADO.Net objects to improve performance over a network share. Pagesize has performance implications.…

Details

VistaDB: Deploying Your Database

Hello! This feature is the tasty treat behind door number 3 of our Gibraltar Software Advent Calendar and shows you how to deploy your VistaDB solution. By far the easiest way to get a VistaDB deployment done is via an XCopy deployment. Of course, despite the name, you don’t actually have to use XCopy to…

Details

Raspberry Pi at DDDNorth

I’m just back from DDDNorth, a great community conference held in the north of England, where I spoke on the Raspberry Pi. For ease, I’ve broken my talk down into three sets of slides, each covering a section of my talk. First, getting started… Setting uptheraspberrypiusingberryboot from Gibraltar Software Then connecting to the Pi from…

Details

Using C# and VistaDB on the Raspberry Pi

In this post, I thought I’d show you how to transfer your C# and SQL Server skills onto the Raspberry Pi. The Raspberry Pi is a credit card sized single-board computer developed in the UK by the Raspberry Pi Foundation with the intention of stimulating the teaching of basic computer science in schools. It’s great…

Details

VistaDB – Insert if Not Exists Performance

Last weekend I was lying in bed, waiting for my wife to get out of the shower, thinking about how I’d build an application that I had an idea for. It was an information collection and analysis application, where I’d be taking information, from various sources, collating the data then reporting on it. I realised…

Details