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-A1B7C3BF1C64Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=windows-1252Using 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_databaseI 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.- chrisOn 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-A1B7C3BF1C64Content-Disposition: attachment;filename=smime.p7sContent-Type: application/pkcs7-signature;name=smime.p7sContent-Transfer-Encoding: base64MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIFRDCCBUAwggQooAMCAQICEQDFbZXOe/tmBQPtCFqj0aAHMA0GCSqGSIb3DQEBBQUAMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBMB4XDTEzMDgxODAwMDAwMFoXDTE0MDgxODIzNTk1OVowMDEuMCwGCSqGSIb3DQEJARYfY2hyaXN0b3BoZS5iaWxsaW90dGV0QHdlYmRuYS51czCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAO93Fui94Ico9o81FVnISpmdw/yKmd3s1HNY9v+NQGlNOzMg6XYjuvSepfX4tmXhfid401iK9tuJT2yupu918FbeI5HdG3s5NWOUdABqb4z61g8H8yGsqFwaLlDkmBgI1DE4whCX/e+3E4CVl/6YfK7S5rWd2Ia/4K/s8GdGJNJCZOjaqteHAZZvC90RIdB2NCgZ2rbZDSLVS2f9NfLp+rX0PVBmol9fIXC+AtmNLFR8FhTw5iQrQCcKkxaz82AEGbQv5viz5rfQG4tCGqQJ71bSo0+JynuYIgn4KJNfcX0QMjJ3Fe7AlSRnnMF3m1k+uoR44i6F3sBY23wmfxNrK/8CAwEAAaOCAe8wggHrMB8GA1UdIwQYMBaAFHoTTgB0W8Z4Y2QnwS/ioFu8ecV7MB0GA1UdDgQWBBRO7fSdNIXhi9FJa1vqp12NuXl8PTAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMFcGA1UdHwRQME4wTKBKoEiGRmh0dHA6Ly9jcmwuY29tb2RvY2EuY29tL0NPTU9ET0NsaWVudEF1dGhlbnRpY2F0aW9uYW5kU2VjdXJlRW1haWxDQS5jcmwwgYgGCCsGAQUFBwEBBHwwejBSBggrBgEFBQcwAoZGaHR0cDovL2NydC5jb21vZG9jYS5jb20vQ09NT0RPQ2xpZW50QXV0aGVudGljYXRpb25hbmRTZWN1cmVFbWFpbENBLmNydDAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuY29tb2RvY2EuY29tMCoGA1UdEQQjMCGBH2NocmlzdG9waGUuYmlsbGlvdHRldEB3ZWJkbmEudXMwDQYJKoZIhvcNAQEFBQADggEBABnxNy9MQe+JW8++bsQBGoMEDFwr1SpYH45cZWkuulj3kRiGM+4uz1DLpSsr/3GjFz8WAHhGjwaAlB0WpmWfYzjh+IUkRfQqiwMKdgBd+bDKVWE6asZKn406sdvgt10IFW+Vs6drYDqe+iVFxYYOAdU71S+Q9YWgVrtg5fUgDk3iruDsRnM1nrgI2hCSUmgb6oWLEi50NGuxBN2vC/ZSTn/Ptj1IP9XsV9F+SlZRsc3qfaRnr67XIkpjfg/PRfNg7l4CZm4ceDHr7ZpfG5tWU2tPKcrBA2HIopmch1Sqd48r/EZ2Z2h7nSqY3M8LBQnybTa8sNb8+8SllARs2DdcP0AxggOuMIIDqgIBATCBqTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwCQYFKw4DAhoFAKCCAdkwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTMxMjA0MTMwNzM0WjAjBgkqhkiG9w0BCQQxFgQULfnNbXVC9EVwrrkA7lfAAsotoZAwgboGCSsGAQQBgjcQBDGBrDCBqTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwgbwGCyqGSIb3DQEJEAILMYGsoIGpMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBAhEAxW2Vznv7ZgUD7Qhao9GgBzANBgkqhkiG9w0BAQEFAASCAQC2r5DJMaeQFsiNeTmeiAGC1ORqw70CXo6YVrR/12YycS4aHQTUryh5roSJfcB/yzHePXjpOJz+9yKT6wdRHerlIwh16UBeULe+/VipzSreq51y9o25ieF9FWcz2H/u2eQNFXSVYsWZ2Vg5BszBdwxEL3pT8fSajAUivmcT9VT02CjIUyBSwhTSuWOX75nJopZA6WWkxKRVeOtu/Bnqo+ko7jLTseVXFIvjrPmL2w5zxzxmjJJoEBOJxd0Paxi7AQLrnbh5NXqv1lJZt4oSN8y4LFRbJ1/MF6P3v10AUwrJ89N1UbrPM9ckyVjb1Zzr+UCSCgQ5yGlIgivhREldOvJ8AAAAAAAA--Apple-Mail=_2332C50A-4380-41B8-8345-A1B7C3BF1C64--
Associated Messages, from the most recent to the oldest:
--Apple-Mail=_2332C50A-4380-41B8-8345-A1B7C3BF1C64Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=windows-1252Using 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_databaseI 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.- chrisOn 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-A1B7C3BF1C64Content-Disposition: attachment;filename=smime.p7sContent-Type: application/pkcs7-signature;name=smime.p7sContent-Transfer-Encoding: base64MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIFRDCCBUAwggQooAMCAQICEQDFbZXOe/tmBQPtCFqj0aAHMA0GCSqGSIb3DQEBBQUAMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBMB4XDTEzMDgxODAwMDAwMFoXDTE0MDgxODIzNTk1OVowMDEuMCwGCSqGSIb3DQEJARYfY2hyaXN0b3BoZS5iaWxsaW90dGV0QHdlYmRuYS51czCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAO93Fui94Ico9o81FVnISpmdw/yKmd3s1HNY9v+NQGlNOzMg6XYjuvSepfX4tmXhfid401iK9tuJT2yupu918FbeI5HdG3s5NWOUdABqb4z61g8H8yGsqFwaLlDkmBgI1DE4whCX/e+3E4CVl/6YfK7S5rWd2Ia/4K/s8GdGJNJCZOjaqteHAZZvC90RIdB2NCgZ2rbZDSLVS2f9NfLp+rX0PVBmol9fIXC+AtmNLFR8FhTw5iQrQCcKkxaz82AEGbQv5viz5rfQG4tCGqQJ71bSo0+JynuYIgn4KJNfcX0QMjJ3Fe7AlSRnnMF3m1k+uoR44i6F3sBY23wmfxNrK/8CAwEAAaOCAe8wggHrMB8GA1UdIwQYMBaAFHoTTgB0W8Z4Y2QnwS/ioFu8ecV7MB0GA1UdDgQWBBRO7fSdNIXhi9FJa1vqp12NuXl8PTAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMFcGA1UdHwRQME4wTKBKoEiGRmh0dHA6Ly9jcmwuY29tb2RvY2EuY29tL0NPTU9ET0NsaWVudEF1dGhlbnRpY2F0aW9uYW5kU2VjdXJlRW1haWxDQS5jcmwwgYgGCCsGAQUFBwEBBHwwejBSBggrBgEFBQcwAoZGaHR0cDovL2NydC5jb21vZG9jYS5jb20vQ09NT0RPQ2xpZW50QXV0aGVudGljYXRpb25hbmRTZWN1cmVFbWFpbENBLmNydDAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuY29tb2RvY2EuY29tMCoGA1UdEQQjMCGBH2NocmlzdG9waGUuYmlsbGlvdHRldEB3ZWJkbmEudXMwDQYJKoZIhvcNAQEFBQADggEBABnxNy9MQe+JW8++bsQBGoMEDFwr1SpYH45cZWkuulj3kRiGM+4uz1DLpSsr/3GjFz8WAHhGjwaAlB0WpmWfYzjh+IUkRfQqiwMKdgBd+bDKVWE6asZKn406sdvgt10IFW+Vs6drYDqe+iVFxYYOAdU71S+Q9YWgVrtg5fUgDk3iruDsRnM1nrgI2hCSUmgb6oWLEi50NGuxBN2vC/ZSTn/Ptj1IP9XsV9F+SlZRsc3qfaRnr67XIkpjfg/PRfNg7l4CZm4ceDHr7ZpfG5tWU2tPKcrBA2HIopmch1Sqd48r/EZ2Z2h7nSqY3M8LBQnybTa8sNb8+8SllARs2DdcP0AxggOuMIIDqgIBATCBqTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwCQYFKw4DAhoFAKCCAdkwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTMxMjA0MTMwNzM0WjAjBgkqhkiG9w0BCQQxFgQULfnNbXVC9EVwrrkA7lfAAsotoZAwgboGCSsGAQQBgjcQBDGBrDCBqTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwgbwGCyqGSIb3DQEJEAILMYGsoIGpMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBAhEAxW2Vznv7ZgUD7Qhao9GgBzANBgkqhkiG9w0BAQEFAASCAQC2r5DJMaeQFsiNeTmeiAGC1ORqw70CXo6YVrR/12YycS4aHQTUryh5roSJfcB/yzHePXjpOJz+9yKT6wdRHerlIwh16UBeULe+/VipzSreq51y9o25ieF9FWcz2H/u2eQNFXSVYsWZ2Vg5BszBdwxEL3pT8fSajAUivmcT9VT02CjIUyBSwhTSuWOX75nJopZA6WWkxKRVeOtu/Bnqo+ko7jLTseVXFIvjrPmL2w5zxzxmjJJoEBOJxd0Paxi7AQLrnbh5NXqv1lJZt4oSN8y4LFRbJ1/MF6P3v10AUwrJ89N1UbrPM9ckyVjb1Zzr+UCSCgQ5yGlIgivhREldOvJ8AAAAAAAA--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)