iakttakelser (observations)

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", ...

Creating enterprise apps for iPhone and iPad isn't trivial. In @iFacturas we used 21 months to get out the current version. Now I'm diving into enterprise programming myself, in order to find a better way to do it.  If you know me, you also know I'm loving accounting, specially accounting program design. In many years, there has been two important parts of accounting programs, entering data and reports. Entering data has to do with database and database view programming. Reports with the same database and presenting reports, normally on PDF. I've just finished a roundtrip on database and PDF programming, and have documented the process and the source here in 6 blogposts: I may have found the golden egg in #iOS database programming! It's @sensiblecocoa I've earlier told you about that programming iPhone isn't that hard. That was only partly true however. For database programming in iPhon... Update: Hands-on with @sensibleCocoa #...

I've got the "Sensible Tableview" installed. I've passed the videos one more time, and now I'm hands-on. Yesterday I tried a small project with some accounting database stuff. But ran into endless problems. So I decided to follow the Core Data video instead, trying to undersand the sensible way . The video however is showing a XCode 3 project, so there are some small differences. And as "the devil is in the details" it is also present here, and I tumbled. But finally I got it right.  XCode4 has a navigation project template with an example database application that runs out of the box. There isn't any editing posibility however. But by adding a bit of @sensibleCocoa magic, you suddenly get it! Update: Somehow I discovered that the project didn't save. From the @sensibleCocoa forum I got immediately an answer that solved the problem. I just had to add the following line to the  applicationDidEnterBackground method in the navTestAppDelegate...

I've earlier told you about that programming iPhone isn't that hard. That was only partly true however. For database programming in iPhone is extremly complex. I've spent weeks trying to build a xcode template letting me have it my way, just to stumble, fall, hurt me, sweat and cry. Instead I got a flu, and had to remember my main objective, which was to make accounting programming in iOS, and to see if a template or framework was the right solution. So curing my flu, I starte feverishly (no pun intenteded;) to look for templates and frameworks or people doing these things that could help me.  I added new tabs for ORM, Objective-C, SQLite on Flipboard and Zite, and after endless flips I finally found something: @giminete in Zaragoza seemed the most interesting. But then on Thursday I discovered the " Sensible Cocoa " tableview framework. They promise to build a database app on 5 minutes!  Oh what a joy. I've been through the videos, a bit into the forums...

I have a soft point and that's databases. So when something coming up for iOS. Wow, I have to check! A post from The Unofficial Apple Weblog (TUAW) by Kelly Hodgkins has the whole story . Here is a part: FileMaker announced the availability of  three new Starter Solutions  for its FileMaker Go mobile application. FileMaker Go lets you access and edit your FileMaker databases on your iPhone, iPad or iPod touch while away from your desktop. The three Starter Solutions are optimized for Apple's multi-touch mobile devices and include: Contacts: Organize and search your contacts. Documents: Work on documents remotely and synchronize any changes to a master database. Assets: Track all types of assets and create custom categories, such as serial numbers, purchase dates, depreciation calculations and more. The Starter Solutions can be edited on your mobile device and your Mac or Windows computer. Mobile usage requires the FileMaker Go application, which is available from iTu...

When @Gruber point, it's wise to look! And since I'm evalutating if we should use SQL lite to make iFacturas work offline, it was really relevant. After a view, I downloaded it from Mac App Store. That store let you spend money pretty fast! A post from Daring Fireball by John Gruber has the original story .

iFacturas is based on a vocabulary. It will be published in our API later this year. A post from from OData Blog has the whole story . Here is a part: What are vocabularies? Vocabularies are made up of a set of related 'terms' which when used can express some idea or concept. They allow producers to teach consumers richer ways to interpret and handle data. Vocabularies can range in complexity from simple to complex. A simple vocabulary might tell a consumer which property to use as an entity's title when displaying it in a form, whereas a more complex vocabulary might tell someone how to convert an OData person entity into a vCard entry. Here are some simple examples: This property should be used as the Title of this entity This property has a range of acceptable values (e.g. 1 to 100) This entity can be converted into an vCard This entity is a foaf:Person This navigation property is essentially a 'foaf:Knows [a person]' relationship This property...

Here is the guide in Engligh. An Norwegian version was provided here . A post from The ProPublica Nerd Blog has the whole story . Here is a part: Our  Dollars for Docs news application  lets readers search pharmaceutical company payments to doctors. We’ve written a series of how-to guides explaining how we collected the data. Most of the techniques are within the ability of the moderately experienced programmer. The most  difficult-to-scrape site  was actually a previous  Adobe Flash incarnation of Eli Lilly’s disclosure site. Lilly has since released  their data in PDF format . These recipes may be most helpful to journalists who are trying to learn programming and already know the basics. If you’re already an experienced programmer, you might learn about a new library or tool you haven’t tried yet. If you are a complete novice and have no short-term plan to learn how to code, it may still be worth your time to find out about what it takes to gather d...

A post from ReadWriteWeb by Klint Finley has the whole story . Here is a part:   RedMonk  analyst Stephen O'Grady tackles the question " What Factors Justify the Use of Apache Hadoop? " O'Grady cites two of the most common criticisms of Hadoop: 1) Most users don't actually need to analyze big data 2) MapReduce is more complex than SQL. O'Grady confirms these criticisms, but finds Hadoop useful anyway. O'Grady acknowledges that volume isn't the only factor in the complexity of a dataset. "Larger dataset sizes present unique computational challenges," writes Grady. "But the structure, workload, accessibility and even location of the data may prove equally challenging."

No Excuse Accounting logo has three elements: the sircle which represent the context, the (data)grid which represent the ledger, and finally the cloud representing both internet and the tag cloud. As I´m heavy into accounting, the datagrid is my preferred control. Infact t is one of the three element of my company´s logo. So this article  from the Silverlight Show is really good news!

Houston is the first dev tools for the # Azure on the web. "We are all in it now," said Steve Balmer in January when he released #Azure, MS new operating system for the cloud. Much unlike the normal hostile attitude to competing platforms, he welcomed alternate technologies like Apple , PHP and Wordpress to their cloud. Yesterday we could get a better glimpse of our future: MS released Houston, a SQL Azure  management tool to create, edit and maintain their cloud database in Silverlight . In the web, free from Windows. Believe me, MS will release Silverlight version of their whole programming tools and programming enviroment during the years to come. And why is MS doing this? Because the OS's are dying and curated enviroments like iOS and Android will take over. And MS will be asure to serve them all - with Azure ;) Other thoughts?

NoSQL Database CouchDB Turns 1.0 : " The post-relational document database CouchDB reached its milestone 1.0 release today. Couchio , the corporate sponsor of the free open-source project, boasts that speeds in the new release are up 300% over version 0.11.0. In addition to the speed increase, Couchio cites the following new features: Microsoft Windows support Authentication system - write CouchApps without having to create a user model Replicator options - flexibility to use replication to build custom systems The authentication system, which will make development easier, is probably the most significant of these features. We covered the NoSQL last year in our article Is the Relational Database Doomed? Certain web applications, such as web based instant messaging, have scalability needs that push the limits of existing SQL solutions, so NoSQL solutions like CouchDB have emerged. CouchDB has powered the web based IM client Meebo since 2008, according to Couchio. According t...

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, a...

Crugman has been working on this problem the last weeks. Today he came up with, as he says himself, a sort of a textbook. You should read the whole article  here . "Most press coverage of the eurozone troubles has focused on Greece, which is understandable: Greece is up against the wall to a greater extent than anyone else. But the Greek economy is also very small; in economic terms the heart of the crisis is in Spain, which is much bigger. And as I’ve tried to point out in a number of posts, Spain’s troubles are not, despite what you may have read, the result of fiscal irresponsibility. Instead, they reflect “asymmetric shocks” within the eurozone, which were always known to be a problem, but have turned out to be an even worse problem than the euroskeptics feared. So I thought it might be useful to lay out, in a handful of pictures, how Spain got into its current state. (All of the data come from the IMF World Economic Outlook Database). There’s a kind of classic simplicity a...

In my opinion, any silverlight business application must have following features: Separate tiers (middle, client) and data transfer between them; Access to data tier (database); Authentication; Data transfer between tiers via secure connection. .Net Ria Services and .Net Ria Services Class Library allow to implement all features above. Demo application has all mentioned features and can be use as a skeleton for all other silverlight business applications. CodeProject: Skeleton for a Silverlight business application based on Ria Services and the Ria Services Class Library. Free source code and programming help

Computerworld har et whitepaper om kolonneorientert databasesystem. De mener denne databasen kan være en løsning på det enormt økende lagringsbehovet for statistikkgrunnlag.

Digi skriver: "– Å lære seg og å ta i bruk disse forskjellige programmeringsspråkene og -grensesnittene er en avskrekkende oppgave, fordi de semantiske forskjellene mellom relasjonsdata-programmering og objektorientert programmering er enorm. For eksempel har de to verdenene forskjellige typesystemer, forskjellige innebygde datatyper og forskjellige standardfunksjoner. I tillegg er det bare den relasjonsbaserte verdenen som støtter spørringer, forklarer Hejlsberg." MS har flg. LINQ-side . Kilde: digi.no

digi.no - Visma oppgraderer sin Mamut-konkurrent Avendo har på halvannet år skaffet seg 2000 kunder i Norge og Visma har nok høye forventninger til den norske satsningen. For i Sverige har Visma hele 150.000 småbedrifter som kunder. I motsetning til Mamut, som bruker dBase formatet til Foxpro, benytter Visma Microsoft sin MSDE database.

digi.no - Mamut må justere etter Microsoft-utsettelse Digi skriver videre: En av teknologiene Microsoft tok ut av Longhorn for å få lansert i 2006 var WinFS, det nye filsystemet. Dermed forsinkes også ”Project Green” som var avhengig av WinFS. Project Green kalles også "Microsoft Business Framework". Meningen er å skape en felles kodebase/server-plattform fordi applikasjoner som økonomisystem, CRM, lønn, personale og logistikk inneholder så mye av de samme tingene. Project Green skulle også bli grunnmuren til fremtidig ERP-programvare fra andre utviklere, deriblant norske Mamut. - Vi var forberedt på at Project Green og MBS kunne bli forsinket og hadde ikke gjort oss avhengig at dette skulle lanseres på et gitt tidspunkt, forteller Mamut-sjef Eilert Hanoa til digi.no. Visma, den andre av de store norske ERP-leverandørene, smiler. - Utsettelsen er en god nyhet for oss, det reduserer det teknologiske og markedsmessige presset fra Microsoft, sier Visma-s...

digi.no - Nye verktøy lar alle lage programvare