Page 6 of 6 FirstFirst ... 3456
Results 201 to 208 of 208

Thread: Re PlanetSourceCode

  1. #201
    Lively Member
    Join Date
    Jul 2020
    Posts
    82

    Re: Re PlanetSourceCode

    The first item is: "Access Database Manipulation via JDBC (for Microsoft Access)".
    The .mdb has a similar entity in text form, i.e. without .zip (in attachment).
    Is it the same thing or not?
    Last edited by Argus19; Sep 26th, 2020 at 10:36 AM.

  2. #202
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Posts
    2,312

    Re: Re PlanetSourceCode

    Yes, this submission is a code snippet from the database (w/o a separate zip file).

    Unfortunately the database is very inconsistent regarding votes to these submissions (w/o attachments) and some of them have average rating above 5 which is nonsense.

    I removed all submissions rated above 5 from the Hall of fame list but left them in authors/categories lists so these can be located from the indexes at all.

    I'll probably have to remove all submissions w/o attachments as these seem to have dubious/rigged ratings or the database is just an inconsistent mess (as usual).

    I'm currently back-linking the indexes from the submissions' descriptions, i.e. each submission will have a back-link to its author's index and its category's index too.

    Edit: for instance this submission [Polygon Animation Editor (PAN File Editor)] now has back-links to its author's list of submissions [(Tim Miron) yar-interactive software] and its category list [Graphics] too.

    Here is a submission (again w/o attachment) with user rating above 5: https://github.com/Planet-Source-Cod...easily__1-2209

    cheers,
    </wqw>

  3. #203
    Addicted Member
    Join Date
    Jun 2016
    Location
    Espaņa
    Posts
    163

    Re: Re PlanetSourceCode

    good job wqweto.

  4. #204
    Lively Member
    Join Date
    Jul 2020
    Posts
    82

    Re: Re PlanetSourceCode

    The rating is incorrect in many cases.
    It will be sufficient to keep the author's name or pseudonym.
    If there are discussions of newly created materials, then consider the rating from "zero".

  5. #205
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Posts
    2,312

    Re: Re PlanetSourceCode

    Quote Originally Posted by yokesee View Post
    good job wqweto.
    Thanks!

    I even managed to come up with a slogan for the new github org


    Planet Source Code
    Better hosted, still the same "POScode". . .


    Not sure if the slogan color is brown enough though. . . LOL :-))

    cheers,
    </wqw>

  6. #206
    Hyperactive Member
    Join Date
    Jun 2015
    Posts
    371

    Re: Re PlanetSourceCode

    awesome work on this thanks

  7. #207
    Addicted Member
    Join Date
    Jun 2019
    Posts
    162

    Re: Re PlanetSourceCode

    Finally was able to finish testing and cleanup some of the code of the tools to decrypt and extract PSC files, prepare project repos and upload to Gitea server. Some tasks take too much time - uploads to Gitea server for last run took 10.5+ hours running all on localhost on SSDs and lots of RAM.

    Still parts of the code needs refactoring as there are routines to be moved from the tools to the proper libraries or just general refactoring.

    The attached ZIP contains VB.NET 2019 solution (sources only) that will perform the tasks and the final result is this:



    13557 repositories imported in Gitea - some are lost due to broken ZIP files (or just the used ZIP extract library failed to extract).

    Here is short description (full one in README.md in the attached archive):
    ------------

    The provided tools are split into 3 tasks:

    • Decrypt PSC files which are just normal ZIPs xor-ed with 0FFh and extract archives
    • Prepare project repos with proper file name; removed unsafe files (.exe, .obj, .ocx), add .gitignore and .gitattributes; create README.md with proper description and picture from the provided in the CD MDB
    • For each project initialize new Git repository, create repo on Gitea server and push the repo to Gitea


    The projects are allowing extensibility via provided interfaces: different ZIP extraction library, database access for MDB, support for different centralized Git hosting servers - Gitea, Gogs, GitHub, GitLab, etc.

    Tools are using simple INI file for configuration for easier editing (compared to XML or other file types).

    For increased performance the tools can run not only as single-threaded tasks but also to use multi-threading. Decrypt/extract and prepare repos tasks work much faster with parallel processing enabled (configurable in tools config.ini file).

    Note that parallel processing stresses alot the CPU, memory and disk system so it is recommended to use SSD for files storage. Upload to Gitea task requires also 16GB of system memory and still may force Gitea to become unstable and the tool to crash so for this task parallel processing is disabled in the configuration file.
    Attached Files Attached Files

  8. #208
    Addicted Member Episcopal's Avatar
    Join Date
    Mar 2019
    Location
    Brazil
    Posts
    154

    Re: Re PlanetSourceCode

    Someone here said about the Forums for VB communities that "we are the best". It really is, you are the best ...

Page 6 of 6 FirstFirst ... 3456

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width