[Patrick]

image test

[Patrick]

It looks like that “proc sort” is reading data based on the default order for unsorted records while sql sort load data into database and do a sorting based on most likely “quick sort algorithm” which produces different result than proc sort.

[Patrick]

Up

1

Down

Content removed.

• This reply was modified 4 years ago by  Patrick. Reason: irrelevant

[Patrick]

Up

0

Down

My 2 cents:

1. If it is possible use “push” instead of “pull”, for example push updates/alerts to emails with accurate changes;

2. If push is not available, try free webpage monitoring servies for example: https://visualping.io/

3. There are also desktop version of monitoring tools

4. Customize using Python tools: for example https://thp.io/2008/urlwatch/

5. Write your own code as what you’ve mentioned above

[Patrick]

Up

0

Down

Thanks. The code is written in python 2. You can convert it to python 3 here: https://www.pythonconverter.com/.

I believe that if you create a new file as data/nyt_ts.csv the script will download the data from nyt.com and write data into it.

[Patrick]

Up

0

Down

I meant that if your friend’s website is owned by himself/herself, then the changes are already known in the database. It is easier to do a lot of alert either by scheduler, by db table trigger, or other mechanism without consistently checking on this webpage every minute or so with extra web traffic without knowing what exactly the change types are (forum/posts/rely, etc.)

If the website you are monitoring is owned by other people then the 1st option doesn’t really exist.

I am not totally clear. You mean forward the new changes by email? It is a good idea but requires more work.

[Patrick]

Awesome! Thanks,