Topic: Tell us about your project!

Hi Tuukka,

I started working on a project for a POS system based on BaseTen. To time the work is done by an Access Program which is really ugly. And since a started using Mac I wanted to change it, so I started to play around with Cocoa (but I’m still a new-be).
When a found your framework I know I was the only choice, because what could better fit in a POS System for a Sauna (PeltoBad) as a framework made in Suomi. :-)
But it’s still a lot of work to do, at the moment I’m learning the basics of PostgreSQL.
The plan is to be ready in at least 3 years. (I’m studing physiks besides) I hope I can persuade my father to let me buy your framework earlier. I think it’s really a pleasure to use I already build my first app with it (well, just a table view to edit and view a table).

sry for my english i know it’s not the best…

Greetings from Germany

Topic: Tell us about your project!

Like Tuukka mentioned, the reason DELETE operations cannot be undoed by BaseTen in autocommit mode is the fact that BaseTen has no information about what was deleted by ON DELETE CASCADE rules. I think it’s better to leave that stuff out than to claim that we do support undoing DELETE operations.

In manual commit mode (before the commit, ie. before the “save” message), the undo state is maintained by the database itself with CHECKPOINTs. Because of this, we can undo, or ROLLBACK to the previous savepoint, with the knowledge that everything about the database returns to the previous state. There is no way to implement this in the autocommit mode. (And, because of this, just sending save messages all the time is not a solution either.)

What I suggest you do is that on the delete operations in your application, you work directly with the NSUndoManager to record the events needed to reconstruct the deleted objects. This should be simple enough on a per-application basis, but much more difficult for us to solve generically.

Topic: Tell us about your project!

Creating and deleting rows should be undoable in manual commit mode. I don’t remember right now, if we have a test written for that, but it’s supposed to work. We’ll consider making at least creation undoable in the future. For deletion, it would probably be harder, if there are foreign keys or other things that have been created with ON DELETE CASCADE.

Topic: Tell us about your project!

Hi everyone,

I’d like to hear more about you and the projects you use BaseTen for. Please reply to this post and write a short description and whatnot. This way we can add functionality that might be needed in application development.