[aprssig] RE: findu.com and ui_view cgi suggestion

[Andrew Rich]

or even a wildcard

http://www.findu.com/cgi-bin/raw.cgi?call=rs0iss&start=240&length=240&time=1

I am not sure what call the iss is using, and want to see all data from
"RS0ISS-xx"

could you modify the select statement

select * from raw_data where callsign="RS0ISS-12"

to

select * from raw_data where callsign like "RS0ISS%"

that way you will get all traffic from RS0ISS-1 -2 -3 or what ever


-----Original Message-----
From: Andrew Rich [mailto:vk4tec at tech-software.net]
Sent: Saturday, 30 July 2005 1:04 PM
To: Steve Dimse; TAPR APRS Mailing List
Subject: RE: findu.com and ui_view cgi suggestion


Ok then can you make me a raw cgi that will do more than one callsign ?

comma seperated should do it

http://www.findu.com/cgi-bin/raw.cgi?call=VK4KHP-9,w3ado-1,pcast-11,rs0iss

select * from raw where callsign in
("vk4khp-9","w3ado-1","pcast-11","rs0iss")





-----Original Message-----
From: Steve Dimse [mailto:steve at dimse.com]
Sent: Saturday, 30 July 2005 12:44 PM
To: Andrew Rich
Subject: Re: findu.com and ui_view cgi suggestion



On Jul 29, 2005, at 10:37 PM, Andrew Rich wrote:

> Can you make me a cgi VERY close to rawposit.cgi that matches on
> anything,
> not just the callsign please ?
>
> I want to replay all data in your database that matches "VK4GME-3"
> a local
> digi for example
>

No, the raw data is not indexed on free text because the index would
be prohibitively large for this 24 GB table. If you asked for all
packets in the last 24 hours that contained VK4GME-3, the only way
would be for the database to access each of those 1.4 million packets
and do the search. This would take a long time (upwards of 10
minutes), and since raw is a porous table, it would lock out writes
during the time it took to do this.

Steve K4HG