Re: [WebDNA] WebDNA used in US Government work?

This WebDNA talk-list message is from

2013

It keeps the original formatting. numero = 110536
interpreted = N
texte = --Apple-Mail=_1EDB1C13-98EB-45E6-8184-3FEAC92AF1FFContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=iso-8859-1Actually it depends.On most moderate sized data sets I would definitely get the speed =advantage to WebDNA. It's ram based after all.But once we start talking millions of records or hundreds of thousands =of text blobs I find that SQL outperforms it when the data is designed =and indexed properly. Especially when you take into account specifically =designed Views in SQL which and eliminate great amounts of recursive =searching.SQL isn't really about the speed comparison though.SQL is an enterprise solution with robust backup and recovery options. =Restore to a particular moment is time is something that you would be =hard pressed to do with DNA.Even more important than that is the connectivity of SQL via ODBC to so =many sources.For example. I have one system that is DNA fronted with a SQL backend.There are also multiple users in the SQL database that are connecting to =the data via Excel, Filemaker and Sharepoint. All getting live data that =is in turn reflected on the web via WebDNA.With DNA data, essentially you have the ability to connect the one front =end web application you build. And for most applications that suffices. =But with SQL back ended systems we have replicated servers happening =between physical locations. Multiple web products (different servers) =connecting to shared datasets. Applications like Filemaker and Access =connecting and working on the data, all in shared ways.We will be moving to FMGO applications as well so iPads can have client =access to data.All of this really doesn't have anything to do with WebDNA, but I still =think it's one of the best rapid development syntax's around for web =development.=20I will go to PHP kicking and screaming one day most likely but with =WebDNA connecting to SQL via ODBC I have managed to delay that for 9 =years now :-)=20Still fighting the good fight :-)HTHAlexOn Aug 1, 2013, at 10:37 AM, Suzanne Swift =wrote:> Thanks Alex. Your post brings up an unrelated question...what is the =advantage of using MS SQL data in combination with WebDNA databases. Is =it faster?>=20> Kind regards,> Suzanne Swift> President> Spec Simple, Inc.>=20> SpecSimple.com> Where the World of Design Connects>=20> Read about SpecSimple.com's Virtual Library in OfficeInsight> See the Info Edge difference!>=20>=20>=20> On Thu, Aug 1, 2013 at 10:31 AM, Alex McCombie = wrote:> Webdna is used on some NYS Public school sites such as> Oswego County Boces> www.OswegoBoces.org>=20> There are 2 other school districts in this county under development.>=20>=20> It's also driving some private school sites such as> Syracuse Center Of Excellence> www.SyracuseCOE.org>=20>=20> All the sites are developed using WebDNA and are data driven from MS =SQL data in combination with WebDNA databases acting as high performance =conduits for searching.>=20> HTH> Alex>=20>=20>=20>=20> On Jul 31, 2013, at 2:02 PM, Suzanne Swift =wrote:>=20>> Hi all,>>=20>> I'm pitching a WebDNA project to the US State Department and they =want to know if DOD or any other US gov/military agency has ever used =WebDNA on a project. If there is precedence, the chances of getting =WebDNA approved for government use on a State Dept project is much =greater. =20>>=20>> Has anyone on the talk list ever done a government project (DOD or =otherwise) with WebDNA?>>=20>> Kind regards,>> Suzanne Swift>> President>> Spec Simple, Inc.>>=20>> SpecSimple.com>> Where the World of Design Connects>>=20>>=20>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_1EDB1C13-98EB-45E6-8184-3FEAC92AF1FFContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=iso-8859-1Actually it depends.

On most moderate sized data sets I would =definitely get the speed advantage to WebDNA. It's ram based after =all.

But once we start talking millions of =records or hundreds of thousands of text blobs I find that SQL =outperforms it when the data is designed and indexed properly. =Especially when you take into account specifically designed Views in SQL =which and eliminate great amounts of recursive =searching.

SQL isn't really about the speed =comparison though.

SQL is an enterprise =solution with robust backup and recovery options. Restore to a =particular moment is time is something that you would be hard pressed to =do with DNA.

Even more important than that is the connectivity =of SQL via ODBC to so many sources.

For =example. I have one system that is DNA fronted with a SQL =backend.

There are also multiple users in the SQL database =that are connecting to the data via Excel, Filemaker and Sharepoint. All =getting live data that is in turn reflected on the web via =WebDNA.

With DNA data, essentially you have the =ability to connect the one front end web application you build. And for =most applications that suffices. But with SQL back ended systems we have =replicated servers happening between physical locations. Multiple web =products (different servers) connecting to shared datasets. Applications =like Filemaker and Access connecting and working on the data, all in =shared ways.

We will be moving to FMGO =applications as well so iPads can have client access to =data.

All of this really doesn't have anything =to do with WebDNA, but I still think it's one of the best rapid =development syntax's around for web =development.

I will go to PHP kicking and =screaming one day most likely but with WebDNA connecting to SQL via ODBC =I have managed to delay that for 9 years now =:-)

Still fighting the good fight =:-)

HTH

Alex

<=br>

On Aug 1, 2013, at 10:37 AM, Suzanne Swift <suzanne@specsimple.com> =wrote:

Thanks =Alex. Your post brings up an unrelated question...what is the =advantage of using MS SQL data in combination with WebDNA databases. = Is it faster?

Kind =regards,
Suzanne Swift
President
Spec Simple, Inc.

SpecSimple.com
Where the World of Design Connects

Read about SpecSimple.com's Virtual Library in OfficeInsight

See the Info Edge difference!<=/font>

On Thu, Aug 1, 2013 at 10:31 AM, Alex =McCombie <info@adventureskies.com> =wrote:

Webdna is used on some NYS Public =school sites such as
Oswego County Boces
www.OswegoBoces.org

There are 2 other school districts in this county under =development.

It's also driving =some private school sites such as
Syracuse Center Of =Excellence
www.SyracuseCOE.org

All the sites are developed using =WebDNA and are data driven from MS SQL data in combination with WebDNA =databases acting as high performance conduits for =searching.

HTH
Alex

On Jul 31, =2013, at 2:02 PM, Suzanne Swift <suzanne@specsimple.com> wrote:

Hi =all,

I'm pitching a WebDNA project =to the US State Department and they want to know if DOD or any other US =gov/military agency has ever used WebDNA on a =project. If there is precedence, the chances of getting WebDNA approved =for government use on a State Dept project is much greater.

Has =anyone on the talk list ever done a government project (DOD or =otherwise) with WebDNA?

Kind =regards,
Suzanne Swift
President
Spec Simple, Inc.

SpecSimple.com
Where the World of Design =Connects

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

=
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us

=--Apple-Mail=_1EDB1C13-98EB-45E6-8184-3FEAC92AF1FF-- Associated Messages, from the most recent to the oldest:

Re: [WebDNA] WebDNA used in US Government work? (Alex McCombie 2013)
Re: [WebDNA] WebDNA used in US Government work? (WebDNA 2013)
Re: [WebDNA] WebDNA used in US Government work? (John Butler 2013)
Re: [WebDNA] WebDNA used in US Government work? (Alex McCombie 2013)
Re: [WebDNA] WebDNA used in US Government work? (Suzanne Swift 2013)
Re: [WebDNA] WebDNA used in US Government work? (Alex McCombie 2013)
Re: [WebDNA] WebDNA used in US Government work? (Jym Duane 2013)
Re: [WebDNA] WebDNA used in US Government work? (Suzanne Swift 2013)
Re: [WebDNA] WebDNA used in US Government work? (Jym Duane 2013)
Re: [WebDNA] WebDNA used in US Government work? (John Butler 2013)
[WebDNA] WebDNA used in US Government work? (Suzanne Swift 2013)

--Apple-Mail=_1EDB1C13-98EB-45E6-8184-3FEAC92AF1FFContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=iso-8859-1Actually it depends.On most moderate sized data sets I would definitely get the speed =advantage to WebDNA. It's ram based after all.But once we start talking millions of records or hundreds of thousands =of text blobs I find that SQL outperforms it when the data is designed =and indexed properly. Especially when you take into account specifically =designed Views in SQL which and eliminate great amounts of recursive =searching.SQL isn't really about the speed comparison though.SQL is an enterprise solution with robust backup and recovery options. =Restore to a particular moment is time is something that you would be =hard pressed to do with DNA.Even more important than that is the connectivity of SQL via ODBC to so =many sources.For example. I have one system that is DNA fronted with a SQL backend.There are also multiple users in the SQL database that are connecting to =the data via Excel, Filemaker and Sharepoint. All getting live data that =is in turn reflected on the web via WebDNA.With DNA data, essentially you have the ability to connect the one front =end web application you build. And for most applications that suffices. =But with SQL back ended systems we have replicated servers happening =between physical locations. Multiple web products (different servers) =connecting to shared datasets. Applications like Filemaker and Access =connecting and working on the data, all in shared ways.We will be moving to FMGO applications as well so iPads can have client =access to data.All of this really doesn't have anything to do with WebDNA, but I still =think it's one of the best rapid development syntax's around for web =development.=20I will go to PHP kicking and screaming one day most likely but with =WebDNA connecting to SQL via ODBC I have managed to delay that for 9 =years now :-)=20Still fighting the good fight :-)HTHAlexOn Aug 1, 2013, at 10:37 AM, Suzanne Swift =wrote:> Thanks Alex. Your post brings up an unrelated question...what is the =advantage of using MS SQL data in combination with WebDNA databases. Is =it faster?>=20> Kind regards,> Suzanne Swift> President> Spec Simple, Inc.>=20> SpecSimple.com> Where the World of Design Connects>=20> Read about SpecSimple.com's Virtual Library in OfficeInsight> See the Info Edge difference!>=20>=20>=20> On Thu, Aug 1, 2013 at 10:31 AM, Alex McCombie = wrote:> Webdna is used on some NYS Public school sites such as> Oswego County Boces> www.OswegoBoces.org>=20> There are 2 other school districts in this county under development.>=20>=20> It's also driving some private school sites such as> Syracuse Center Of Excellence> www.SyracuseCOE.org>=20>=20> All the sites are developed using WebDNA and are data driven from MS =SQL data in combination with WebDNA databases acting as high performance =conduits for searching.>=20> HTH> Alex>=20>=20>=20>=20> On Jul 31, 2013, at 2:02 PM, Suzanne Swift =wrote:>=20>> Hi all,>>=20>> I'm pitching a WebDNA project to the US State Department and they =want to know if DOD or any other US gov/military agency has ever used =WebDNA on a project. If there is precedence, the chances of getting =WebDNA approved for government use on a State Dept project is much =greater. =20>>=20>> Has anyone on the Talk List ever done a government project (DOD or =otherwise) with WebDNA?>>=20>> Kind regards,>> Suzanne Swift>> President>> Spec Simple, Inc.>>=20>> SpecSimple.com>> Where the World of Design Connects>>=20>>=20>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_1EDB1C13-98EB-45E6-8184-3FEAC92AF1FFContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=iso-8859-1Actually it depends.