Re: [WebDNA] NoSQL: sharing some ideas

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110955
interpreted = N
texte = --Apple-Mail=_2332C50A-4380-41B8-8345-A1B7C3BF1C64 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 Using the XML format, selective information can be extracted from or = added to a file. Have a look here about the format it might have: = http://en.wikipedia.org/wiki/Document-oriented_database I suppose you could also =93store=94 mp3, pictures or whatever file you = want, the WebDNA index keeping track of the file with any useful data. = There is no need that two records get the same number of fields, or even = the same field names. In this case, WebDNA companion is the file system itself, as WebDNA = index stores servers and paths to the documents. With a filesystem-based = database, you can take immediate advantage of the ever-increasing = capabilities and power of the underlying operating system, which have = been steadily increasing for many years now in accordance with Moore's = law. With this approach, many operating-system commands become = automatically also =93database operators=94 (think of "ls" "sort", = "find" and the other countless UNIX shell utilities). With this in mind, = and a bit of creativity, you can indeed devise a filesystem-based = database that is able to overcome the limitations of many common SQL = engines, at least for specific usage patterns, which is the whole point = behind NoSQL=92s philosophy. NoSQL appears to be a relational database implemented in awk using flat = files on the backend. Though they profess, "NoSQL essentially has no = arbitrary limits, and can work where other products can't. For example = there is no limit on data field size, the number of columns, or file = size=94. - chris On Dec 4, 2013, at 3:16 PM, Terry Nair wrote: > Thank you so much for sharing. Never really looked at it that way. If = one > stored the file as XML or JSON and if I need "read and write" = capability to > that file to update data and so forth ....how do you go about it? >=20 > I know WebDNA has a XML interpreter but I have not really used it and = as for > JSON, there is no WebDNA interpreter. I would appreciate your thoughts = on > this. >=20 > Thanks ...Terry Nair --Apple-Mail=_2332C50A-4380-41B8-8345-A1B7C3BF1C64 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIFRDCCBUAw ggQooAMCAQICEQDFbZXOe/tmBQPtCFqj0aAHMA0GCSqGSIb3DQEBBQUAMIGTMQswCQYDVQQGEwJH QjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQK ExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlv biBhbmQgU2VjdXJlIEVtYWlsIENBMB4XDTEzMDgxODAwMDAwMFoXDTE0MDgxODIzNTk1OVowMDEu MCwGCSqGSIb3DQEJARYfY2hyaXN0b3BoZS5iaWxsaW90dGV0QHdlYmRuYS51czCCASIwDQYJKoZI hvcNAQEBBQADggEPADCCAQoCggEBAO93Fui94Ico9o81FVnISpmdw/yKmd3s1HNY9v+NQGlNOzMg 6XYjuvSepfX4tmXhfid401iK9tuJT2yupu918FbeI5HdG3s5NWOUdABqb4z61g8H8yGsqFwaLlDk mBgI1DE4whCX/e+3E4CVl/6YfK7S5rWd2Ia/4K/s8GdGJNJCZOjaqteHAZZvC90RIdB2NCgZ2rbZ DSLVS2f9NfLp+rX0PVBmol9fIXC+AtmNLFR8FhTw5iQrQCcKkxaz82AEGbQv5viz5rfQG4tCGqQJ 71bSo0+JynuYIgn4KJNfcX0QMjJ3Fe7AlSRnnMF3m1k+uoR44i6F3sBY23wmfxNrK/8CAwEAAaOC Ae8wggHrMB8GA1UdIwQYMBaAFHoTTgB0W8Z4Y2QnwS/ioFu8ecV7MB0GA1UdDgQWBBRO7fSdNIXh i9FJa1vqp12NuXl8PTAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggr BgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYB BAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMFcG A1UdHwRQME4wTKBKoEiGRmh0dHA6Ly9jcmwuY29tb2RvY2EuY29tL0NPTU9ET0NsaWVudEF1dGhl bnRpY2F0aW9uYW5kU2VjdXJlRW1haWxDQS5jcmwwgYgGCCsGAQUFBwEBBHwwejBSBggrBgEFBQcw AoZGaHR0cDovL2NydC5jb21vZG9jYS5jb20vQ09NT0RPQ2xpZW50QXV0aGVudGljYXRpb25hbmRT ZWN1cmVFbWFpbENBLmNydDAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuY29tb2RvY2EuY29tMCoG A1UdEQQjMCGBH2NocmlzdG9waGUuYmlsbGlvdHRldEB3ZWJkbmEudXMwDQYJKoZIhvcNAQEFBQAD ggEBABnxNy9MQe+JW8++bsQBGoMEDFwr1SpYH45cZWkuulj3kRiGM+4uz1DLpSsr/3GjFz8WAHhG jwaAlB0WpmWfYzjh+IUkRfQqiwMKdgBd+bDKVWE6asZKn406sdvgt10IFW+Vs6drYDqe+iVFxYYO AdU71S+Q9YWgVrtg5fUgDk3iruDsRnM1nrgI2hCSUmgb6oWLEi50NGuxBN2vC/ZSTn/Ptj1IP9Xs V9F+SlZRsc3qfaRnr67XIkpjfg/PRfNg7l4CZm4ceDHr7ZpfG5tWU2tPKcrBA2HIopmch1Sqd48r /EZ2Z2h7nSqY3M8LBQnybTa8sNb8+8SllARs2DdcP0AxggOuMIIDqgIBATCBqTCBkzELMAkGA1UE BhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgG A1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGlj YXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwCQYFKw4DAhoFAKCC AdkwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTMxMjA0MTMwNzM0 WjAjBgkqhkiG9w0BCQQxFgQULfnNbXVC9EVwrrkA7lfAAsotoZAwgboGCSsGAQQBgjcQBDGBrDCB qTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMH U2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGll bnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcw gbwGCyqGSIb3DQEJEAILMYGsoIGpMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBN YW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5 MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENB AhEAxW2Vznv7ZgUD7Qhao9GgBzANBgkqhkiG9w0BAQEFAASCAQC2r5DJMaeQFsiNeTmeiAGC1ORq w70CXo6YVrR/12YycS4aHQTUryh5roSJfcB/yzHePXjpOJz+9yKT6wdRHerlIwh16UBeULe+/Vip zSreq51y9o25ieF9FWcz2H/u2eQNFXSVYsWZ2Vg5BszBdwxEL3pT8fSajAUivmcT9VT02CjIUyBS whTSuWOX75nJopZA6WWkxKRVeOtu/Bnqo+ko7jLTseVXFIvjrPmL2w5zxzxmjJJoEBOJxd0Paxi7 AQLrnbh5NXqv1lJZt4oSN8y4LFRbJ1/MF6P3v10AUwrJ89N1UbrPM9ckyVjb1Zzr+UCSCgQ5yGlI givhREldOvJ8AAAAAAAA --Apple-Mail=_2332C50A-4380-41B8-8345-A1B7C3BF1C64-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] NoSQL: sharing some ideas (Terry Wilson 2013)
  2. Re: [WebDNA] NoSQL: sharing some ideas (christophe.billiottet@webdna.us 2013)
  3. RE: [WebDNA] NoSQL: sharing some ideas ("Terry Nair" 2013)
  4. [WebDNA] NoSQL: sharing some ideas (christophe.billiottet@webdna.us 2013)
--Apple-Mail=_2332C50A-4380-41B8-8345-A1B7C3BF1C64 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 Using the XML format, selective information can be extracted from or = added to a file. Have a look here about the format it might have: = http://en.wikipedia.org/wiki/Document-oriented_database I suppose you could also =93store=94 mp3, pictures or whatever file you = want, the WebDNA index keeping track of the file with any useful data. = There is no need that two records get the same number of fields, or even = the same field names. In this case, WebDNA companion is the file system itself, as WebDNA = index stores servers and paths to the documents. With a filesystem-based = database, you can take immediate advantage of the ever-increasing = capabilities and power of the underlying operating system, which have = been steadily increasing for many years now in accordance with Moore's = law. With this approach, many operating-system commands become = automatically also =93database operators=94 (think of "ls" "sort", = "find" and the other countless UNIX shell utilities). With this in mind, = and a bit of creativity, you can indeed devise a filesystem-based = database that is able to overcome the limitations of many common SQL = engines, at least for specific usage patterns, which is the whole point = behind NoSQL=92s philosophy. NoSQL appears to be a relational database implemented in awk using flat = files on the backend. Though they profess, "NoSQL essentially has no = arbitrary limits, and can work where other products can't. For example = there is no limit on data field size, the number of columns, or file = size=94. - chris On Dec 4, 2013, at 3:16 PM, Terry Nair wrote: > Thank you so much for sharing. Never really looked at it that way. If = one > stored the file as XML or JSON and if I need "read and write" = capability to > that file to update data and so forth ....how do you go about it? >=20 > I know WebDNA has a XML interpreter but I have not really used it and = as for > JSON, there is no WebDNA interpreter. I would appreciate your thoughts = on > this. >=20 > Thanks ...Terry Nair --Apple-Mail=_2332C50A-4380-41B8-8345-A1B7C3BF1C64 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIFRDCCBUAw ggQooAMCAQICEQDFbZXOe/tmBQPtCFqj0aAHMA0GCSqGSIb3DQEBBQUAMIGTMQswCQYDVQQGEwJH QjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQK ExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlv biBhbmQgU2VjdXJlIEVtYWlsIENBMB4XDTEzMDgxODAwMDAwMFoXDTE0MDgxODIzNTk1OVowMDEu MCwGCSqGSIb3DQEJARYfY2hyaXN0b3BoZS5iaWxsaW90dGV0QHdlYmRuYS51czCCASIwDQYJKoZI hvcNAQEBBQADggEPADCCAQoCggEBAO93Fui94Ico9o81FVnISpmdw/yKmd3s1HNY9v+NQGlNOzMg 6XYjuvSepfX4tmXhfid401iK9tuJT2yupu918FbeI5HdG3s5NWOUdABqb4z61g8H8yGsqFwaLlDk mBgI1DE4whCX/e+3E4CVl/6YfK7S5rWd2Ia/4K/s8GdGJNJCZOjaqteHAZZvC90RIdB2NCgZ2rbZ DSLVS2f9NfLp+rX0PVBmol9fIXC+AtmNLFR8FhTw5iQrQCcKkxaz82AEGbQv5viz5rfQG4tCGqQJ 71bSo0+JynuYIgn4KJNfcX0QMjJ3Fe7AlSRnnMF3m1k+uoR44i6F3sBY23wmfxNrK/8CAwEAAaOC Ae8wggHrMB8GA1UdIwQYMBaAFHoTTgB0W8Z4Y2QnwS/ioFu8ecV7MB0GA1UdDgQWBBRO7fSdNIXh i9FJa1vqp12NuXl8PTAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggr BgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYB BAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMFcG A1UdHwRQME4wTKBKoEiGRmh0dHA6Ly9jcmwuY29tb2RvY2EuY29tL0NPTU9ET0NsaWVudEF1dGhl bnRpY2F0aW9uYW5kU2VjdXJlRW1haWxDQS5jcmwwgYgGCCsGAQUFBwEBBHwwejBSBggrBgEFBQcw AoZGaHR0cDovL2NydC5jb21vZG9jYS5jb20vQ09NT0RPQ2xpZW50QXV0aGVudGljYXRpb25hbmRT ZWN1cmVFbWFpbENBLmNydDAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuY29tb2RvY2EuY29tMCoG A1UdEQQjMCGBH2NocmlzdG9waGUuYmlsbGlvdHRldEB3ZWJkbmEudXMwDQYJKoZIhvcNAQEFBQAD ggEBABnxNy9MQe+JW8++bsQBGoMEDFwr1SpYH45cZWkuulj3kRiGM+4uz1DLpSsr/3GjFz8WAHhG jwaAlB0WpmWfYzjh+IUkRfQqiwMKdgBd+bDKVWE6asZKn406sdvgt10IFW+Vs6drYDqe+iVFxYYO AdU71S+Q9YWgVrtg5fUgDk3iruDsRnM1nrgI2hCSUmgb6oWLEi50NGuxBN2vC/ZSTn/Ptj1IP9Xs V9F+SlZRsc3qfaRnr67XIkpjfg/PRfNg7l4CZm4ceDHr7ZpfG5tWU2tPKcrBA2HIopmch1Sqd48r /EZ2Z2h7nSqY3M8LBQnybTa8sNb8+8SllARs2DdcP0AxggOuMIIDqgIBATCBqTCBkzELMAkGA1UE BhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgG A1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGlj YXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwCQYFKw4DAhoFAKCC AdkwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTMxMjA0MTMwNzM0 WjAjBgkqhkiG9w0BCQQxFgQULfnNbXVC9EVwrrkA7lfAAsotoZAwgboGCSsGAQQBgjcQBDGBrDCB qTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMH U2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGll bnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcw gbwGCyqGSIb3DQEJEAILMYGsoIGpMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBN YW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5 MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENB AhEAxW2Vznv7ZgUD7Qhao9GgBzANBgkqhkiG9w0BAQEFAASCAQC2r5DJMaeQFsiNeTmeiAGC1ORq w70CXo6YVrR/12YycS4aHQTUryh5roSJfcB/yzHePXjpOJz+9yKT6wdRHerlIwh16UBeULe+/Vip zSreq51y9o25ieF9FWcz2H/u2eQNFXSVYsWZ2Vg5BszBdwxEL3pT8fSajAUivmcT9VT02CjIUyBS whTSuWOX75nJopZA6WWkxKRVeOtu/Bnqo+ko7jLTseVXFIvjrPmL2w5zxzxmjJJoEBOJxd0Paxi7 AQLrnbh5NXqv1lJZt4oSN8y4LFRbJ1/MF6P3v10AUwrJ89N1UbrPM9ckyVjb1Zzr+UCSCgQ5yGlI givhREldOvJ8AAAAAAAA --Apple-Mail=_2332C50A-4380-41B8-8345-A1B7C3BF1C64-- christophe.billiottet@webdna.us

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Kaaaaahhhhhhhnnnnnnn! (1997) Max Record length restated as maybe bug (1997) [capitalize] (2005) Not really WebCat (1997) Apache 2.2 (2007) View Source from cache (1997) Click-through/Referral tracking solution needed (2000) PIXO support (1997) Upgrade to 3.07 problems (2000) Shipping charges depending on tax rate? (1997) Template Cache problem, bombing WebSTAR problem (2000) Problems with [Applescript] (1997) [WebDNA] Authorize.net and [tcpconnect] (2016) The max=0 issue is a bug ... CALL TO ACTION (2000) DB not found error (2004) RE: Symantec VIsual Page 1.0.3 (1997) shipcost (1997) WebCat Beta NT 18 (1997) There's a bug in the math context ... (1997) Resume Catalog ? (1997)