DBTreeView alternative?

[ngervasi]

I see but I'd still prefer to use the alternative one, for navigation purposes it's faster compared to the one based on foundsets (I guess all data is kept in memory and no query fired against the db). The default one has also some issue in webclient with the icons realoading too often.

[david]

tree.png (465.76 KiB) Viewed 10611 times

[ngervasi]

Very cool David!
What is that exactly?

[david]

Very cool David!
What is that exactly?

It's Servoy's web client going really really fast. And a lot of other cool things.

slickgrid-servoy.png (309.63 KiB) Viewed 10561 times

[ngervasi]

Very cool! Any more info you can share about it?

[Peter de Groot]

Wow, looks great.

[pbakker]

Hey, great work David.

How will you release this, as we've also planned to wrap SlickGrid into a module shortly.

Paul

[david]

Hey, great work David.

How will you release this, as we've also planned to wrap SlickGrid into a module shortly.

Thanks! Open to suggestions. We've tossed around the idea of trying something different and running it as a "Kickstarter" project:

1. Enterprise contributor, $2,000 (target: 5)

- access to project (wiki and forums)
- access to SVN (with commit privileges if Troy likes your code)
- voting on feature priorities
- help setting up styles/css for your frameworks/apps

2. Developer contributor, $500 (target: 10)

- access to project (wiki and forums)
- access to periodic builds (every 4-6 weeks)

Initial build out the gate will include implementations for:

• formatters
• CRUD methods
• validation methods
• example: million row grid (Servoy table)
• example: tree view

Of course, we should throw in the all important T-shirts for everyone!

In all seriousness, we'd be glad to MIT open source this project given a little bit of help. As we all know, there's a significant gap between developing something for internal use and something for everyone to use. In the end, it's easier for us to put that extra effort into something else and keep this as a Data Sutra customer feature unless convinced otherwise.

In the meantime, our clients are freaking out about this stuff and we're working furiously to get into production systems as fast as possible. As in...next week. I can confirm that this is absolutely the way to go if serious about web client.

[david]

Million rows in tree view with data type specific inline data entry:

[Harjo]

wow! Look at the performance of this: http://mleibman.github.io/SlickGrid/exa ... aview.html

That would give Servoy (webclient) a boost!!

[david]

Side note: the data broadcasting technique we came up with for this Slickgrid component can be used with any client-side component -- calendars, schedulers, gantt, Trello mashups, time keeping UI's, interactive "what-if" charts, shared controllers, etc. Takes some client-side coding skills to wire things up the first time but the end results sure beats creating these kinds of high level components with servoy design-time objects or solution model.

The technique hooks directly into Servoy's broadcast method and only sends changes (as JSON). End result is components stay in sync with non-client-side data and very lightweight on the network.

[david]

Troy and I just posted a demo of the Slickgrid component for Servoy. Covering Servoy IDE integration, amazing client-side performance, and some geek-mode on the magic sauce going on making it all work transparently to the developer:

http://www.youtube.com/watch?v=nBASQTuO ... VummJC7kpQ

[Harjo]

Looking very promising David & Troy!

[david]

Looking very promising David & Troy!

Thanks Harjo

If someone on the Europe side of the pond is available for testing tomorrow, I could use some quick testing help. We have a full app running all slickgrids on a server here in the U.S.—would like to look over your shoulder while you click around to see how it performs.

It's screaming here. In fact we're probably going to have to put in a click throttler for grids that load up servoy forms so the user doesn't get too far ahead of themselves.

skype: soltexdw

[david]

Servoy's tree bean restyled:

dbtreeview sutra style.png (327.74 KiB) Viewed 10058 times

Checkbox is all done with CSS and even has a cool "depressed" state. CSS for this trick (put in "../servoy-webclient/templates/default/servoy_web_client_default.css" file:

Code: Select all

table.wicket-tree-content table.icon-panel input[type=checkbox] {
   font-size: 16px;
   position: relative;
   border: 1px solid #262626;
   display: inline-block;
   margin-right: 5px;
   padding: 0;
   width: 14px;
   height: 14px;
   vertical-align: text-top;
   background: -webkit-linear-gradient(
      top, rgba(255,255,255,0.4), rgba(255,255,255,0.1)
   );
   -webkit-appearance: none;
   -webkit-box-shadow: 0 1px 0 rgba(255,255,255, 0.1),
      inset 0 0 1px rgba(255,255,255, 0.4);
   -webkit-border-radius: 3px;
}

table.wicket-tree-content table.icon-panel input[type=checkbox]:active {
   background: -webkit-linear-gradient(
      top, rgba(255,255,255,0.05), rgba(255,255,255,0.2)
   );
}

table.wicket-tree-content table.icon-panel input[type=checkbox]:checked::after {
   position: absolute;
   content: '';
   left: 15%;
   top: -10%;
   height: 35%;
   width: 90%;
   border-bottom: 2px solid #bbb;
   border-left: 2px solid #bbb;
   -webkit-box-shadow: -1px 1px 0 rgba(0,0,0,0.8);
   -webkit-transform: rotate(-45deg);
}

The images for open folder, closed folder, and file are our own creations and use the url rewrite technique (described here) to divert Servoy's default path for the tree graphics.

In other news, Sutra CMS is going completely web client....