General Ledger 21 for SQL Azure updated on Codeplex

Av
GL21Azure, formerly GL21, is my pet project. It really covers a lot of my 28 years experience with accounting, databases and IT. The cool thing is that the baby runs on SQL Azure, Microsoft virtual SQL servers on their monster container servers.
Now and then, GL21Azure have to be updated. We are now in the last phase of finishing an iPhone client for the invoice part of GL21Azure. During the last half year, small changes did make the core proc, addAccountBook.sql, not so convenient as it should, and a bit dull. Well, the last week I updated it, cleaned it and added functionality, so it now can process both journals, accountbook entries and specfications, with versioning, and it evens updates the tagCloud directly.
I order to prove this, I updated the testGL21NO.sql test with all these different way of handling accounting entries.
I´m really happy with it, and I´m confident it will serve the BizSpark Startup "no excuse accounting as" new iPhone application as a champ, and let the app shine :D

Populære innlegg fra denne bloggen

Predicates in Core Data

Av
Database programming is all about filtering and sorting tables linked to each other. According to the book Core Data , «Core Data is Apple’s object graph management and persistency framework for iOS, OS X, watchOS, and tvOS.» In a sense, predicates are an object version of the WHERE clause in SQL. Just like NSFetchRequest represent the FROM clause in SQL. I never have had problems with WHERE and FROM in SQL, but the predicate format strings in Core Data has been quite a struggle for me. I don’t think the struggle is only my fault. Predicates should clearly be thought, at least to me, as a method of writing WHERE clauses. Here is some notes from tutplus’ Core Data and Swift: Relationships and More Fetching : let predicate = NSPredicate(format: "%K == %@", "last", "Doe") The predicate format string uses %K (K stands for Key) for the property name and %@ for the value. let predicate = NSPredicate(format: "%K >= %i", ...
More...

How To Disable Google’s Personalization Of Search Results

Av
Bilde
Do you want to know what the rest of the world gets as answer for their search, instead of what Google thinks you may want to see? I do, therefore the post from MakeUseOf.com by Ann Smarty did catch my interest. She explains it well, both for one-time use and how to change your firefox and chrome browser, and I just copy the one-time part: 2. Disable Google Personalization: One-Time (Browser Independent) Again, you may like the feature and the fact that Google tries to show you what you really want (your favorite sites or sites you are more likely to like on top), but in some cases you will want to see “real” results (for example, to check how your own website is doing). In this case, what you need to do is manually modify the search query URL path: just add this parameter: pws=0 The ‘pws=0′ parameter removes the search personalization: If you don’t want to add the parameter manually, use this browser bookmarklet (courtesy of  Google System Blog ): Turn off Google perso...
More...

InvestorForum by VentureLab in Oslo a success story #startups

Av
Bilde
Photo from Hotel Continental website 200 persons, mostly investors, joined to see what 20 startups could offer in Oslo after the finance crisis . I was astonished to see so many foreign investors, from US and from UK. There was in my opinion a lot of great projects . Since I also presented, I could only follow some: Yes Game : They have ingenuos  reduced the chess board from 8X8 to 5X6 by taking away all second officers. In that way they have create a Chess Attack, which can take you into the final stage of a chess party immediately. They have it for iPhone and very important, also as a physical board. uformia created software very well suited for 3D printing. The CEO Cherie Stamm was an American living in Norway. She softened every Norwegian heart when the said the reason was our beautiful nature. 3D Printing is in my opinion a possibility for the Western society to rebuild the manufacturing industry we lost to China. kikora presented a math editor, which evalua...
More...