Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.javascript > #8654 > unrolled thread

JSON schema ??? SQL-Binding ??? HTML-Form-Binding ???

Back to article view | Back to comp.lang.javascript

Contents

  JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Jörg Weule <weule@7b5.de> - 2011-11-26 21:08 +0100
    Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-11-26 21:27 +0100
    Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Jörg Weule <weule@7b5.de> - 2011-11-26 22:45 +0100
      Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-11-26 23:08 +0100
        Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Jörg Weule <weule@7b5.de> - 2011-11-26 23:27 +0100
          Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-11-26 23:32 +0100
            Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Jörg Weule <weule@7b5.de> - 2011-11-26 23:43 +0100
              Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Bart Lateur <bart.lateur@telenet.be> - 2011-11-27 20:27 +0100
                Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Jörg Weule <weule@7b5.de> - 2011-11-28 18:56 +0100
                  Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Denis McMahon <denismfmcmahon@gmail.com> - 2011-11-28 21:41 +0000
                    Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Jörg Weule <weule@7b5.de> - 2011-11-29 08:22 +0100
                      Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Scott Sauyet <scott.sauyet@gmail.com> - 2011-11-29 05:32 -0800
                      Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Denis McMahon <denismfmcmahon@gmail.com> - 2011-11-29 18:05 +0000
                        Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-11-29 23:59 +0100
                          Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Arno Welzel <usenet@arnowelzel.de> - 2011-11-30 12:35 +0100
                            Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Denis McMahon <denismfmcmahon@gmail.com> - 2011-11-30 11:42 +0000
                              Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-11-30 14:53 +0100
                                Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Arno Welzel <usenet@arnowelzel.de> - 2011-12-02 13:52 +0100
              Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Arno Welzel <usenet@arnowelzel.de> - 2011-11-28 01:58 +0100
        Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Jörg Weule <weule@7b5.de> - 2011-11-26 23:31 +0100
          Re: JSON schema ??? SQL-Binding ??? HTML-Form-Binding ??? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-11-26 23:34 +0100

Page 1 of 2  [1] 2  Next page →

#8654 — JSON schema ??? SQL-Binding ??? HTML-Form-Binding ???

Hello,

is there anything like an JSON schema file format?

It would be nice to describe the structure of the objects to transfer 
between the Browser and the php-backend.

Any methods to extend a SQL-binding and/or HTML-bindung is apreciated: 
SQL will be used to store the data at tables and HTML form elements are 
used to edit the data fields additional to the node tree.

Any ideas?

With kind regards

Jörg

[toc] | [next] | [standalone]

#8655

Jörg Weule wrote:

> is there anything like an JSON schema file format?

Yes.

> Any methods to extend a SQL-binding and/or HTML-bindung is apreciated:
> SQL will be used to store the data at tables and HTML form elements are
> used to edit the data fields additional to the node tree.

I beg your pardon?

BTW, your Question Mark key is borken.


PointedEars
-- 
    realism:    HTML 4.01 Strict
    evangelism: XHTML 1.0 Strict
    madness:    XHTML 1.1 as application/xhtml+xml
                                                    -- Bjoern Hoehrmann

[toc] | [prev] | [next] | [standalone]

#8656

On 11/26/2011 09:08 PM, Jörg Weule wrote:
> Hello,
>
> is there anything like an JSON schema file format?

Json objects are like XML very flexible. Is there a file format to 
describe a subset with a specific structure like XMLSchema xsd-files ?

>
> It would be nice to describe the structure of the objects to transfer
> between the Browser and the php-backend.
>
> Any methods to extend a SQL-binding and/or HTML-bindung is apreciated:
> SQL will be used to store the data at tables and HTML form elements are
> used to edit the data fields additional to the node tree.
>
> Any ideas?
>
> With kind regards
>
> Jörg
>

[toc] | [prev] | [next] | [standalone]

#8657

Jörg Weule wrote:

> On 11/26/2011 09:08 PM, Jörg Weule wrote:
>> is there anything like an JSON schema file format?
> 
> Json objects are like XML very flexible. Is there a file format to
> describe a subset with a specific structure like XMLSchema xsd-files ?

The correct answer still is "Yes".  STFW: <http://lmgtfy.com/?q=JSON+schema>

<http://catb.org/~esr/faqs/smart-questions.html>


PointedEars
-- 
Use any version of Microsoft Frontpage to create your site.
(This won't prevent people from viewing your source, but no one
will want to steal it.)
  -- from <http://www.vortex-webdesign.com/help/hidesource.htm> (404-comp.)

[toc] | [prev] | [next] | [standalone]

#8658

On 11/26/2011 11:08 PM, Thomas 'PointedEars' Lahn wrote:
> Jörg Weule wrote:
>
>> On 11/26/2011 09:08 PM, Jörg Weule wrote:
>>> is there anything like an JSON schema file format?
>>
>> Json objects are like XML very flexible. Is there a file format to
>> describe a subset with a specific structure like XMLSchema xsd-files ?
>
> The correct answer still is "Yes".  STFW:<http://lmgtfy.com/?q=JSON+schema>
>
> <http://catb.org/~esr/faqs/smart-questions.html>
>
>
> PointedEars

Thanks,

any HTML-editor for that?

With kind regards

Jörg

[toc] | [prev] | [next] | [standalone]

#8660

Jörg Weule wrote:

> Thomas 'PointedEars' Lahn wrote:
>> Jörg Weule wrote:
>>> On 11/26/2011 09:08 PM, Jörg Weule wrote:
>>>> is there anything like an JSON schema file format?
>>>
>>> Json objects are like XML very flexible. Is there a file format to
>>> describe a subset with a specific structure like XMLSchema xsd-files ?
>>
>> The correct answer still is "Yes". 
>> STFW:<http://lmgtfy.com/?q=JSON+schema>
>>
>> <http://catb.org/~esr/faqs/smart-questions.html>
> 
> Thanks,
> 
> any HTML-editor for that?

I beg your pardon?

How can there be an *HTML* editor for *JSON Schema*?  No, do not answer.

You clearly have not learned yet how to ask smart questions.
 

PointedEars
-- 
When all you know is jQuery, every problem looks $(olvable).

[toc] | [prev] | [next] | [standalone]

#8662

On 11/26/2011 11:32 PM, Thomas 'PointedEars' Lahn wrote:
> Jörg Weule wrote:
>
>> Thomas 'PointedEars' Lahn wrote:
>>> Jörg Weule wrote:
>>>> On 11/26/2011 09:08 PM, Jörg Weule wrote:
>>>>> is there anything like an JSON schema file format?
>>>>
>>>> Json objects are like XML very flexible. Is there a file format to
>>>> describe a subset with a specific structure like XMLSchema xsd-files ?
>>>
>>> The correct answer still is "Yes".
>>> STFW:<http://lmgtfy.com/?q=JSON+schema>
>>>
>>> <http://catb.org/~esr/faqs/smart-questions.html>
>>
>> Thanks,
>>
>> any HTML-editor for that?
>
> I beg your pardon?
>
> How can there be an *HTML* editor for *JSON Schema*?  No, do not answer.

I'm looking for an HTML-editor to edit data respecting a given JSON schema.
>
> You clearly have not learned yet how to ask smart questions.

May be, ... Deusch ist meine Muttersprache ;-)
There are Editors to edit data respecting a given XML-Schema! Is there a 
similar thing for JSON?
>
>
> PointedEars

Jörg

[toc] | [prev] | [next] | [standalone]

#8666

Jörg Weule wrote:

>>> any HTML-editor for that?
>>
>> I beg your pardon?
>>
>> How can there be an *HTML* editor for *JSON Schema*?  No, do not answer.
>
>I'm looking for an HTML-editor to edit data respecting a given JSON schema.

I'll spell it in simple words for you. JSON is a data structure very
much like Javascript. there is no trace of HTML in sight. 

So how can you expect to use an HTML editor to edit JSON?

-- 
	Bart Lateur
	bart.lateur@telenet.be

[toc] | [prev] | [next] | [standalone]

#8684

On 11/27/2011 08:27 PM, Bart Lateur wrote:
> Jörg Weule wrote:
>
>>>> any HTML-editor for that?
>>>
>>> I beg your pardon?
>>>
>>> How can there be an *HTML* editor for *JSON Schema*?  No, do not answer.
>>
>> I'm looking for an HTML-editor to edit data respecting a given JSON schema.
>
> I'll spell it in simple words for you. JSON is a data structure very
> much like Javascript. there is no trace of HTML in sight.
>
> So how can you expect to use an HTML editor to edit JSON?
>
Because we have tinymce to edit html ;-)

Jörg

[toc] | [prev] | [next] | [standalone]

#8688

On Mon, 28 Nov 2011 18:56:29 +0100, Jörg Weule wrote:

> On 11/27/2011 08:27 PM, Bart Lateur wrote:
>> Jörg Weule wrote:
>>
>>>>> any HTML-editor for that?
>>>>
>>>> I beg your pardon?
>>>>
>>>> How can there be an *HTML* editor for *JSON Schema*?  No, do not
>>>> answer.
>>>
>>> I'm looking for an HTML-editor to edit data respecting a given JSON
>>> schema.
>>
>> I'll spell it in simple words for you. JSON is a data structure very
>> much like Javascript. there is no trace of HTML in sight.
>>
>> So how can you expect to use an HTML editor to edit JSON?
>>
> Because we have tinymce to edit html ;-)

TinyMCE is a platform independent web based Javascript HTML WYSIWYG 
editor control released as Open Source under LGPL by Moxiecode Systems 
AB. ...

So it's not an html-editor to edit html, it's a javascript editor to edit 
html.

I think that what you may mean is that you want an editor that runs in 
javascript which can be embedded on a web page and can edit a JSON Schema 
(whatever one of those is).

Rgds

Denis McMahon

[toc] | [prev] | [next] | [standalone]

#8696

On 11/28/2011 10:41 PM, Denis McMahon wrote:
> On Mon, 28 Nov 2011 18:56:29 +0100, Jörg Weule wrote:
>
[...]
>
> TinyMCE is a platform independent web based Javascript HTML WYSIWYG
> editor control released as Open Source under LGPL by Moxiecode Systems
> AB. ...
>
> So it's not an html-editor to edit html, it's a javascript editor to edit
> html.
>
> I think that what you may mean is that you want an editor that runs in
> javascript which can be embedded on a web page and can edit a JSON Schema
> (whatever one of those is).

I want an editor for JSON data respecting a given JSON schema like 
tinymce is respecting xhtml. A canonical binding to database tables 
would be nice to store the data at the web server.

I'm running a website for a jazz club where each concert has one or more 
bands. Each band hat musicans, a text, some images and web links...

>
> Rgds
>
> Denis McMahon

Jörg

[toc] | [prev] | [next] | [standalone]

#8701

Jörg Weule wrote:
> I want an editor for JSON data respecting a given JSON schema like
> tinymce is respecting xhtml. A canonical binding to database tables
> would be nice to store the data at the web server.

Such editors probably exist, although I've never come across one.  But
your requirements raise the question of whether you also would be
better off with a document-oriented database such as Couch or Mongo.
This might be cleaner than "a canonical binding to database tables."


> I'm running a website for a jazz club where each concert has one or more
> bands. Each band hat musicans, a text, some images and web links...

One other possibility, and one that I used in a somewhat similar
circumstance, is to make the edit interface for a concert essentially
be a sample page (or page section) in which the fields that need to be
updated are visibly highlighted in some manner to make it clear that
they can be edited.  Then an edit-in-place technique would let the
user edit the fields, immediately seeing the results.  I had really
good feedback from users for such a technique.

  -- Scott

[toc] | [prev] | [next] | [standalone]

#8704

On Tue, 29 Nov 2011 08:22:45 +0100, Jörg Weule wrote:

> On 11/28/2011 10:41 PM, Denis McMahon wrote:
>> On Mon, 28 Nov 2011 18:56:29 +0100, Jörg Weule wrote:
>>
> [...]
>>
>> TinyMCE is a platform independent web based Javascript HTML WYSIWYG
>> editor control released as Open Source under LGPL by Moxiecode Systems
>> AB. ...
>>
>> So it's not an html-editor to edit html, it's a javascript editor to
>> edit html.
>>
>> I think that what you may mean is that you want an editor that runs in
>> javascript which can be embedded on a web page and can edit a JSON
>> Schema (whatever one of those is).
> 
> I want an editor for JSON data respecting a given JSON schema like
> tinymce is respecting xhtml. A canonical binding to database tables
> would be nice to store the data at the web server.

Yes, I still don't know what a "JSON schema" is though.

JSON is a way of serialising a data object.

Put your data object attributes in a suitable form presentation, and use 
javascript to serialise them.

i.e.:

1) Generate a field layout that has suitable fields for the schema.

2) Write javascript that can:

(a) expand a JSON serialised data object to populate the fields
(b) serialise data in the fields to a JSON data object
(c) grow or shrink fields or collections of fields as needed to represent 
any array components of the data
(d) ensure that data is of the correct type (eg numeric, character etc)

Rgds

Denis McMahon

[toc] | [prev] | [next] | [standalone]

#8713

Denis McMahon wrote:

> On Tue, 29 Nov 2011 08:22:45 +0100, Jörg Weule wrote:
>> I want an editor for JSON data respecting a given JSON schema like
>> tinymce is respecting xhtml. A canonical binding to database tables
>> would be nice to store the data at the web server.
> 
> Yes, I still don't know what a "JSON schema" is though.

You, too, would have known had you used a Web search engine before posting.
 
> JSON is a way of serialising a data object.

No, it is an (object) data exchange format.  Like XML, but with less 
overhead (and its own disadvantages instead, one of which JSON Schema
is attempting to remove).


PointedEars
-- 
When all you know is jQuery, every problem looks $(olvable).

[toc] | [prev] | [next] | [standalone]

#8722

Thomas 'PointedEars' Lahn, 2011-11-29 23:59:

> Denis McMahon wrote:
> 
>> On Tue, 29 Nov 2011 08:22:45 +0100, Jörg Weule wrote:
>>> I want an editor for JSON data respecting a given JSON schema like
>>> tinymce is respecting xhtml. A canonical binding to database tables
>>> would be nice to store the data at the web server.
>>
>> Yes, I still don't know what a "JSON schema" is though.
> 
> You, too, would have known had you used a Web search engine before posting.
>  
>> JSON is a way of serialising a data object.
> 
> No, it is an (object) data exchange format.  Like XML, but with less 
> overhead (and its own disadvantages instead, one of which JSON Schema
> is attempting to remove).

What is the difference between "serialising a data object" and "(object)
data exchange"?


-- 
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de

[toc] | [prev] | [next] | [standalone]

#8723

On Wed, 30 Nov 2011 12:35:17 +0100, Arno Welzel wrote:

> What is the difference between "serialising a data object" and "(object)
> data exchange"?

Only that Thomas has to call it something different to me to suggest that 
I don't know what I'm talking about.

Rgds

Denis McMahon

[toc] | [prev] | [next] | [standalone]

#8725

Denis McMahon wrote:

> On Wed, 30 Nov 2011 12:35:17 +0100, Arno Welzel wrote:
>> What is the difference between "serialising a data object" and "(object)
>> data exchange"?
> 
> Only that Thomas has to call it something different to me to suggest that
> I don't know what I'm talking about.

You don't.  JSON is about exchanging data, not serializing objects.
There does not even need to be an original object for JSON.


PointedEars
-- 
Danny Goodman's books are out of date and teach practices that are
positively harmful for cross-browser scripting.
  -- Richard Cornford, cljs, <cife6q$253$1$8300dec7@news.demon.co.uk> (2004)

[toc] | [prev] | [next] | [standalone]

#8761

Thomas 'PointedEars' Lahn, 2011-11-30 14:53:

> Denis McMahon wrote:
> 
>> On Wed, 30 Nov 2011 12:35:17 +0100, Arno Welzel wrote:
>>> What is the difference between "serialising a data object" and "(object)
>>> data exchange"?
>>
>> Only that Thomas has to call it something different to me to suggest that
>> I don't know what I'm talking about.
> 
> You don't.  JSON is about exchanging data, not serializing objects.
> There does not even need to be an original object for JSON.

BTW: JSON = JavaScript Object Notation

On <http://www.json.org/>:

"
[...]
In JSON, they take on these forms:

An object is an unordered set of name/value pairs. An object begins with
{ (left brace) and ends with } (right brace) [...]"

I assume this is what Dennis described as "serialising a data object".

And even RFC4627 talks about "objects":

"2.2.  Objects

   An object structure is represented as a pair of curly brackets
   surrounding zero or more name/value pairs (or members).  A name is a
   string.  A single colon comes after each name, separating the name
   from the value.  A single comma separates a value from a following
   name.  The names within an object SHOULD be unique.

      object = begin-object [ member *( value-separator member ) ]
      end-object

      member = string name-separator value"

Just to understand it the difference: Is "serialising a data object"
only valid for CORBA, DCOM, JDO etc. and "(object) data exchange" is
only valid for JSON?


-- 
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de

[toc] | [prev] | [next] | [standalone]

#8669

Jörg Weule, 2011-11-26 23:43:

> On 11/26/2011 11:32 PM, Thomas 'PointedEars' Lahn wrote:
>> Jörg Weule wrote:
>>
>>> Thomas 'PointedEars' Lahn wrote:
>>>> Jörg Weule wrote:
>>>>> On 11/26/2011 09:08 PM, Jörg Weule wrote:
>>>>>> is there anything like an JSON schema file format?
>>>>>
>>>>> Json objects are like XML very flexible. Is there a file format to
>>>>> describe a subset with a specific structure like XMLSchema xsd-files ?
>>>>
>>>> The correct answer still is "Yes".
>>>> STFW:<http://lmgtfy.com/?q=JSON+schema>
>>>>
>>>> <http://catb.org/~esr/faqs/smart-questions.html>
>>>
>>> Thanks,
>>>
>>> any HTML-editor for that?
>>
>> I beg your pardon?
>>
>> How can there be an *HTML* editor for *JSON Schema*?  No, do not answer.
> 
> I'm looking for an HTML-editor to edit data respecting a given JSON schema.

Why do you want to use an HTML(!) editor to edit JSON(!)?

>> You clearly have not learned yet how to ask smart questions.
> 
> May be, ... Deusch ist meine Muttersprache ;-)
> There are Editors to edit data respecting a given XML-Schema! Is there a
> similar thing for JSON?

Yes.

<http://lmgtfy.com/?q=json+editor>



-- 
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de

[toc] | [prev] | [next] | [standalone]

#8659

On 11/26/2011 11:08 PM, Thomas 'PointedEars' Lahn wrote:
> Jörg Weule wrote:
>
>> On 11/26/2011 09:08 PM, Jörg Weule wrote:
>>> is there anything like an JSON schema file format?
>>
>> Json objects are like XML very flexible. Is there a file format to
>> describe a subset with a specific structure like XMLSchema xsd-files ?
>
> The correct answer still is "Yes".  STFW:<http://lmgtfy.com/?q=JSON+schema>
>
> <http://catb.org/~esr/faqs/smart-questions.html>
>
>
> PointedEars

The answer is: http://tools.ietf.org/html/draft-zyp-json-schema-03

Any html editor for data relecting a schema?

Tanks

Jörg

[toc] | [prev] | [next] | [standalone]

Page 1 of 2  [1] 2  Next page →

Back to top | Article view | comp.lang.javascript

csiph-web