[aprssig] APRS IS streams and MySQL

[Andrew Rich]

Ah thank you greg

I did not know about that - i used to build it in manually !

Cheers 
----------------------------------------------------------
Andrew Rich 
Airways Technical Officer Grade 4
Surveillance - RADAR ADS-B
Amateur Radio Callsign VK4TEC
email: vk4tec at tech-software.net
web: www.tech-software.net
  ----- Original Message ----- 
  From: Gregory A. Carter 
  To: Andrew Rich (Home) ; TAPR APRS Mailing List 
  Sent: Sunday, September 13, 2009 2:46 AM
  Subject: Re: [aprssig] APRS IS streams and MySQL


  Hi Andrew,

  Most MySQL libraries have functions called variations of "mysql_escape" that will automatically escape characters like quotes.  Before any data is sent from APRS-IS through our OpenAPRS parser and into mySQL all of the "control code" characters are removed using REGEX replacements.

  Greg

  NV6G
  OpenAPRS.Net


  On Sat, Sep 12, 2009 at 9:01 AM, Andrew Rich (Home) <vk4tec at tech-software.net> wrote:

    As we know the APRS stream contains characters that MySQL or QUERY forming applications may not like.

    Just wondering how the big guns handle these ?

    Do you do a search and replace with an escape and re-parse on request ?

    The characters I can think of are quotes 




    ----------------------------------------------------------
    Andrew Rich 
    Airways Technical Officer Grade 4
    Surveillance - RADAR ADS-B
    Amateur Radio Callsign VK4TEC
    email: vk4tec at tech-software.net
    web: www.tech-software.net

    _______________________________________________
    aprssig mailing list
    aprssig at tapr.org
    https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig






------------------------------------------------------------------------------



  No virus found in this incoming message.
  Checked by AVG - www.avg.com 
  Version: 8.5.409 / Virus Database: 270.13.92/2364 - Release Date: 09/11/09 17:51:00
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.tapr.org/pipermail/aprssig_lists.tapr.org/attachments/20090913/014974cd/attachment.html>