I've been playing with SQLNotes a little more seriously the past two weeks. I think this is going to be a very revolutionary program. I was never an Ecco user, so maybe that's why it feels so new and fresh to me, but even so, this program is going to be very powerful. As a notetaker, it's not really what you expect (at least I didn't), but once I understood how the program works, it really can function perfectly well as a notetaker. Furthermore, it could do tons of other things, but not in a Ultra Recall or Info Select sort of way where they just bundle a whole bunch of different features into one program. In SQLNotes, everything is essentially one database, and the user controls how the information is displayed. In other words, it allows you to create your own notetaking program just the way you want it. It's very powerful, very flexible, and unique (based on Ecco).
I'm excited about the program and it's official release (it's beta right now). Another great thing about it is the author is very nice, very active with it's development, and there's no danger of losing your data in the future because of a proprietary format, because all of the data can be exported to a general format (I don't know exactly what, but it's true).