You know you can draw an identifying and a non-identifying relationship by clicking the buttons on the menu bar. And they come with some default values for other attributes (child cardinality, parent optionality, child optionality, etc) of the relationship. You had to edit the relationship and did a few more clicks before you could make it right.
But now with the speed relationship buttons, you can choose exactly what you want your relationship to be before forming one. Doesn’t it sound prefect to anyone that is really into relationships? 
Try it out: click on the little drop-down beside the relationship you want, and explore along until you pick all the values. Then drag from the parent entity to the child. The relationship will form with the precise attributes you want.
If you want to make a new relationship with exactly the same attributes (usually out of your design pattern), just click on the big button face (as you would usually do before) and the new relationship values will follow the old ones.
Who is the relationship guru on earth? You bet!
karl New Features free-plan, paid-subscription, relationships, sb-designer
It’s been about a year since our first launch of SB and we think it’s about time to align our pricing and plan structure to better serve both our free and paying customers.
In our new pricing structure, we try to open the essential features for free while adding values to paying customers. Some major difference between free and paid plans are:
Public/ Private Projects
A public project allows public users to open and read your projects while a private project allows its owner to grant read, write and/or administrative access to named users.
A paid subscription allows a certain number of private projects and unlimited public projects; while a free plan can create unlimited public projects but no private projects.
So if you are doing open source projects or anything that you are happy to share your projects with the public, free plan is definitely the one to pick.
SQL Alter Scripts
SB allows storing your database schema into the version repository for future retrieval. With paid subscription, you can generate SQL Alter scripts to migrate your database from one version to another.
Reverse Engineering
Reverse-engineering the schema from your database requires quite a lot of system resources and we’ve decided to put a quota (5 times per week) to the free plan.
All Brand New 7-Day Pass
If you want to test-drive our paid subscription but think one month is still too much to pay, you now can try our brand-new 7-day pass. It gives you features of the Micro Plan for 7 days. It costs only $3!
As usual, let us know your feedback on how to make SB better!
karl Announcement free-plan, paid-subscription, pricing
This is the second most wanted feature on our wish list. You can now export your ERD diagrams into PNG image format. The image should be precisely like what you see on screen, including the theme chosen.
This feature is available to all users with paid subscriptions. From the menu bar, click on File > Export as PNG Image. A link will show up on the right hand side once the image is ready for download.
karl New Features paid-subscription, printing, sb-designer
You may have noticed by now that each of your projects can be accessed by an unique URL. The URL is short enough for you to pass it around in twitter. The format is:
http://schemabank.com/a/the-unique-id-of-your-project
Accessing a Branch
You can also specify the branch and even the version of the schema you want to access. This will open the head version (i.e. the latest version) of the trunk branch:
Accessing a Version
And this will open version 2 of the trunk branch:
With the unique URL and the ability to share your projects for public access, people on the ‘net can locate your projects more easily.
karl New Features collaborate, free-plan, paid-subscription
You may sometimes run into a state where SB has loaded half-way to complete: you see all application controls, buttons, menu but with an empty ERD pane.
That’s confusing at the least, and dangerous at worst; because SB is trying to load all your project content. If you do something unexpected at that particular state, it could hurt your project.
But with the new bootstrapping method, you won’t get into that state anymore. We have made a window showing you the exact loading progress. And you will see the application interface only after a full load.
karl New Features free-plan, paid-subscription, sb-designer
We know this is a long-awaited feature. But it took much more time than we expected to get it right on all supported browsers. You can now move
- any part of the relationship lines
- the label of a relationship name
- the position of an entity while keeping the relative position of the line connector
You will also notice when you resize an entity window, the size will be remembered correctly.
karl New Features free-plan, relationships, sb-designer
For some users, they might experience problems when reverse-engineer their database dump that contains non-Western European characters. We have tweaked the import window so that you can specify the code page of the file you gonna import into SB.
Take the default code page (Western Windows 1252) if you are sure the file contains only Western Latin characters, or pick one from the list.
ありがとうございました !
karl New Features free-plan, paid-subscription, rev-engineering, sb-designer
You may not know that SB works offline most of the time.
By saying ‘offline’, I mean when it’s not communicating with our servers. After loading all project content, SB doesn’t have much server-side interactions^.
The beauty of this design is if you hit on a connection problem to the Internet, you can keep on working and save your design once the connection resumes.
When SB experiences a connection problem with our servers, it will show you this warning:
This is to calm you down and assure you that you can save your work once you get back the connection. You will also see a little warning message on the right hand side of the top info bar that you can click on to check if the connection has resumed.
^Other major server-side operations include saving project, committing a version, generating alter scripts, diff reports, etc.
karl New Features
We’ve added right-click access shortcuts to several SB functions:
Entity
Relationship
Version Manager
karl New Features free-plan, relationships, sb-designer
Reckoning the existing ERD canvas is not enough for some heavy-duty design work, we have enlarge the ERD pane to 3,000 x 3,000 px. Now you can create or reverse-engineer more and more tables and relationship in SB. [Added Oct-14: What? 3,000 x 3,000 is still too small? Try this...]
When you do reverse engineering, you will notice the imported entities will be placed precisely where it was as in the previous stored version of the schema. So you don’t need to re-order your objects again afterwards.
karl New Features free-plan, paid-subscription, rev-engineering, sb-designer
Subscribe by RSS