Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Using an XSLT scheme for this is legitimate. XSLT's are powerful if you develop the expertise. </p> <ul> <li><em>Overhead</em>: Yes, for large documents, a transform can take some seconds. Do a transformation on a large document called many times a minute can be a bad strategy. That won't be a big problem for you since you won't be doing these transforms on demand, just when you want to revise.</li> <li><em>Difficult to learn</em>. You can be productive with XSLT pretty soon, but beware: just when it seems XSLT's are getting easy, you'll be surprised by it getting tricky all of a sudden! What you think would be difficult can be easy, and vice versa. You'll might have to import or create some templates just to do some simple date formatting, for example. It's all doable though. Don't be afraid to learn how to do "templates".</li> <li><em>Better alternatives</em>. Yes, there are better alternatives, but they are <strong>platform specific</strong>. For example, I'm in .NET land, and I've dropped XSLTs in favor of manipulating our new XElements and such, and VB.NET embedded XML is very powerful and easy. But XSLT is still great when you want to avoid becoming dependent on a particular platform.</li> </ul> <p>You're still going to use CSS as part of your strategy, right? Changing an XSLT to output styling consistently is better than doing it in 30 modules by hand, but a well-planned CSS stylesheet can still help simplify things (increase maintainability and flexibility).</p> <p><strong>In summary</strong>: To organized the layout/revision of static html pages, platform independent, for flexible distribution: yes, you have a good stategy, from what I can see. And expertise you develop in XSLT will be useful in the future, too. And after mastering XSLT, you'll <em>really</em> understand XML, which will be helpful forever.</p>
    singulars
    1. This table or related slice is empty.
    1. POIs XSLT worth investing time in and are there any actual alternatives?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPatrick Karcher
    1. USPatrick Karcher
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs XSLT worth investing time in and are there any actual alternatives?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAll the styling will be in CSS. All the interactivity will be JQuery. Thanks for your advice.
      singulars
      1. PO
      1. USKeeno
    2. CO+1, good advice. XSLT is a good and useful technology that does seem cut out for this use. But as Patrick says, just when you think that it's getting easy it will most likely bite you in the hand. Be prepared for that. That doesn't mean that you shouldn't use it though, we use XSLT in several of our projects that does similiar things and it works very good (apart from some occasional curse-words about how xslt gave someone rabies). The XSLT processors overhead isn't really -that- horrible, especially if it's done on demand. :)
      singulars
      1. PO
      1. USwasatz
    3. CO@Keeno: It sounds like you've got a good plan. JQuery (and other such quality javascript libraries) sure makes it easy to go static, doesn't it? And you can't get better performance than: someone asks for an html file and you hand it to them. I think we'll gradually see this type of strategy more often.
      singulars
      1. PO
      1. USPatrick Karcher
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload