Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.os.linux.advocacy > #467242 > unrolled thread

a little bit closer

Started byowl <owl@rooftop.invalid>
First post2018-09-15 16:12 +0000
Last post2018-09-15 18:36 -0700
Articles 20 on this page of 207 — 16 participants

Back to article view | Back to comp.os.linux.advocacy


Contents

  a little bit closer owl <owl@rooftop.invalid> - 2018-09-15 16:12 +0000
    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 12:04 -0700
    Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-15 18:02 -0400
      Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-15 18:11 -0400
        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 19:22 -0700
        Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-16 11:24 +0000
          Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-16 13:00 -0400
            Re: a little bit closer "F. Russell" <fr@random.info> - 2018-09-16 20:39 +0000
              Re: a little bit closer Melzzzzz <Melzzzzz@zzzzz.com> - 2018-09-16 21:04 +0000
                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-16 14:33 -0700
                Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 08:55 -0700
                  Re: a little bit closer fr314159@gmail.com - 2018-09-17 09:09 -0700
                    Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 10:03 -0700
                    Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 13:01 -0400
                      Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 10:20 -0700
                Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 13:55 -0400
                  Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 11:02 -0700
                    Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-17 11:48 -0700
                    Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 16:29 -0400
                      Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 13:49 -0700
                        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 14:15 -0700
                        Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 17:14 -0400
                          Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 14:28 -0700
                            Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 19:26 -0400
                              Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 16:46 -0700
                                Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 21:43 -0400
                                  Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 22:03 -0400
                                    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 19:11 -0700
                                    (Sub)Threads drift, big time. Jeff-Relf.Me  @. - 2018-09-17 20:23 -0700
                                  (Sub)Threads are ReConstructed using _ parents (!GrandParents). Jeff-Relf.Me  @. - 2018-09-17 19:29 -0700
                                    Re: (Sub)Threads are ReConstructed using _ parents (!GrandParents). DFS <nospam@nospam.com> - 2018-09-17 23:12 -0400
                                      Re: (Sub)Threads are ReConstructed using _ parents (!GrandParents). Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 20:29 -0700
                                      20 years hard labor, sans food. Jeff-Relf.Me  @. - 2018-09-17 21:58 -0700
                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 14:46 -0700
                        Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-17 19:45 -0700
                      Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-17 19:46 -0700
                  Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-17 11:48 -0700
                  Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-17 21:47 +0000
                    Re: a little bit closer "F. Russell" <fr@random.info> - 2018-09-17 22:53 +0000
                      Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 15:57 -0700
                      Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-19 09:47 -0400
              Re: a little bit closer Peter Köhlmann <peter-koehlmann@t-online.de> - 2018-09-16 23:19 +0200
                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-16 14:48 -0700
              Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-17 11:42 -0500
                Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 16:37 -0400
                  Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-17 23:37 +0000
                    Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 21:24 -0400
                      Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 18:55 -0700
              Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 13:19 -0400
                Re: a little bit closer fr314159@gmail.com - 2018-09-17 10:35 -0700
                  Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 16:31 -0400
                    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 13:59 -0700
                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 10:52 -0700
                Re: a little bit closer fr314159@gmail.com - 2018-09-17 12:03 -0700
                Re: a little bit closer fr314159@gmail.com - 2018-09-17 12:26 -0700
                  Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 16:20 -0400
                    Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 13:42 -0700
                      Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 22:10 -0400
                        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 19:26 -0700
            Re: a little bit closer fr314159@gmail.com - 2018-09-17 06:58 -0700
              Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 07:28 -0700
              Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-18 22:11 -0400
                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 19:33 -0700
                Re: a little bit closer fr314159@gmail.com - 2018-09-19 05:53 -0700
                  Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-19 09:33 -0400
                    Re: a little bit closer fr314159@gmail.com - 2018-09-19 06:52 -0700
                      Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-19 11:19 -0400
                        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 08:36 -0700
                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 12:29 -0700
                        Re: a little bit closer fr314159@gmail.com - 2018-09-19 08:39 -0700
                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 09:08 -0700
                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 13:32 -0700
                          Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 09:27 -0400
                            Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-22 15:01 +0000
                              Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 20:47 -0400
                            Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-22 11:01 -0700
                              Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-22 11:18 -0700
                                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 11:41 -0700
                                Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-22 11:47 -0700
                                  Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 12:12 -0700
                                Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-23 00:21 -0400
                                  Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 10:02 -0700
                                    Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 10:59 -0700
                                      Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 11:21 -0700
                                    Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-23 14:43 -0400
                                      Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 12:28 -0700
                                        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 12:56 -0700
                                        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 16:04 -0700
                                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 17:07 -0700
                                        Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-24 09:20 -0400
                                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 06:43 -0700
                                      Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 14:18 -0700
                                        Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-23 19:30 -0400
                                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 16:51 -0700
                                            Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 20:15 -0700
                                          Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 17:04 -0700
                                            Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-24 09:26 -0400
                                              Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 06:58 -0700
                                              Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-24 08:56 -0700
                                                Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-24 12:33 -0400
                                                  Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-24 12:44 -0400
                                                  Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-24 10:54 -0700
                                                    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 11:39 -0700
                                                    Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-25 13:13 -0400
                                                      Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-25 14:26 -0400
                                                      Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-26 09:00 -0700
                                                        Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-26 19:40 -0400
                                                          Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-28 16:40 -0700
                                                  Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-24 11:13 -0700
                                                    Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-25 13:11 -0400
                                    Re: a little bit closer fr314159@gmail.com - 2018-09-24 07:53 -0700
                                      Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-24 09:03 -0700
                                        Re: a little bit closer "F. Russell" <fr@random.info> - 2018-09-24 22:32 +0000
                                          Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-25 12:04 -0400
                              Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 11:25 -0700
                              Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 21:05 -0400
                                Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 10:00 -0700
                                  Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 10:34 -0700
                  Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-19 22:04 +0000
                    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 15:22 -0700
                    Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-20 23:55 -0400
                      Re: a little bit closer Melzzzzz <Melzzzzz@zzzzz.com> - 2018-09-21 04:02 +0000
                        Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-21 06:54 -0400
                          Re: a little bit closer Mel <mel@zzzzz.com> - 2018-09-21 13:31 +0200
                            Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 04:52 -0700
                            Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-21 16:07 +0000
                              Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 10:53 -0700
                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 04:37 -0700
                          Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-21 07:24 -0500
                            Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-21 12:45 +0000
                              Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:47 -0700
                            Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:51 -0700
                            Re: a little bit closer RonB <ronb02NOSPAM@gmail.com> - 2018-09-22 16:47 +0000
                              Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-22 20:13 +0000
                                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 13:30 -0700
                                  Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 16:06 -0700
                                Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-22 17:02 -0700
                              Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-22 17:01 -0700
                              Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-24 07:33 -0500
                                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 06:11 -0700
                                Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-24 07:54 -0700
                          Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-21 12:41 +0000
                            Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:48 -0700
                            Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-22 07:08 -0400
                              Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-22 14:36 +0000
                                Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-23 08:35 -0400
                                  Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-23 13:58 +0000
                                    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 07:41 -0700
                                    Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-23 07:47 -0700
                                  Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-23 10:34 -0400
                                  Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-23 07:44 -0700
                                    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 08:13 -0700
                              Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-22 14:51 +0000
                                Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-23 08:39 -0400
                              Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-22 13:43 -0700
                                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 14:01 -0700
                            Re: a little bit closer RonB <ronb02NOSPAM@gmail.com> - 2018-09-22 16:51 +0000
                              Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-22 20:13 +0000
                                Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-24 07:45 -0500
                                  Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-24 20:51 +0000
                                    Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-24 13:55 -0700
                                    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 14:16 -0700
                      Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-21 12:31 +0000
                        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 06:41 -0700
                        Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:50 -0700
                        Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-21 16:01 +0000
                          Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 10:45 -0700
                            Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 11:09 -0700
                              Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 22:56 -0700
                        Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 08:55 -0400
                          Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-22 14:51 +0000
                            Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-23 08:42 -0400
                      Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-21 14:03 +0000
                        Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:38 -0700
                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 07:44 -0700
                        Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-22 03:04 +0000
                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 20:20 -0700
                          Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 01:01 -0700
                          Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 09:54 -0400
                  Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-20 14:58 -0400
                    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-20 12:41 -0700
              Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-19 07:09 -0500
                Re: a little bit closer fr314159@gmail.com - 2018-09-19 05:58 -0700
                  Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 06:14 -0700
            Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-18 05:31 +0000
              Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-18 17:12 +0000
                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 10:44 -0700
                Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 14:06 -0700
                Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-18 23:05 -0400
                  Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-19 04:17 +0000
                    Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 21:54 -0700
                    Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-19 09:02 -0400
                      Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 06:30 -0700
                      Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-19 22:08 +0000
                        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 15:37 -0700
                        Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-20 23:59 -0400
                          Re: a little bit closer Melzzzzz <Melzzzzz@zzzzz.com> - 2018-09-21 04:03 +0000
                            Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-21 00:50 -0400
                              Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-20 22:03 -0700
                              Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-20 22:19 -0700
                  Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 22:42 -0700
              Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 12:34 -0700
      Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 15:28 -0700
      Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-15 19:24 -0400
        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 16:32 -0700
        Re: a little bit closer Special Edd <shortbus1963me@mail.com> - 2018-09-15 19:48 -0400
        Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 18:36 -0700

Page 1 of 11  [1] 2 3 … 11  Next page →


#467242 — a little bit closer

Fromowl <owl@rooftop.invalid>
Date2018-09-15 16:12 +0000
Subjecta little bit closer
Message-ID<px900ab.3agah383@rooftop.invalid>
Some aspects of certain widgets are not configurable enough
to get a perfect match, so not all of this hideous MS Access
interface could be duplicated, but most of it is there:

https://imgur.com/a/2ZYTQux

[toc] | [next] | [standalone]


#467264

FromSteve Carroll <frelwizzen@gmail.com>
Date2018-09-15 12:04 -0700
Message-ID<337b0525-7aab-43e6-ac42-2bdb9681c657@googlegroups.com>
In reply to#467242
On Saturday, September 15, 2018 at 9:12:39 AM UTC-7, owl wrote:
> Some aspects of certain widgets are not configurable enough
> to get a perfect match, so not all of this hideous MS Access
> interface could be duplicated, but most of it is there:
> 
> https://imgur.com/a/2ZYTQux



Only what Meat wants matters to Meat. There is nothing you or I can do to change that. It's a trolling addiction and it is what it is. 

I am working on an idea which will show off how weak Systemd is. Studying Linux... forever a neophyte... So what is Meat's system for the flooding crap? JavaScript? That is the only language he knows, or admits to. He must be using it to write these idiotic "obsession" idiotic threads. Lemme conjecture, Meat took a FireFox extension that he reverse engineered and try to sell online... he is feeding it Google Groups data, grabbing random paragraphs, then mangling those using the Borůvka's algorithm and then he hand posts them because his obsessiveness enables him to do that essentially ceaselessly. 

I nonetheless persist in being unpersuaded that these nonstop posts are from a bot. 

Meat and the other trolls insist looking for guidance for an open source application is trolling. Requesting Meat to apologize, which we should all do, is different than quoting his dishonesty. My bottom line was that folk show up here so that they can engage those who disagree. It's not like we all don't know what this place is, Sandman included. In spite of my findings about Ubuntu, I continue to load it for those who have had difficulties with macOS, particularly if I know that they aren't quite good at using MS Word and navigating the file system. 



--
Live on Kickstarter
https://youtu.be/HHT9SJgYsH4
https://youtu.be/u4xD43Khhkw
https://youtu.be/iztSc_msHuo
Jonas Eklundh Communication AB

[toc] | [prev] | [next] | [standalone]


#467283

FromDFS <nospam@nospam.com>
Date2018-09-15 18:02 -0400
Message-ID<TkfnD.41344$sO2.30293@fx41.iad>
In reply to#467242
On 9/15/2018 12:12 PM, owl wrote:
> Some aspects of certain widgets are not configurable enough
> to get a perfect match, so not all of this hideous MS Access
> interface could be duplicated, but most of it is there:
> 
> https://imgur.com/a/2ZYTQux

It's logical, digital...



Now the fun begins: make your tk hack come alive with some real data.

http://s000.tinyupload.com/index.php?file_id=22267495279435247223

POST is your main man, and POSTID is the heartbeat.

[toc] | [prev] | [next] | [standalone]


#467284

FromDFS <nospam@nospam.com>
Date2018-09-15 18:11 -0400
Message-ID<XtfnD.101540$Ac3.34316@fx45.iad>
In reply to#467283
On 9/15/2018 6:02 PM, DFS wrote:
> On 9/15/2018 12:12 PM, owl wrote:
>> Some aspects of certain widgets are not configurable enough
>> to get a perfect match, so not all of this hideous MS Access
>> interface could be duplicated, but most of it is there:
>>
>> https://imgur.com/a/2ZYTQux
> 
> It's logical, digital...
> 
> 
> 
> Now the fun begins: make your tk hack come alive with some real data.
> 
> http://s000.tinyupload.com/index.php?file_id=22267495279435247223
> 
> POST is your main man, and POSTID is the heartbeat.


Send me your tcl/tk hack as it stands - I downloaded ActiveTcl for 
Windows and want to try a few things that are simple in Access (such as 
changing the rows in a drop down in response to a choice made in a list, 
or aligning/sizing widgets.


Sub listBoxUsers_Click()
  dropdown = Null 'clear currently chosen value
  dropdown.rowsource = "SELECT columns FROM tbl WHERE userid = " &
                        listBoxUsers.column(0) & ";
End Sub


me.listBox2.Left   = me.listBox1.Left + me.listBox1.Width + 1000
me.listBox2.Top    = me.listBox1.Top
me.listBox2.Width  = me.listBox1.Width
me.listBox2.Height = me.listBox1.Height

[toc] | [prev] | [next] | [standalone]


#467319

FromSteve Carroll <frelwizzen@gmail.com>
Date2018-09-15 19:22 -0700
Message-ID<45847f4e-0ac9-4161-abb4-855007d141f2@googlegroups.com>
In reply to#467284
On Saturday, September 15, 2018 at 3:13:14 PM UTC-7, DFS wrote:
> On 9/15/2018 6:02 PM, DFS wrote:
> > On 9/15/2018 12:12 PM, owl wrote:
> >> Some aspects of certain widgets are not configurable enough
> >> to get a perfect match, so not all of this hideous MS Access
> >> interface could be duplicated, but most of it is there:
> >>
> >> https://imgur.com/a/2ZYTQux
> > 
> > It's logical, digital...
> > 
> > 
> > 
> > Now the fun begins: make your tk hack come alive with some real data.
> > 
> > http://s000.tinyupload.com/index.php?file_id=22267495279435247223
> > 
> > POST is your main man, and POSTID is the heartbeat.
> 
> 
> Send me your tcl/tk hack as it stands - I downloaded ActiveTcl for 
> Windows and want to try a few things that are simple in Access (such as 
> changing the rows in a drop down in response to a choice made in a list, 
> or aligning/sizing widgets.
> 
> 
> Sub listBoxUsers_Click()
>   dropdown = Null 'clear currently chosen value
>   dropdown.rowsource = "SELECT columns FROM tbl WHERE userid = " &
>                         listBoxUsers.column(0) & ";
> End Sub
> 
> 
> me.listBox2.Left   = me.listBox1.Left + me.listBox1.Width + 1000
> me.listBox2.Top    = me.listBox1.Top
> me.listBox2.Width  = me.listBox1.Width
> me.listBox2.Height = me.listBox1.Height



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

One thing that I have never seen spoofed is the Google acct. number so perhaps you can use it as a filtering criteria, too. Here's mine:

posting-account=qzPusQoAAADVdKNEKE-jqIVbecHp7oZ7 

My gmail posts go back to 2009 (that I've seen, crackhead's forgeries using gmail only go back to 2012). Notice the posting acct. number on this response matches this post from 2009:

<https://groups.google.com/forum/#!original/comp.os.linux.advocacy/C9FwjiytRoA/ftc2GG7-37AJ>
-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - https://gpgtools.org

iQIcBAEBCgAGBQJX5+9UAAoJELnOYK54exUCqOMP/AiBMj7DVoep+aTZfsYEwg7h
tTwqKInwpmHwUjkZYu2m+kBBuXOZR47OwKWZpUCfnloN4pfL2cgTqmAHeDilVI+L
9sUw15rPd95n/5BDXezZnxzoL6n/8/GzHYmFqUJoKScaOxab4Odf97PDqVfEqiml
G86egbR85z7deWiUNcl8Bq1zLtP17eSGy0sUmPMMDrbw/7lbGQ4ayA/ZqjfzXadx
qmf3+WYUEvquDgXN4b6x9Ig+EzlIME0Ylp3I6COEFJ69Ozu3ZjwWDp1RWI0Eq4XP
vV2I1GFq19AO02hAvJ/qZcWAHgYwhhlFmVWzoqbA1dSnDsCjLr0+xGaAUVcLuwjd
qNdLSd1wrunCfUuotc6kUGyvj2Vy3zA5oWmLpHA4utjOrm5RlSyTaJHESOV08CAS
X0YO+7LjGBxZ87U//Jfo0vB5u+ij91l7Zdsphf+eSNWvJ+DoUtimlvcP5o4Te1D9
rKNmZ1QUMkl/Kjl9x70Q58XH8etkp9d2NHE1vVth5c9vsfAaNkJVHn7TIC79h4NE
Kny8Zp0r+QCsKnqs+NYd9GPyhvGsGmoBzEneAOgs7l509EoCOB3+Lfam3D7OmdvD
97FL/nbKbmDE8n9H8gs1sAua3Yfwz8S7IpHN19GTh9GNCKU8F+orXTSzAPUaKNyp
mMihyxG5fd2CFFGEQV8a
=sC4v
-----END PGP SIGNATURE-----

--
Do not click this link!!
https://youtu.be/UkAyrfOZaXc
https://groups.google.com/forum/#!topic/comp.os.linux.advocacy/tzMH39QmAmU
Jonas Eklundh Communication

[toc] | [prev] | [next] | [standalone]


#467357

Fromowl <owl@rooftop.invalid>
Date2018-09-16 11:24 +0000
Message-ID<9a0b03a.go3@rooftop.invalid>
In reply to#467284
DFS <nospam@nospam.com> wrote:
> On 9/15/2018 6:02 PM, DFS wrote:
>> On 9/15/2018 12:12 PM, owl wrote:
>>> Some aspects of certain widgets are not configurable enough
>>> to get a perfect match, so not all of this hideous MS Access
>>> interface could be duplicated, but most of it is there:
>>>
>>> https://imgur.com/a/2ZYTQux
>> 
>> It's logical, digital...
>> 
>> 
>> 
>> Now the fun begins: make your tk hack come alive with some real data.
>> 
>> http://s000.tinyupload.com/index.php?file_id=22267495279435247223
>> 
>> POST is your main man, and POSTID is the heartbeat.
> 
> 
> Send me your tcl/tk hack as it stands - I downloaded ActiveTcl for 
> Windows and want to try a few things that are simple in Access (such as 
> changing the rows in a drop down in response to a choice made in a list, 
> or aligning/sizing widgets.
> 
> 
> Sub listBoxUsers_Click()
>  dropdown = Null 'clear currently chosen value
>  dropdown.rowsource = "SELECT columns FROM tbl WHERE userid = " &
>                        listBoxUsers.column(0) & ";
> End Sub
> 
> 
> me.listBox2.Left   = me.listBox1.Left + me.listBox1.Width + 1000
> me.listBox2.Top    = me.listBox1.Top
> me.listBox2.Width  = me.listBox1.Width
> me.listBox2.Height = me.listBox1.Height


zip:
http://s000.tinyupload.com/?file_id=96646677528012057120
tarball:
http://s000.tinyupload.com/?file_id=00441577149223368325

This has the code for the Access form clone, and also a small sqlite
database with some code showing how to fill a table from a combobox
selection.

I'm barely qualified for a helloworld project when it comes to tcl/tk,
and most of this is based on bits and pieces I came across when searching
how to do various things, so there's probably a better way to do it.
The Access form stuff is messy also, because I made changes along the
way and had to re-parent widgets.

There are several methods of positioning widgets:  place, grid, pack,
etc.  "place" is the most flexible and intuitive because it uses x-y
coordinates, but I don't know how to use it for attaching a scrollbar to
a table.  You can do it with pack and grid, but grid messes up a canvas.
(pack probably does too), so the solution I used was to put a table
inside a frame, using grid commmand for its scrollbar, then used "place"
command to position that frame on a canvas.

If you find the tcl/tk stuff useful, remember that there is the tkinter
thing for python, so you can write your code in python/tkinter.
(You know you want to get off Access and do your GUI db stuff with
postgres or something, right?)  Sqlite supposedly has a lot of
builtin tcl/tk hooks.  I haven't explored that.

Anyway, I suck at SQL, so give me some sample queries to use against
your usenet db for testing some widgets.

[toc] | [prev] | [next] | [standalone]


#467389

FromDFS <nospam@nospam.com>
Date2018-09-16 13:00 -0400
Message-ID<V0wnD.58326$LK2.45842@fx36.iad>
In reply to#467357
On 9/16/2018 7:24 AM, owl wrote:
> DFS <nospam@nospam.com> wrote:
>> On 9/15/2018 6:02 PM, DFS wrote:
>>> On 9/15/2018 12:12 PM, owl wrote:
>>>> Some aspects of certain widgets are not configurable enough
>>>> to get a perfect match, so not all of this hideous MS Access
>>>> interface could be duplicated, but most of it is there:
>>>>
>>>> https://imgur.com/a/2ZYTQux
>>>
>>> It's logical, digital...
>>>
>>>
>>>
>>> Now the fun begins: make your tk hack come alive with some real data.
>>>
>>> http://s000.tinyupload.com/index.php?file_id=22267495279435247223
>>>
>>> POST is your main man, and POSTID is the heartbeat.
>>
>>
>> Send me your tcl/tk hack as it stands - I downloaded ActiveTcl for
>> Windows and want to try a few things that are simple in Access (such as
>> changing the rows in a drop down in response to a choice made in a list,
>> or aligning/sizing widgets.
>>
>>
>> Sub listBoxUsers_Click()
>>   dropdown = Null 'clear currently chosen value
>>   dropdown.rowsource = "SELECT columns FROM tbl WHERE userid = " &
>>                         listBoxUsers.column(0) & ";
>> End Sub
>>
>>
>> me.listBox2.Left   = me.listBox1.Left + me.listBox1.Width + 1000
>> me.listBox2.Top    = me.listBox1.Top
>> me.listBox2.Width  = me.listBox1.Width
>> me.listBox2.Height = me.listBox1.Height
> 
> 
> zip:
> http://s000.tinyupload.com/?file_id=96646677528012057120
> tarball:
> http://s000.tinyupload.com/?file_id=00441577149223368325
> 
> This has the code for the Access form clone, and also a small sqlite
> database with some code showing how to fill a table from a combobox
> selection.

Thanks


> I'm barely qualified for a helloworld project when it comes to tcl/tk,
> and most of this is based on bits and pieces I came across when searching
> how to do various things, so there's probably a better way to do it.
> The Access form stuff is messy also, because I made changes along the
> way and had to re-parent widgets.
> 
> There are several methods of positioning widgets:  place, grid, pack,
> etc.  "place" is the most flexible and intuitive because it uses x-y
> coordinates, but I don't know how to use it for attaching a scrollbar to
> a table.  You can do it with pack and grid, but grid messes up a canvas.
> (pack probably does too), so the solution I used was to put a table
> inside a frame, using grid commmand for its scrollbar, then used "place"
> command to position that frame on a canvas.

Yeah, that all sounds like a nightmare.  You can actually move 
everything around on an Access form with code, but it's not the usual way.

VB/Gambas/Access etc are generally just drop control on form and size it 
and move it in place.  I bet there's a palette-designer tool for this 
tcl/tk stuff, too.



> If you find the tcl/tk stuff useful, remember that there is the tkinter
> thing for python, so you can write your code in python/tkinter.
> (You know you want to get off Access and do your GUI db stuff with
> postgres or something, right?)  Sqlite supposedly has a lot of
> builtin tcl/tk hooks.  I haven't explored that.

The backend for my Access client always was and still is SQLite (the 
native Jet engine used by Access couldn't handle the file size and row 
counts);  the file USENET.sqlite is now 14GB, containing 2.62M posts in 
4 newsgroups, going back to Jul 2003.

I'm definitely going to port the entire db permanently to something 
other than SQLite (probably Postgres), but the SQLite query performance 
is fine.  But it's way slow to make changes to the tables or update 
large rowcounts.


> Anyway, I suck at SQL, so give me some sample queries to use against
> your usenet db for testing some widgets.

I sent recent 3000 total posts from cola and comp.lang.c.  Unfortunately 
I didn't think to remove 'frelwizzen' posts so there are a bunch of them 
in there.

First thing to do is create a 'master view' to see all the data - if you 
open table POST most of the data is just system-assigned ID numbers.

CREATE VIEW V_USENET AS
SELECT
  P.POSTID,
  NS.SERVERID,
  NS.SERVERNAME,
  NG.GROUPID,
  NG.GROUPNAME,
  P.ARTICLEID,
  P2A.POSTERID,
  P2A.POSTER,
  P.UTCDATE,
  P.UTCTIME,
  M.MSGID,
  M.MESSAGEID,
  U.USERAGENTID,
  U.USERAGENT,
  U.USERAGENTMAJOR,
  U.OS,
  S.SUBJECTID,
  S.SUBJECT,
  P2B.POSTERID AS REPLY_TO_POSTERID,
  P2B.POSTER AS REPLY_TO_POSTER,
  P.NEWTHREAD_YN,
  P.UNREAD_YN,
  P.DTADDED
FROM
  POST P, NNTP_SERVER NS, NNTP_GROUP NG,
  POSTER P2A, POSTER P2B, MESSAGEID M,
  USERAGENT U, SUBJECT S
WHERE
  P.SERVERID = NS.SERVERID
  AND P.GROUPID = NG.GROUPID
  AND P.POSTERID = P2A.POSTERID
  AND P.REPLY_TO_POSTERID = P2B.POSTERID
  AND P.MSGID = M.MSGID
  AND P.USERAGENTID = U.USERAGENTID
  AND P.SUBJECTID = S.SUBJECTID


  explained
  P.POSTID,         #unique system-assigned ID for the post
  NS.SERVERID,      #NNTP server ID - system assigned
  NS.SERVERNAME,    #NNTP server (ie usnews.blocknews.net)
  NG.GROUPID,       #NNTP newsgroup - system assigned ID
  NG.GROUPNAME,     #NNTP newsgroup from which article was sourced
  P.ARTICLEID,      #NNTP article number assigned by news server
  P2A.POSTERID,     #sent the post - system assigned ID
  P2A.POSTER,       #value in the From header
  P.UTCDATE,        #UTC date - converted from Date header
  P.UTCTIME,        #UTC time - converted from Date header
  M.MSGID,          #system assigned ID for the message ID
  M.MESSAGEID,      #messageID from headers
  U.USERAGENTID,    #system assigned ID for the user agent
  U.USERAGENT,      #user agent string from headers
  U.USERAGENTMAJOR, #parsed out manually or with code
  U.OS, 		   #parsed out manually or with code
  S.SUBJECTID,      #system assigned ID
  S.SUBJECT,        #header value
  P2B.POSTERID AS REPLY_TO_POSTERID,  #system assigned ID
  P2B.POSTER AS REPLY_TO_POSTER,      #poster being replied to
  P.NEWTHREAD_YN,    #is this a new top-level thread  (default N)
  P.UNREAD_YN,       #has this post been read (default N)
  P.DTADDED          #date-time stamp row added to table


A GUI tool for querying would be helpful.  On Windows I use SQLiteStudio
https://imgur.com/a/Ik6T0BL


The table POSTER is in the master view twice: once to see the name of 
the person who sent the post, and again to see the name of the person 
being replied to.

Once you have that VIEW in place, it's easy to query against.  You can 
actually use it to populate most of the front-end and the search 
results, but it'll be very slow for some things so you want to write 
individual queries instead.

That view of 3000 posts doesn't contain the table POSTERNAMEGROUP, which 
will restrict the results to posts made by nyms I considered regs, 
either currently or in the past.

The search option widgets (top to bottom, left to right) are standard: 
lists (prefix 'list'), dropdowns (dd), text boxes (txt), option groups 
(opt), check boxes (check), and buttons (btn).

On your form, I'll label them top to bottom left to right:

Name             Source of data
---------------  ----------------------------------
listPosterName   from db - SQL below
ddPosterFrom     from db - SQL below
listPeriod       hard coded list
listYear         hard coded or simple function
ddMonth          hard coded 1;Jan;2;Feb;3;Mar;...
ddNewsgroup      from db - SQL below
txtDateStart     manual entry, or based on choices
txtDateEnd       manual entry, or based on choices
ddInReplyTo      from db - SQL below
txtMessageID     manual entry
ddSearchTerms    manual entry
optSearchTerms   choose one with mouse
optSubjectBody   choose one with mouse
checkNewThreads  true/false, choose with mouse
checkUnread      true/false, choose with mouse
checkTwoWay      true/false, choose with mouse
checkFilterImmed true/false, choose with mouse
listSort         hard coded
btnSearch        kicks off search code - dynamically build up a
                   SQL statement based on choices in widgets
btnReset         resets search options to default
btnExport        kicks off code to export search results
                   to csv or txt file, etc
---------------  ----------------------------------

SQL:

listPosterName (every poster)
SELECT POSTERID, POSTER
FROM POSTER
ORDER BY LOWER(POSTER);

listPosterName (regs only)
SELECT P1.POSTERNAMEID, P1.POSTERNAME
FROM POSTERNAME P1, POSTERNAMEGROUP P2
WHERE P1.POSTERNAMEID = P2.POSTERNAMEID
AND P2.GROUPID = <chosen newsgroup>
ORDER BY LOWER(P1.POSTERNAME);

ddPosterFrom
SELECT POSTERID, POSTER
FROM  POSTER
WHERE POSTERNAMEID = <value chosen in listPosterName - regs only>
ORDER BY POSTER;

ddNewsgroup
SELECT GROUPID, GROUPNAME, GROUPABBR
FROM NNTP_GROUP
ORDER BY GROUPID;

ddInReplyTo
same SQL as listPosterName


Access lists and dropdowns have ColumnCount, ColumnWidths and 
BoundColumn properties, so you never have to see the ID numbers, but you 
can easily use them in code.  If you can't hide those ID numbers in the 
tk front-end it will look funky, but not the end of the world.

[toc] | [prev] | [next] | [standalone]


#467407

From"F. Russell" <fr@random.info>
Date2018-09-16 20:39 +0000
Message-ID<pnmf2d01om5@news4.newsguy.com>
In reply to#467389
On Sun, 16 Sep 2018 13:00:47 -0400, DFS wrote:

> 
> the file USENET.sqlite is now 14GB, containing 2.62M posts in 
> 4 newsgroups, going back to Jul 2003.
> 

In the sacred name of Jesus Fucking Christ, why in fucking
hell are you doing this?

Even collecting bottle caps would be far more fascinating
as a hobby.

Are you planning on opening an on-line freak show or selling
to the highest bidder examples of psychotic jibber jabber?

And why July 2003?  Is everything that was posted before
that date lost forever?










> I'm definitely going to port the entire db permanently to something 
> other than SQLite (probably Postgres), but the SQLite query performance 
> is fine.  But it's way slow to make changes to the tables or update 
> large rowcounts.
> 
> 
>> Anyway, I suck at SQL, so give me some sample queries to use against
>> your usenet db for testing some widgets.
> 
> I sent recent 3000 total posts from cola and comp.lang.c.  Unfortunately 
> I didn't think to remove 'frelwizzen' posts so there are a bunch of them 
> in there.
> 
> First thing to do is create a 'master view' to see all the data - if you 
> open table POST most of the data is just system-assigned ID numbers.
> 
> CREATE VIEW V_USENET AS
> SELECT
>   P.POSTID,
>   NS.SERVERID,
>   NS.SERVERNAME,
>   NG.GROUPID,
>   NG.GROUPNAME,
>   P.ARTICLEID,
>   P2A.POSTERID,
>   P2A.POSTER,
>   P.UTCDATE,
>   P.UTCTIME,
>   M.MSGID,
>   M.MESSAGEID,
>   U.USERAGENTID,
>   U.USERAGENT,
>   U.USERAGENTMAJOR,
>   U.OS,
>   S.SUBJECTID,
>   S.SUBJECT,
>   P2B.POSTERID AS REPLY_TO_POSTERID,
>   P2B.POSTER AS REPLY_TO_POSTER,
>   P.NEWTHREAD_YN,
>   P.UNREAD_YN,
>   P.DTADDED
> FROM
>   POST P, NNTP_SERVER NS, NNTP_GROUP NG,
>   POSTER P2A, POSTER P2B, MESSAGEID M,
>   USERAGENT U, SUBJECT S
> WHERE
>   P.SERVERID = NS.SERVERID
>   AND P.GROUPID = NG.GROUPID
>   AND P.POSTERID = P2A.POSTERID
>   AND P.REPLY_TO_POSTERID = P2B.POSTERID
>   AND P.MSGID = M.MSGID
>   AND P.USERAGENTID = U.USERAGENTID
>   AND P.SUBJECTID = S.SUBJECTID
> 
> 
>   explained
>   P.POSTID,         #unique system-assigned ID for the post
>   NS.SERVERID,      #NNTP server ID - system assigned
>   NS.SERVERNAME,    #NNTP server (ie usnews.blocknews.net)
>   NG.GROUPID,       #NNTP newsgroup - system assigned ID
>   NG.GROUPNAME,     #NNTP newsgroup from which article was sourced
>   P.ARTICLEID,      #NNTP article number assigned by news server
>   P2A.POSTERID,     #sent the post - system assigned ID
>   P2A.POSTER,       #value in the From header
>   P.UTCDATE,        #UTC date - converted from Date header
>   P.UTCTIME,        #UTC time - converted from Date header
>   M.MSGID,          #system assigned ID for the message ID
>   M.MESSAGEID,      #messageID from headers
>   U.USERAGENTID,    #system assigned ID for the user agent
>   U.USERAGENT,      #user agent string from headers
>   U.USERAGENTMAJOR, #parsed out manually or with code
>   U.OS, 		   #parsed out manually or with code
>   S.SUBJECTID,      #system assigned ID
>   S.SUBJECT,        #header value
>   P2B.POSTERID AS REPLY_TO_POSTERID,  #system assigned ID
>   P2B.POSTER AS REPLY_TO_POSTER,      #poster being replied to
>   P.NEWTHREAD_YN,    #is this a new top-level thread  (default N)
>   P.UNREAD_YN,       #has this post been read (default N)
>   P.DTADDED          #date-time stamp row added to table
> 
> 
> A GUI tool for querying would be helpful.  On Windows I use SQLiteStudio
> https://imgur.com/a/Ik6T0BL
> 
> 
> The table POSTER is in the master view twice: once to see the name of 
> the person who sent the post, and again to see the name of the person 
> being replied to.
> 
> Once you have that VIEW in place, it's easy to query against.  You can 
> actually use it to populate most of the front-end and the search 
> results, but it'll be very slow for some things so you want to write 
> individual queries instead.
> 
> That view of 3000 posts doesn't contain the table POSTERNAMEGROUP, which 
> will restrict the results to posts made by nyms I considered regs, 
> either currently or in the past.
> 
> The search option widgets (top to bottom, left to right) are standard: 
> lists (prefix 'list'), dropdowns (dd), text boxes (txt), option groups 
> (opt), check boxes (check), and buttons (btn).
> 
> On your form, I'll label them top to bottom left to right:
> 
> Name             Source of data
> ---------------  ----------------------------------
> listPosterName   from db - SQL below
> ddPosterFrom     from db - SQL below
> listPeriod       hard coded list
> listYear         hard coded or simple function
> ddMonth          hard coded 1;Jan;2;Feb;3;Mar;...
> ddNewsgroup      from db - SQL below
> txtDateStart     manual entry, or based on choices
> txtDateEnd       manual entry, or based on choices
> ddInReplyTo      from db - SQL below
> txtMessageID     manual entry
> ddSearchTerms    manual entry
> optSearchTerms   choose one with mouse
> optSubjectBody   choose one with mouse
> checkNewThreads  true/false, choose with mouse
> checkUnread      true/false, choose with mouse
> checkTwoWay      true/false, choose with mouse
> checkFilterImmed true/false, choose with mouse
> listSort         hard coded
> btnSearch        kicks off search code - dynamically build up a
>                    SQL statement based on choices in widgets
> btnReset         resets search options to default
> btnExport        kicks off code to export search results
>                    to csv or txt file, etc
> ---------------  ----------------------------------
> 
> SQL:
> 
> listPosterName (every poster)
> SELECT POSTERID, POSTER
> FROM POSTER
> ORDER BY LOWER(POSTER);
> 
> listPosterName (regs only)
> SELECT P1.POSTERNAMEID, P1.POSTERNAME
> FROM POSTERNAME P1, POSTERNAMEGROUP P2
> WHERE P1.POSTERNAMEID = P2.POSTERNAMEID
> AND P2.GROUPID = <chosen newsgroup>
> ORDER BY LOWER(P1.POSTERNAME);
> 
> ddPosterFrom
> SELECT POSTERID, POSTER
> FROM  POSTER
> WHERE POSTERNAMEID = <value chosen in listPosterName - regs only>
> ORDER BY POSTER;
> 
> ddNewsgroup
> SELECT GROUPID, GROUPNAME, GROUPABBR
> FROM NNTP_GROUP
> ORDER BY GROUPID;
> 
> ddInReplyTo
> same SQL as listPosterName
> 
> 
> Access lists and dropdowns have ColumnCount, ColumnWidths and 
> BoundColumn properties, so you never have to see the ID numbers, but you 
> can easily use them in code.  If you can't hide those ID numbers in the 
> tk front-end it will look funky, but not the end of the world.

[toc] | [prev] | [next] | [standalone]


#467411

FromMelzzzzz <Melzzzzz@zzzzz.com>
Date2018-09-16 21:04 +0000
Message-ID<fzznD.295720$0L2.283214@fx04.am4>
In reply to#467407
On 2018-09-16, F. Russell <fr@random.info> wrote:
> On Sun, 16 Sep 2018 13:00:47 -0400, DFS wrote:
>
>> 
>> the file USENET.sqlite is now 14GB, containing 2.62M posts in 
>> 4 newsgroups, going back to Jul 2003.
>> 
>
> In the sacred name of Jesus Fucking Christ, why in fucking
> hell are you doing this?
>
> Even collecting bottle caps would be far more fascinating
> as a hobby.
>
> Are you planning on opening an on-line freak show or selling
> to the highest bidder examples of psychotic jibber jabber?
>
> And why July 2003?  Is everything that was posted before
> that date lost forever?

That is memory of his usenet server. 14Gib is nothing to be impressed
of... 
>
>
>
>
>
>
>
>
>
>
>> I'm definitely going to port the entire db permanently to something 
>> other than SQLite (probably Postgres), but the SQLite query performance 
>> is fine.  But it's way slow to make changes to the tables or update 
>> large rowcounts.
>> 
>> 
>>> Anyway, I suck at SQL, so give me some sample queries to use against
>>> your usenet db for testing some widgets.
>> 
>> I sent recent 3000 total posts from cola and comp.lang.c.  Unfortunately 
>> I didn't think to remove 'frelwizzen' posts so there are a bunch of them 
>> in there.
>> 
>> First thing to do is create a 'master view' to see all the data - if you 
>> open table POST most of the data is just system-assigned ID numbers.
>> 
>> CREATE VIEW V_USENET AS
>> SELECT
>>   P.POSTID,
>>   NS.SERVERID,
>>   NS.SERVERNAME,
>>   NG.GROUPID,
>>   NG.GROUPNAME,
>>   P.ARTICLEID,
>>   P2A.POSTERID,
>>   P2A.POSTER,
>>   P.UTCDATE,
>>   P.UTCTIME,
>>   M.MSGID,
>>   M.MESSAGEID,
>>   U.USERAGENTID,
>>   U.USERAGENT,
>>   U.USERAGENTMAJOR,
>>   U.OS,
>>   S.SUBJECTID,
>>   S.SUBJECT,
>>   P2B.POSTERID AS REPLY_TO_POSTERID,
>>   P2B.POSTER AS REPLY_TO_POSTER,
>>   P.NEWTHREAD_YN,
>>   P.UNREAD_YN,
>>   P.DTADDED
>> FROM
>>   POST P, NNTP_SERVER NS, NNTP_GROUP NG,
>>   POSTER P2A, POSTER P2B, MESSAGEID M,
>>   USERAGENT U, SUBJECT S
>> WHERE
>>   P.SERVERID = NS.SERVERID
>>   AND P.GROUPID = NG.GROUPID
>>   AND P.POSTERID = P2A.POSTERID
>>   AND P.REPLY_TO_POSTERID = P2B.POSTERID
>>   AND P.MSGID = M.MSGID
>>   AND P.USERAGENTID = U.USERAGENTID
>>   AND P.SUBJECTID = S.SUBJECTID
>> 
>> 
>>   explained
>>   P.POSTID,         #unique system-assigned ID for the post
>>   NS.SERVERID,      #NNTP server ID - system assigned
>>   NS.SERVERNAME,    #NNTP server (ie usnews.blocknews.net)
>>   NG.GROUPID,       #NNTP newsgroup - system assigned ID
>>   NG.GROUPNAME,     #NNTP newsgroup from which article was sourced
>>   P.ARTICLEID,      #NNTP article number assigned by news server
>>   P2A.POSTERID,     #sent the post - system assigned ID
>>   P2A.POSTER,       #value in the From header
>>   P.UTCDATE,        #UTC date - converted from Date header
>>   P.UTCTIME,        #UTC time - converted from Date header
>>   M.MSGID,          #system assigned ID for the message ID
>>   M.MESSAGEID,      #messageID from headers
>>   U.USERAGENTID,    #system assigned ID for the user agent
>>   U.USERAGENT,      #user agent string from headers
>>   U.USERAGENTMAJOR, #parsed out manually or with code
>>   U.OS, 		   #parsed out manually or with code
>>   S.SUBJECTID,      #system assigned ID
>>   S.SUBJECT,        #header value
>>   P2B.POSTERID AS REPLY_TO_POSTERID,  #system assigned ID
>>   P2B.POSTER AS REPLY_TO_POSTER,      #poster being replied to
>>   P.NEWTHREAD_YN,    #is this a new top-level thread  (default N)
>>   P.UNREAD_YN,       #has this post been read (default N)
>>   P.DTADDED          #date-time stamp row added to table
>> 
>> 
>> A GUI tool for querying would be helpful.  On Windows I use SQLiteStudio
>> https://imgur.com/a/Ik6T0BL
>> 
>> 
>> The table POSTER is in the master view twice: once to see the name of 
>> the person who sent the post, and again to see the name of the person 
>> being replied to.
>> 
>> Once you have that VIEW in place, it's easy to query against.  You can 
>> actually use it to populate most of the front-end and the search 
>> results, but it'll be very slow for some things so you want to write 
>> individual queries instead.
>> 
>> That view of 3000 posts doesn't contain the table POSTERNAMEGROUP, which 
>> will restrict the results to posts made by nyms I considered regs, 
>> either currently or in the past.
>> 
>> The search option widgets (top to bottom, left to right) are standard: 
>> lists (prefix 'list'), dropdowns (dd), text boxes (txt), option groups 
>> (opt), check boxes (check), and buttons (btn).
>> 
>> On your form, I'll label them top to bottom left to right:
>> 
>> Name             Source of data
>> ---------------  ----------------------------------
>> listPosterName   from db - SQL below
>> ddPosterFrom     from db - SQL below
>> listPeriod       hard coded list
>> listYear         hard coded or simple function
>> ddMonth          hard coded 1;Jan;2;Feb;3;Mar;...
>> ddNewsgroup      from db - SQL below
>> txtDateStart     manual entry, or based on choices
>> txtDateEnd       manual entry, or based on choices
>> ddInReplyTo      from db - SQL below
>> txtMessageID     manual entry
>> ddSearchTerms    manual entry
>> optSearchTerms   choose one with mouse
>> optSubjectBody   choose one with mouse
>> checkNewThreads  true/false, choose with mouse
>> checkUnread      true/false, choose with mouse
>> checkTwoWay      true/false, choose with mouse
>> checkFilterImmed true/false, choose with mouse
>> listSort         hard coded
>> btnSearch        kicks off search code - dynamically build up a
>>                    SQL statement based on choices in widgets
>> btnReset         resets search options to default
>> btnExport        kicks off code to export search results
>>                    to csv or txt file, etc
>> ---------------  ----------------------------------
>> 
>> SQL:
>> 
>> listPosterName (every poster)
>> SELECT POSTERID, POSTER
>> FROM POSTER
>> ORDER BY LOWER(POSTER);
>> 
>> listPosterName (regs only)
>> SELECT P1.POSTERNAMEID, P1.POSTERNAME
>> FROM POSTERNAME P1, POSTERNAMEGROUP P2
>> WHERE P1.POSTERNAMEID = P2.POSTERNAMEID
>> AND P2.GROUPID = <chosen newsgroup>
>> ORDER BY LOWER(P1.POSTERNAME);
>> 
>> ddPosterFrom
>> SELECT POSTERID, POSTER
>> FROM  POSTER
>> WHERE POSTERNAMEID = <value chosen in listPosterName - regs only>
>> ORDER BY POSTER;
>> 
>> ddNewsgroup
>> SELECT GROUPID, GROUPNAME, GROUPABBR
>> FROM NNTP_GROUP
>> ORDER BY GROUPID;
>> 
>> ddInReplyTo
>> same SQL as listPosterName
>> 
>> 
>> Access lists and dropdowns have ColumnCount, ColumnWidths and 
>> BoundColumn properties, so you never have to see the ID numbers, but you 
>> can easily use them in code.  If you can't hide those ID numbers in the 
>> tk front-end it will look funky, but not the end of the world.
>


-- 
press any key to continue or any other to quit...

[toc] | [prev] | [next] | [standalone]


#467414

FromSteve Carroll <frelwizzen@gmail.com>
Date2018-09-16 14:33 -0700
Message-ID<3ce5f16b-7f5e-4d15-b17e-4e7d671569e3@googlegroups.com>
In reply to#467411
On Sunday, September 16, 2018 at 2:04:14 PM UTC-7, Melzzzzz wrote:
> On 2018-09-16, F. Russell <fr@random.info> wrote:
> > On Sun, 16 Sep 2018 13:00:47 -0400, DFS wrote:
> >
> >> 
> >> the file USENET.sqlite is now 14GB, containing 2.62M posts in 
> >> 4 newsgroups, going back to Jul 2003.
> >> 
> >
> > In the sacred name of Jesus Fucking Christ, why in fucking
> > hell are you doing this?
> >
> > Even collecting bottle caps would be far more fascinating
> > as a hobby.
> >
> > Are you planning on opening an on-line freak show or selling
> > to the highest bidder examples of psychotic jibber jabber?
> >
> > And why July 2003?  Is everything that was posted before
> > that date lost forever?
> 
> That is memory of his usenet server. 14Gib is nothing to be impressed
> of... 
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >> I'm definitely going to port the entire db permanently to something 
> >> other than SQLite (probably Postgres), but the SQLite query performance 
> >> is fine.  But it's way slow to make changes to the tables or update 
> >> large rowcounts.
> >> 
> >> 
> >>> Anyway, I suck at SQL, so give me some sample queries to use against
> >>> your usenet db for testing some widgets.
> >> 
> >> I sent recent 3000 total posts from cola and comp.lang.c.  Unfortunately 
> >> I didn't think to remove 'frelwizzen' posts so there are a bunch of them 
> >> in there.
> >> 
> >> First thing to do is create a 'master view' to see all the data - if you 
> >> open table POST most of the data is just system-assigned ID numbers.
> >> 
> >> CREATE VIEW V_USENET AS
> >> SELECT
> >>   P.POSTID,
> >>   NS.SERVERID,
> >>   NS.SERVERNAME,
> >>   NG.GROUPID,
> >>   NG.GROUPNAME,
> >>   P.ARTICLEID,
> >>   P2A.POSTERID,
> >>   P2A.POSTER,
> >>   P.UTCDATE,
> >>   P.UTCTIME,
> >>   M.MSGID,
> >>   M.MESSAGEID,
> >>   U.USERAGENTID,
> >>   U.USERAGENT,
> >>   U.USERAGENTMAJOR,
> >>   U.OS,
> >>   S.SUBJECTID,
> >>   S.SUBJECT,
> >>   P2B.POSTERID AS REPLY_TO_POSTERID,
> >>   P2B.POSTER AS REPLY_TO_POSTER,
> >>   P.NEWTHREAD_YN,
> >>   P.UNREAD_YN,
> >>   P.DTADDED
> >> FROM
> >>   POST P, NNTP_SERVER NS, NNTP_GROUP NG,
> >>   POSTER P2A, POSTER P2B, MESSAGEID M,
> >>   USERAGENT U, SUBJECT S
> >> WHERE
> >>   P.SERVERID = NS.SERVERID
> >>   AND P.GROUPID = NG.GROUPID
> >>   AND P.POSTERID = P2A.POSTERID
> >>   AND P.REPLY_TO_POSTERID = P2B.POSTERID
> >>   AND P.MSGID = M.MSGID
> >>   AND P.USERAGENTID = U.USERAGENTID
> >>   AND P.SUBJECTID = S.SUBJECTID
> >> 
> >> 
> >>   explained
> >>   P.POSTID,         #unique system-assigned ID for the post
> >>   NS.SERVERID,      #NNTP server ID - system assigned
> >>   NS.SERVERNAME,    #NNTP server (ie usnews.blocknews.net)
> >>   NG.GROUPID,       #NNTP newsgroup - system assigned ID
> >>   NG.GROUPNAME,     #NNTP newsgroup from which article was sourced
> >>   P.ARTICLEID,      #NNTP article number assigned by news server
> >>   P2A.POSTERID,     #sent the post - system assigned ID
> >>   P2A.POSTER,       #value in the From header
> >>   P.UTCDATE,        #UTC date - converted from Date header
> >>   P.UTCTIME,        #UTC time - converted from Date header
> >>   M.MSGID,          #system assigned ID for the message ID
> >>   M.MESSAGEID,      #messageID from headers
> >>   U.USERAGENTID,    #system assigned ID for the user agent
> >>   U.USERAGENT,      #user agent string from headers
> >>   U.USERAGENTMAJOR, #parsed out manually or with code
> >>   U.OS, 		   #parsed out manually or with code
> >>   S.SUBJECTID,      #system assigned ID
> >>   S.SUBJECT,        #header value
> >>   P2B.POSTERID AS REPLY_TO_POSTERID,  #system assigned ID
> >>   P2B.POSTER AS REPLY_TO_POSTER,      #poster being replied to
> >>   P.NEWTHREAD_YN,    #is this a new top-level thread  (default N)
> >>   P.UNREAD_YN,       #has this post been read (default N)
> >>   P.DTADDED          #date-time stamp row added to table
> >> 
> >> 
> >> A GUI tool for querying would be helpful.  On Windows I use SQLiteStudio
> >> https://imgur.com/a/Ik6T0BL
> >> 
> >> 
> >> The table POSTER is in the master view twice: once to see the name of 
> >> the person who sent the post, and again to see the name of the person 
> >> being replied to.
> >> 
> >> Once you have that VIEW in place, it's easy to query against.  You can 
> >> actually use it to populate most of the front-end and the search 
> >> results, but it'll be very slow for some things so you want to write 
> >> individual queries instead.
> >> 
> >> That view of 3000 posts doesn't contain the table POSTERNAMEGROUP, which 
> >> will restrict the results to posts made by nyms I considered regs, 
> >> either currently or in the past.
> >> 
> >> The search option widgets (top to bottom, left to right) are standard: 
> >> lists (prefix 'list'), dropdowns (dd), text boxes (txt), option groups 
> >> (opt), check boxes (check), and buttons (btn).
> >> 
> >> On your form, I'll label them top to bottom left to right:
> >> 
> >> Name             Source of data
> >> ---------------  ----------------------------------
> >> listPosterName   from db - SQL below
> >> ddPosterFrom     from db - SQL below
> >> listPeriod       hard coded list
> >> listYear         hard coded or simple function
> >> ddMonth          hard coded 1;Jan;2;Feb;3;Mar;...
> >> ddNewsgroup      from db - SQL below
> >> txtDateStart     manual entry, or based on choices
> >> txtDateEnd       manual entry, or based on choices
> >> ddInReplyTo      from db - SQL below
> >> txtMessageID     manual entry
> >> ddSearchTerms    manual entry
> >> optSearchTerms   choose one with mouse
> >> optSubjectBody   choose one with mouse
> >> checkNewThreads  true/false, choose with mouse
> >> checkUnread      true/false, choose with mouse
> >> checkTwoWay      true/false, choose with mouse
> >> checkFilterImmed true/false, choose with mouse
> >> listSort         hard coded
> >> btnSearch        kicks off search code - dynamically build up a
> >>                    SQL statement based on choices in widgets
> >> btnReset         resets search options to default
> >> btnExport        kicks off code to export search results
> >>                    to csv or txt file, etc
> >> ---------------  ----------------------------------
> >> 
> >> SQL:
> >> 
> >> listPosterName (every poster)
> >> SELECT POSTERID, POSTER
> >> FROM POSTER
> >> ORDER BY LOWER(POSTER);
> >> 
> >> listPosterName (regs only)
> >> SELECT P1.POSTERNAMEID, P1.POSTERNAME
> >> FROM POSTERNAME P1, POSTERNAMEGROUP P2
> >> WHERE P1.POSTERNAMEID = P2.POSTERNAMEID
> >> AND P2.GROUPID = <chosen newsgroup>
> >> ORDER BY LOWER(P1.POSTERNAME);
> >> 
> >> ddPosterFrom
> >> SELECT POSTERID, POSTER
> >> FROM  POSTER
> >> WHERE POSTERNAMEID = <value chosen in listPosterName - regs only>
> >> ORDER BY POSTER;
> >> 
> >> ddNewsgroup
> >> SELECT GROUPID, GROUPNAME, GROUPABBR
> >> FROM NNTP_GROUP
> >> ORDER BY GROUPID;
> >> 
> >> ddInReplyTo
> >> same SQL as listPosterName
> >> 
> >> 
> >> Access lists and dropdowns have ColumnCount, ColumnWidths and 
> >> BoundColumn properties, so you never have to see the ID numbers, but you 
> >> can easily use them in code.  If you can't hide those ID numbers in the 
> >> tk front-end it will look funky, but not the end of the world.
> >
> 
> 
> -- 
> press any key to continue or any other to quit...



Klaus Schadenfreude deceived Flooder Carroll some, big fucking deal. Flooder Carroll is being a wailing bitch about it? Well... like I said, Klaus Schadenfreude would never deny the flooder is Flooder Carroll, who is a self professed programmer but I don't know if it could be used to get by Google's spam filters. If Flooder Carroll calls getting his ass *kicked hard* for over a decade by everyone (and completely trashing his reputation and any reason for me to give credence to anything he has to say - until the cows come home) effective 'trolling', then yeah... he is a crack troll. I can not personally accept that view, I use another term. I call Flooder Carroll a complete dumb-ass. Are you being stupid on purpose? You're like a shark in a goldfish bowl. We all see you there and tell you as much. And you're so ignorant you keep failing to see it. Protected code is not enough to protect you. 

-- 
What Every Entrepreneur Must Know
https://youtu.be/0ZNxaaKD7-c
https://youtu.be/GPPqvw8iEBs
Jonas Eklundh Communication AB

[toc] | [prev] | [next] | [standalone]


#467551

FromSteve Carroll <fretwizzer@gmail.com>
Date2018-09-17 08:55 -0700
Message-ID<26fff7dd-7edf-4afd-a6eb-578f795a18cd@googlegroups.com>
In reply to#467411
On Sunday, September 16, 2018 at 3:04:14 PM UTC-6, Melzzzzz wrote:
> On 2018-09-16, F. Russell <fr@random.info> wrote:
> > On Sun, 16 Sep 2018 13:00:47 -0400, DFS wrote:
> >
> >> 
> >> the file USENET.sqlite is now 14GB, containing 2.62M posts in 
> >> 4 newsgroups, going back to Jul 2003.
> >> 
> >
> > In the sacred name of Jesus Fucking Christ, why in fucking
> > hell are you doing this?
> >
> > Even collecting bottle caps would be far more fascinating
> > as a hobby.
> >
> > Are you planning on opening an on-line freak show or selling
> > to the highest bidder examples of psychotic jibber jabber?
> >
> > And why July 2003?  Is everything that was posted before
> > that date lost forever?
> 
> That is memory of his usenet server. 14Gib is nothing to be impressed
> of... 

For playing around with data like this it's nothing to sneeze at.

[toc] | [prev] | [next] | [standalone]


#467553

Fromfr314159@gmail.com
Date2018-09-17 09:09 -0700
Message-ID<64ccc1bb-8890-4cbc-9329-ac5e79f6d627@googlegroups.com>
In reply to#467551
On Monday, September 17, 2018 at 11:55:58 AM UTC-4, Steve Carroll wrote:

> > 
> > That is memory of his usenet server. 14Gib is nothing to be impressed
> > of... 
> 
> For playing around with data like this it's nothing to sneeze at.
>

Since this is exclusively TEXT data, a compressed database
would be a LOT smaller than 14Gib, maybe only 1-2Gib.

But that junk SQLite doesn't support compression.

Of course DB access is slower with compression but that
junk python is slower than molasses regardless.

[toc] | [prev] | [next] | [standalone]


#467564

FromSteve Carroll <fretwizzer@gmail.com>
Date2018-09-17 10:03 -0700
Message-ID<1f1fb49a-095d-4607-9882-0b452e5fc84e@googlegroups.com>
In reply to#467553
On Monday, September 17, 2018 at 10:09:42 AM UTC-6, fr31...@gmail.com wrote:
> On Monday, September 17, 2018 at 11:55:58 AM UTC-4, Steve Carroll wrote:
> 
> > > 
> > > That is memory of his usenet server. 14Gib is nothing to be impressed
> > > of... 
> > 
> > For playing around with data like this it's nothing to sneeze at.
> >
> 
> Since this is exclusively TEXT data, a compressed database
> would be a LOT smaller than 14Gib, maybe only 1-2Gib.
> 
> But that junk SQLite doesn't support compression.
> 
> Of course DB access is slower with compression but that
> junk python is slower than molasses regardless.

I understand why he uses Python for certain kinds of things. 
SQLite? Not so much for stuff like this.

[toc] | [prev] | [next] | [standalone]


#467565

FromDFS <nospam@nospam.com>
Date2018-09-17 13:01 -0400
Message-ID<R7RnD.146192$Vl2.43630@fx46.iad>
In reply to#467553
On 9/17/2018 12:09 PM, fr314159@gmail.com wrote:
> On Monday, September 17, 2018 at 11:55:58 AM UTC-4, Steve Carroll wrote:
> 
>>>
>>> That is memory of his usenet server. 14Gib is nothing to be impressed
>>> of...
>>
>> For playing around with data like this it's nothing to sneeze at.
>>
> 
> Since this is exclusively TEXT data, a compressed database
> would be a LOT smaller than 14Gib, maybe only 1-2Gib.
> 
> But that junk SQLite doesn't support compression.
> 
> Of course DB access is slower with compression but that
> junk python is slower than molasses regardless.


I use python for loading the data and for some reports, and it's plenty 
fast:

* 3.5 seconds to count daily posts for 3 years
* 3 seconds to count the Top 1000 words for 3 years


All display is Access via ODBC to SQLite.  0.18sec to load 800 posts to 
screen.

https://imgur.com/a/V5r59nD

[toc] | [prev] | [next] | [standalone]


#467569

FromSteve Carroll <frelwizzen@gmail.com>
Date2018-09-17 10:20 -0700
Message-ID<7d231a0b-11b6-4d52-b644-65eb62324253@googlegroups.com>
In reply to#467565
On Monday, September 17, 2018 at 10:03:48 AM UTC-7, DFS wrote:
> On 9/17/2018 12:09 PM, fr314159@gmail.com wrote:
> > On Monday, September 17, 2018 at 11:55:58 AM UTC-4, Steve Carroll wrote:
> > 
> >>>
> >>> That is memory of his usenet server. 14Gib is nothing to be impressed
> >>> of...
> >>
> >> For playing around with data like this it's nothing to sneeze at.
> >>
> > 
> > Since this is exclusively TEXT data, a compressed database
> > would be a LOT smaller than 14Gib, maybe only 1-2Gib.
> > 
> > But that junk SQLite doesn't support compression.
> > 
> > Of course DB access is slower with compression but that
> > junk python is slower than molasses regardless.
> 
> 
> I use python for loading the data and for some reports, and it's plenty 
> fast:
> 
> * 3.5 seconds to count daily posts for 3 years
> * 3 seconds to count the Top 1000 words for 3 years
> 
> 
> All display is Access via ODBC to SQLite.  0.18sec to load 800 posts to 
> screen.
> 
> https://imgur.com/a/V5r59nD



For most I would just think the comment is worth looking into. Of course, given that it's Steven Petruzzellis I would skip that doubt and go straight to 'drug-induced delusion' because that's most of what he does. It is faster to assume it is a lie until proved otherwise. Once Jonas Eklundh grokked how effective Steven Petruzzellis is at portraying himself as the 'injured party' he has figured out this isn't as unbelievable as it was claimed. By listening to 'social warriors' like that you get concepts like 'liberalism'. Carried to its (il)logical intent, the media position that it's 'bigoted' for a hetero guy to not wish to have sex with a dead body is born. You can say I am Snoop Dogg for all I care. Any horrendously obsessive druggie could easily do the same. Perhaps you use it incorrectly. Do you not comprehend the use of VPN? If the content is a bunch of rambling bullshit. We know what that means. 

Who are you even speaking to? 

-- 
One Smart Penny
https://youtu.be/HMx0RyzbPgQ
https://www.youtube.com/watch?v=0ZNxaaKD7-c
Jonas Eklundh Communication

[toc] | [prev] | [next] | [standalone]


#467579

FromDFS <nospam@nospam.com>
Date2018-09-17 13:55 -0400
Message-ID<vWRnD.133645$HK2.131797@fx08.iad>
In reply to#467411
On 9/16/2018 5:04 PM, Melzzzzz wrote:

> That is memory of his usenet server. 14Gib is nothing to be impressed
> of...


I think it's pretty UNimpressive to be that big and contain only 2.6M posts.

The main issue is the 1453-line Snitlist that Carroll posts 3x per day.

[toc] | [prev] | [next] | [standalone]


#467580

FromSteve Carroll <fretwizzer@gmail.com>
Date2018-09-17 11:02 -0700
Message-ID<75ad7e55-0386-43c6-ab68-1d45b21ef4de@googlegroups.com>
In reply to#467579
On Monday, September 17, 2018 at 11:57:50 AM UTC-6, DFS wrote:
> On 9/16/2018 5:04 PM, Melzzzzz wrote:
> 
> > That is memory of his usenet server. 14Gib is nothing to be impressed
> > of...
> 
> 
> I think it's pretty UNimpressive to be that big and contain only 2.6M posts.
> 
> The main issue is the 1453-line Snitlist that Carroll posts 3x per day.

LOL! Yeah, I have been slacking, haven't I? ;)

How many times is it in there as posted by me (as opposed to a forgery)?

[toc] | [prev] | [next] | [standalone]


#467596

FromSnit <usenet@gallopinginsanity.com>
Date2018-09-17 11:48 -0700
Message-ID<g0ab8mF4shlU7@mid.individual.net>
In reply to#467580
On 9/17/18 11:02 AM, Steve Carroll wrote:
> On Monday, September 17, 2018 at 11:57:50 AM UTC-6, DFS wrote:
>> On 9/16/2018 5:04 PM, Melzzzzz wrote:
>>
>>> That is memory of his usenet server. 14Gib is nothing to be impressed
>>> of...
>>
>>
>> I think it's pretty UNimpressive to be that big and contain only 2.6M posts.
>>
>> The main issue is the 1453-line Snitlist that Carroll posts 3x per day.
> 
> LOL! Yeah, I have been slacking, haven't I? ;)
> 
> How many times is it in there as posted by me (as opposed to a forgery)?
> 

Your posts are yours no matter what account you use.

-- 
Personal attacks from those who troll show their own insecurity. They 
cannot use reason to show the message to be wrong so they try to feel 
somehow superior by attacking the messenger.

They cling to their attacks and ignore the message time and time again.

<https://youtu.be/H4NW-Cqh308>

[toc] | [prev] | [next] | [standalone]


#467630

FromDFS <nospam@nospam.com>
Date2018-09-17 16:29 -0400
Message-ID<k9UnD.104581$RN2.61996@fx40.iad>
In reply to#467580
On 9/17/2018 2:02 PM, Steve Carroll wrote:
> On Monday, September 17, 2018 at 11:57:50 AM UTC-6, DFS wrote:
>> On 9/16/2018 5:04 PM, Melzzzzz wrote:
>>
>>> That is memory of his usenet server. 14Gib is nothing to be impressed
>>> of...
>>
>>
>> I think it's pretty UNimpressive to be that big and contain only 2.6M posts.
>>
>> The main issue is the 1453-line Snitlist that Carroll posts 3x per day.
> 
> LOL! Yeah, I have been slacking, haven't I? ;)
> 
> How many times is it in there as posted by me (as opposed to a forgery)?


107x by "Steve Carroll <fretwizzer@gmail.com>" in the last 5 years

search Sep 18 2013 to Sep 17 2018

To get the list I did a search on 'BaJoRi:', the 8th entry and a unique 
word that probably didn't overcount.  Of course I didn't view every post 
to confirm it contains the full Snitlist.

You often enough felt compelled to post it multiple times a day (4x on 
2015-08-18).  The mental illness is strong.



UTCDATE,MESSAGEID
2013-11-04,<3ee812db-2385-4de2-8386-cfb0676ef37b@googlegroups.com>
2013-11-18,<d0b131de-5dfa-43bd-a021-a25aec0cfd94@googlegroups.com>

2013-12-03,<c940af4d-411f-481d-8105-df9330a07785@googlegroups.com>
2013-12-03,<59487d91-3d45-4b3c-b5b2-62c345b3e5cb@googlegroups.com>

2013-12-06,<ffc9643f-e8b0-477c-9c96-f9cc591097d6@googlegroups.com>
2013-12-06,<a0e035a5-2d3a-4736-917c-ddcab3c5e3d9@googlegroups.com>

2013-12-07,<dd0942ec-add3-4aa1-8cd8-f7eff035d306@googlegroups.com>
2013-12-11,<ba89196a-2061-4df8-b9e0-7de7a518f440@googlegroups.com>
2013-12-12,<9e50b706-61c1-4536-94cc-22eca9a0e317@googlegroups.com>
2013-12-13,<370e4e15-d8d4-4bcb-a716-f2ef39913a5e@googlegroups.com>

2013-12-18,<666499ef-2b45-4f69-b042-9e4583ad368b@googlegroups.com>
2013-12-18,<6d796985-936c-41d3-8b0c-b584b3906f8f@googlegroups.com>
2013-12-18,<843ded45-a361-4453-b2c0-9c1cfd25d410@googlegroups.com>

2014-02-05,<5b31dced-3932-4cca-bc53-c3215942daee@googlegroups.com>
2014-02-05,<b7a10fbb-ffbb-49a3-927d-9d72e8b5ca4e@googlegroups.com>

2014-02-07,<4b69cb83-6f63-4728-888a-5615f09c9c7e@googlegroups.com>
2014-02-07,<604d5a61-51e4-4954-ab30-93392bd64310@googlegroups.com>

2014-02-08,<e281a88f-4d38-43ad-a060-7bf1b8fafb58@googlegroups.com>
2014-02-11,<9da99f20-f45a-4772-9d8b-0ddbac730605@googlegroups.com>
2014-02-21,<f612f7ef-9fef-4170-ac43-e03a5488ed97@googlegroups.com>
2014-04-01,<d30f1563-3f6e-425e-bb2d-83eeca0314af@googlegroups.com>
2014-04-20,<d1a974c1-0ff1-4896-b103-d172d7b063d9@googlegroups.com>
2014-06-24,<da052af3-50ee-4341-8a45-a93d8eefbc70@googlegroups.com>
2014-07-03,<3c40f7ad-c9a4-4076-a5d2-01dbc2d36d9c@googlegroups.com>

2014-07-31,<b81daa98-7b25-4183-971a-b4b496bd8107@googlegroups.com>
2014-07-31,<24d5013e-5ee0-4ea9-992d-d6d5c8f3e037@googlegroups.com>

2014-08-07,<cd1963c7-4347-4cf3-a7b2-2e36539ef316@googlegroups.com>
2014-08-20,<3a081e12-c58e-46d3-b353-b81a9d84203c@googlegroups.com>
2014-08-25,<c0f1e175-ec90-4c86-a116-e3e23b5ba363@googlegroups.com>
2014-08-27,<3c17a958-a9b8-4191-b086-0c2ec1d93ecf@googlegroups.com>
2014-10-24,<8c611f8a-7fa5-4803-b753-a444f20c8f20@googlegroups.com>
2014-10-25,<48e8aa2f-1072-4189-92d4-c97d89cf8763@googlegroups.com>
2014-10-28,<f2ac5213-f2dc-488f-bff1-bcb28bc074ff@googlegroups.com>

2014-10-30,<3b616993-9e16-4291-82a8-1c89f61bdd4c@googlegroups.com>
2014-10-30,<97eca86e-a459-4299-87fe-7d1cc4b4a159@googlegroups.com>
2014-10-30,<f4f28186-bd80-4158-b623-a145d9b45590@googlegroups.com>

2014-10-31,<83950226-27f7-430e-9d60-7ed491cf039b@googlegroups.com>
2014-10-31,<c96c2339-74c6-4bdc-8c7d-29742bdecf53@googlegroups.com>
2014-10-31,<8f16ad82-c344-454c-ab1a-ee302815b8f4@googlegroups.com>

2014-11-25,<5b30d8c4-7c37-4647-bcd2-3f34c5d94e0f@googlegroups.com>
2014-11-29,<c6fa04be-1420-418e-9e71-46ba2d34f1bd@googlegroups.com>
2015-01-06,<310a2d2a-1d23-45c9-8745-57e3c2db33ea@googlegroups.com>
2015-02-26,<4ecc27c3-cedc-48cf-ac1e-d36c6b7bd78e@googlegroups.com>
2015-02-27,<ce14c7c4-5020-425c-841c-0fe403983d8a@googlegroups.com>
2015-03-19,<66a4aee5-0c33-4bf6-972a-2d141330e61a@googlegroups.com>
2015-05-08,<046e0ec2-be6b-46d3-985f-d56275dad162@googlegroups.com>
2015-08-04,<704ff716-7060-4924-a661-2924b0b2acce@googlegroups.com>
2015-08-05,<fd130011-1a6f-4f9a-b8e0-4ffe6db4f32d@googlegroups.com>
2015-08-06,<4abc4ec2-c938-46d6-8633-5a7fb3acb68c@googlegroups.com>

2015-08-18,<16ffba08-2508-4efd-9ce8-ec5c21fcda79@googlegroups.com>
2015-08-18,<206bbceb-a614-4b7e-97d8-94e32b59163c@googlegroups.com>
2015-08-18,<2d913225-9e79-49d4-8d12-ce020a7791db@googlegroups.com>
2015-08-18,<7d04108f-44f9-4b7d-9747-0379a061bc33@googlegroups.com>

2015-08-19,<0bc6b0b2-5304-4643-9dd0-ccd2e3ed1d62@googlegroups.com>
2015-09-01,<88fbdc4e-46e4-46a9-8f9e-1e9a73a1d99b@googlegroups.com>
2015-09-03,<565aaaa7-88c5-4966-8a83-066ccd853789@googlegroups.com>
2015-10-21,<8257cd48-aa3d-4807-805a-25336a238f8a@googlegroups.com>
2015-11-25,<63fe8c89-a32e-46c0-a986-817e1c4eeafa@googlegroups.com>
2015-11-30,<536a6fa5-38d1-41bd-86d8-d9d51df240c6@googlegroups.com>
2015-12-11,<653327b6-d9ea-4205-9609-6f57db1dde4b@googlegroups.com>
2015-12-18,<01ec1854-c8d0-4a64-8c6f-f47065ec09c3@googlegroups.com>

2015-12-23,<641025b6-4186-4eaa-8b2e-23414f1197db@googlegroups.com>
2015-12-23,<220f27fd-8065-4df4-8008-842b9e3a5de0@googlegroups.com>

2016-03-29,<e1ff01c3-1809-4cd7-970f-69ccf7f3ef5c@googlegroups.com>
2016-04-16,<e574111b-c4e4-4076-93f0-6a1f83d009aa@googlegroups.com>
2016-04-20,<2a5d5c1c-d063-4b06-9d74-44c968de9871@googlegroups.com>
2016-04-28,<bfa76dd6-5840-4e88-8f5b-d261266e0fe5@googlegroups.com>
2016-04-29,<6d22401e-afa6-49d0-a170-0b8ac045bb66@googlegroups.com>

2016-05-04,<634addf1-f1ea-4659-91e3-d1222b03d2db@googlegroups.com>
2016-05-04,<c1222e1c-04b2-427f-9d32-db2d08a8dfb9@googlegroups.com>
2016-05-04,<274bdbc0-43fe-4e3d-91f2-da998e80956e@googlegroups.com>

2016-05-06,<e833129f-462f-4ddb-a0f1-453c487dc039@googlegroups.com>
2016-05-06,<c5643e52-5d82-4898-9eb9-f5e0366c9cec@googlegroups.com>

2016-05-07,<bba188e9-10c9-4a7c-b51b-e56fe4bf1759@googlegroups.com>
2016-05-08,<c0b2d2e8-ec5b-4e6f-9941-e550b1812647@googlegroups.com>

2016-05-11,<47c65fe3-31f0-4df8-aee6-d549a4d5b732@googlegroups.com>
2016-05-11,<2f812d4b-032e-4260-9d64-1c2a4f5edddf@googlegroups.com>

2016-05-13,<7478f141-18d1-4e66-ba7d-5f02f83476c2@googlegroups.com>
2016-05-21,<d0640a01-d401-49f6-a134-a0fb479cd70c@googlegroups.com>
2016-06-03,<4b7a3347-5bd9-4ea6-a5a5-cefd28c8aaea@googlegroups.com>
2016-08-10,<e625ce11-5763-4cec-9324-0f110d19773d@googlegroups.com>
2016-08-29,<0d94c80b-77cd-496c-b7e7-4f2e2a383d9e@googlegroups.com>
2016-08-31,<6148a649-5550-4c3f-ba7d-898e6bfd0e64@googlegroups.com>
2016-09-11,<e6508e2a-a05c-4e88-9ecf-ef4b991f713d@googlegroups.com>
2016-09-14,<175bb08f-c1d4-4588-8158-659b8716c4ad@googlegroups.com>
2016-11-14,<b31c08dd-5b9d-4352-9220-554c7557a200@googlegroups.com>
2016-11-19,<dd45a178-ffb0-483e-aaa8-0a706ae8066a@googlegroups.com>

2016-11-23,<b4995d3d-bb1f-494b-b7a0-2b00520bb021@googlegroups.com>
2016-11-23,<e55bd465-b5b4-4e5e-aa3a-237593ce4340@googlegroups.com>

2016-11-26,<a86b3437-a2e3-4ee2-8bf6-041d456cb065@googlegroups.com>
2016-12-09,<7fa04214-df9b-4c69-a88d-a43146d97828@googlegroups.com>

2017-02-02,<98f0709b-5a63-4d1b-9a57-e1079026d34d@googlegroups.com>
2017-02-02,<22d35ade-9ea9-4a87-95d4-7855d7e43883@googlegroups.com>
2017-02-02,<790ae697-a30b-450c-8219-e78772bfa7c2@googlegroups.com>
2017-02-02,<e0a6e954-2e43-4ca9-ba36-c4c38ad048cb@googlegroups.com>

2017-04-10,<f0690d41-8de8-416b-bd05-799741a5a3b6@googlegroups.com>
2017-04-17,<e859f765-0191-4f6b-b06c-f39624c930f0@googlegroups.com>
2017-04-18,<6fdef6d1-102c-4cf0-9713-d2470f602435@googlegroups.com>

2017-04-20,<bd157de4-901f-4657-942f-c6de68b6a178@googlegroups.com>
2017-04-20,<482ab23a-f887-4e04-9a95-6c7ea279875e@googlegroups.com>

2017-07-17,<9c6216d1-662e-47e5-8548-e4ff2683bd1d@googlegroups.com>
2018-06-01,<pesdjn$udt$1@dont-email.me>
2018-07-18,<bbd5aae5-3831-471b-ae23-5cf0d58391e5@googlegroups.com>
2018-07-23,<0bcd2eea-72a9-49ff-9d3c-138719574c30@googlegroups.com>
2018-07-24,<248b1859-4635-4835-ae98-042f9e4504e0@googlegroups.com>
2018-07-30,<a574e078-32dc-46e9-b4a9-f07e0afb5c2e@googlegroups.com>
2018-08-04,<7bf4ffc8-ce7f-44b9-8cf7-6f2d51b92b0a@googlegroups.com>

[toc] | [prev] | [next] | [standalone]


#467635

FromSteve Carroll <fretwizzer@gmail.com>
Date2018-09-17 13:49 -0700
Message-ID<0fa16ec0-49cb-44d1-8ef3-97321c9c756c@googlegroups.com>
In reply to#467630
On Monday, September 17, 2018 at 2:30:11 PM UTC-6, DFS wrote:
> On 9/17/2018 2:02 PM, Steve Carroll wrote:
> > On Monday, September 17, 2018 at 11:57:50 AM UTC-6, DFS wrote:
> >> On 9/16/2018 5:04 PM, Melzzzzz wrote:
> >>
> >>> That is memory of his usenet server. 14Gib is nothing to be impressed
> >>> of...
> >>
> >>
> >> I think it's pretty UNimpressive to be that big and contain only 2.6M posts.
> >>
> >> The main issue is the 1453-line Snitlist that Carroll posts 3x per day.
> > 
> > LOL! Yeah, I have been slacking, haven't I? ;)
> > 
> > How many times is it in there as posted by me (as opposed to a forgery)?
> 
> 
> 107x by "Steve Carroll <fretwizzer@gmail.com>" in the last 5 years
> 
> search Sep 18 2013 to Sep 17 2018
> 
> To get the list I did a search on 'BaJoRi:', the 8th entry and a unique 
> word that probably didn't overcount.  Of course I didn't view every post 
> to confirm it contains the full Snitlist.

How long did the search take?

> You often enough felt compelled to post it multiple times a day (4x on 
> 2015-08-18).  The mental illness is strong.

LOL! The goal was once a week so I missed it by a mile ;)

[toc] | [prev] | [next] | [standalone]


Page 1 of 11  [1] 2 3 … 11  Next page →

Back to top | Article view | comp.os.linux.advocacy


csiph-web