I =would really love to see the SQL (ODBC) connectivity developed for the =latest Linux WebDNA - then we would really be in business =!!=--Apple-Mail=_7DCF9B23-B053-420A-A256-4C89D3ADC86D-- Associated Messages, from the most recent to the oldest:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn 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 =:-)HTHAlex<=br>---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn 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 ConnectsRead about SpecSimple.com's Virtual Library in OfficeInsightSee 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---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOswego County BocesThere are 2 other school districts in this county under =development.It's also driving =some private school sites such asSyracuse Center Of =ExcellenceAll 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.HTHAlex
=div>On Jul 31, =2013, at 2:02 PM, Suzanne Swift <suzanne@specsimple.com> wrote:=div>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
=.To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us
--Apple-Mail=_7DCF9B23-B053-420A-A256-4C89D3ADC86DContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=iso-8859-1As best I can tell, it looks like I will try to keep 6.x running on the =winbox for as long as possible.I have countless lines of code that are all built solely around=20[SQL dsn=3DDSNname&username=3DUser&password=3DPass&statement=3Dselect * =from vi_hardware_tags_condition where R_hdweOwnerID =3D '[owner]' And =tagtitle =3D'[format 0.0f][tag][/format]' AND asset =3D '1';]and similar lines of code. Hell the one I am actively coding today is a =helpdesk system with a single webpage having 5,000 lines of of =DNA/html/css. I am not sure what the breakdown of DNA to html is exactly =but there are 195 [SQL] tags on the one page. Figure the entire system =is ~100 individual web pages and you start realizing you will never port =it :PI'm hopeful, but until then I will just keep the IIS server running and =figure out what to do going forward.AlexOn Aug 1, 2013, at 7:19 PM, WebDNA
- 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) wrote:> I would really love to see the SQL (ODBC) connectivity developed for =the latest Linux WebDNA - then we would really be in business !!>=20>=20> Regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au>=20>=20>=20>=20> On 02/08/2013, at 2:49 AM, Alex McCombie =wrote:>=20>> 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>=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=_7DCF9B23-B053-420A-A256-4C89D3ADC86DContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=iso-8859-1As =best I can tell, it looks like I will try to keep 6.x running on the =winbox for as long as possible. I have countless lines of code that =are all built solely around[SQL =dsn=3DDSNname&username=3DUser&password=3DPass&statement=3Dsele=ct * from vi_hardware_tags_condition where R_hdweOwnerID =3D '[owner]' =And tagtitle =3D'[format 0.0f][tag][/format]' AND asset =3D ='1';]and similar lines of code. Hell the one I =am actively coding today is a helpdesk system with a single webpage =having 5,000 lines of of DNA/html/css. I am not sure what the breakdown =of DNA to html is exactly but there are 195 [SQL] tags on the one page. =Figure the entire system is ~100 individual web pages and you start =realizing you will never port it =:PI'm hopeful, =but until then I will just keep the IIS server running and figure out =what to do going =forward.Alex=On Aug 1, 2013, at 7:19 PM, =WebDNA <webdna@idfk.com.au> =wrote:I =would really love to see the SQL (ODBC) connectivity developed for the =latest Linux WebDNA - then we would really be in business =!!=--Apple-Mail=_7DCF9B23-B053-420A-A256-4C89D3ADC86D-- Alex McCombie---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn 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 =:-)HTHAlex<=br>---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOn 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 ConnectsRead about SpecSimple.com's Virtual Library in OfficeInsightSee 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---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listOswego County BocesThere are 2 other school districts in this county under =development.It's also driving =some private school sites such asSyracuse Center Of =ExcellenceAll 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.HTHAlex
=div>On Jul 31, =2013, at 2:02 PM, Suzanne Swift <suzanne@specsimple.com> wrote:=div>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
=.To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@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:
2 databases (1998) [WebDNA] Paypal Sandbox TCPConnect (2012) Easter (1998) [OT] (waaaay OT) (2004) Location of Browser Info.txt file (1997) Extended [ConvertChars] (1997) [date] problem with %d%m%Y (1998) writefiles (1999) trouble updating records in database (1998) Help name our technology! (1997) Odd Cart Behavior (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) WebCat2 - [include] tags (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Just Testing (1997) Cancel Subscription (1996) Emailer problem (2000) Suggestions (1998) syntax question, not in online refernce (1997) FW: I'll Know If You Don't Read This (2006)