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

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110538
interpreted = N
texte = --Apple-Mail=_C1D958B0-E282-4E0B-8D82-62B07D7D8636 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 I would really love to see the SQL (ODBC) connectivity developed for the = latest Linux WebDNA - then we would really be in business !! Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 02/08/2013, at 2:49 AM, Alex McCombie = wrote: > Actually it depends. > On most moderate sized data sets I would definitely get the speed = advantage to WebDNA. It's ram based after all. >=20 > 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. >=20 > SQL isn't really about the speed comparison though. >=20 > 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. >=20 > 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. >=20 > 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. >=20 > We will be moving to FMGO applications as well so iPads can have = client access to data. >=20 > 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.=20 >=20 > 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 :-)=20 >=20 > Still fighting the good fight :-) >=20 > HTH > Alex >=20 >=20 > On Aug 1, 2013, at 10:37 AM, Suzanne Swift = wrote: >=20 >> 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 >=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=_C1D958B0-E282-4E0B-8D82-62B07D7D8636 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 I = would really love to see the SQL (ODBC) connectivity developed for the = latest Linux WebDNA - then we would really be in business = !!


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 02/08/2013, at 2:49 AM, Alex McCombie <info@adventureskies.com> = wrote:

Actually 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

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


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 to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- 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

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

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

= --Apple-Mail=_C1D958B0-E282-4E0B-8D82-62B07D7D8636-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] WebDNA used in US Government work? (Alex McCombie 2013)
  2. Re: [WebDNA] WebDNA used in US Government work? (WebDNA 2013)
  3. Re: [WebDNA] WebDNA used in US Government work? (John Butler 2013)
  4. Re: [WebDNA] WebDNA used in US Government work? (Alex McCombie 2013)
  5. Re: [WebDNA] WebDNA used in US Government work? (Suzanne Swift 2013)
  6. Re: [WebDNA] WebDNA used in US Government work? (Alex McCombie 2013)
  7. Re: [WebDNA] WebDNA used in US Government work? (Jym Duane 2013)
  8. Re: [WebDNA] WebDNA used in US Government work? (Suzanne Swift 2013)
  9. Re: [WebDNA] WebDNA used in US Government work? (Jym Duane 2013)
  10. Re: [WebDNA] WebDNA used in US Government work? (John Butler 2013)
  11. [WebDNA] WebDNA used in US Government work? (Suzanne Swift 2013)
--Apple-Mail=_C1D958B0-E282-4E0B-8D82-62B07D7D8636 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 I would really love to see the SQL (ODBC) connectivity developed for the = latest Linux WebDNA - then we would really be in business !! Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 02/08/2013, at 2:49 AM, Alex McCombie = wrote: > Actually it depends. > On most moderate sized data sets I would definitely get the speed = advantage to WebDNA. It's ram based after all. >=20 > 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. >=20 > SQL isn't really about the speed comparison though. >=20 > 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. >=20 > 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. >=20 > 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. >=20 > We will be moving to FMGO applications as well so iPads can have = client access to data. >=20 > 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.=20 >=20 > 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 :-)=20 >=20 > Still fighting the good fight :-) >=20 > HTH > Alex >=20 >=20 > On Aug 1, 2013, at 10:37 AM, Suzanne Swift = wrote: >=20 >> 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 >=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=_C1D958B0-E282-4E0B-8D82-62B07D7D8636 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 I = would really love to see the SQL (ODBC) connectivity developed for the = latest Linux WebDNA - then we would really be in business = !!


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 02/08/2013, at 2:49 AM, Alex McCombie <info@adventureskies.com> = wrote:

Actually 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

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


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 to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- 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

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

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

= --Apple-Mail=_C1D958B0-E282-4E0B-8D82-62B07D7D8636-- WebDNA

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:

Busted at the Border (1998) Multiple fields on 1 input (1997) Separate SSL Server (1997) deadlock (2000) Replace Statement (1997) [/application] error? (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Re:HTTP header line is too long? (1997) Country & Ship-to address & other fields ? (1997) SiteGuard Use Question (1997) Announcing general availabilty of WebDNA 4.5 release (2002) WebCat Hosting (1998) Newbie needs advice to learn to use WebDNA (2003) WebCatalog for Linux users!! (2000) Permissions Ignored - PLEASE HELP (2003) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) all records returned. (1997) Image Upload and Auto Resize? (2003) [bug] Technical Support Log Crashes Server (2004) Emailer help....! (1997)