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:

RE: setting cookies then redirecting? (1998) Questions (1998) Another strange one (2000) HomePage Caution (1997) pretty Urgent: Crash after addlineitem (2001) New Mac Public Beta Available (1997) Emailer choke (1997) I'm new (2001) [DOS]/DOS query perhaps OT (2003) Cart Numbers (1997) [interpret] inside the db field? (1997) Type 11 errors setting up WebCAt 2 (1997) WebCat & WebTen (1997) DNS Lookup 2 (2000) Country & Ship-to address & other fields ? (1997) Shipcost Based on SubTotal (1998) Separate SSL Server (1997) Merchant account (1998) shipcost (1997) Multiple Pulldowns (1997)