nowfound

Life & fun · January 30, 2024

AS

A spreadsheet-like program to handle any data and files of any size

New features added recently: [+] The "Text File Input Filters" have been added to enable processing of CSV / text files of any size with any number of rows regardless of the amount of RAM in a computer. Filters can use RegEx patters, the popular relations, ranges and fuzzy filters. https://citadel5.com/help/gsbase/open_text_file.png For example, in GS-Base you can load this (publicly available) NYC Yellow Taxis data set: https://www.kaggle.com/datasets/elemento/nyc-yellow-taxi-tri... (1.9GB, ~12.7 million rows) in ~20s on an…

Visit citadel5.com ↗Alternatives

What it does

In the maker’s words, at launch

New features added recently: [+] The "Text File Input Filters" have been added to enable processing of CSV / text files of any size with any number of rows regardless of the amount of RAM in a computer. Filters can use RegEx patters, the popular relations, ranges and fuzzy filters. https://citadel5.com/help/gsbase/open_text_file.png For example, in GS-Base you can load this (publicly available) NYC Yellow Taxis data set: https://www.kaggle.com/datasets/elemento/nyc-yellow-taxi-tri... (1.9GB, ~12.7 million rows) in ~20s on an average/old pc with 8-16GB RAM. The obtained sheet is loaded entirely to RAM and ready to be used for instant ETL actions, column calculations, pivot table calculations, aggregations etc. With the above 12.7 million rows, creating a pivot table with the "trip_distance" as row values and "passenger_count" as column values takes with the same computer setup around 45s. With input filtering you can process NNN-gigabyte CSV files and bigger. No "cloud" limitations, even for old desktop PCs. [+] Create tables with file listings from folders and entire disks. Scan and monitor file changes on your disks; find changed files, new files and deleted files. Add and maintain any type of file metadata for each file; search the automatically created history of file changes for each file; search names/paths using regex, search for duplicates, fuzzy searches. Filter full paths, folders, file names, modification dates, access dates file sizes. Examples: Creating and verifying lists of files on disks: https://citadel5.com/help/gsbase/ver_files.htm Filtering collections of photos by EXIF tags, searching for jpg/mp3/mp4 file duplicates: https://citadel5.com/help/gsbase/formulas_duplicate_files.ht...

Does the same job

all alternatives →

More life & fun this month

the category →
  • TL
    The load-bearing vocabulary of Claude▲703

    Life & fun · 10d ago · louisabraham.github.io

  • iPhone app takes simultaneous images from 2 lenses, fuses into 1 photo▲329

    Photosynthesis fires two of your iPhone

    Life & fun · 28d ago · photosynthesis.camera

  • SoloUno▲310

    Take control of hair pulling, nail biting & skin picking

    Life & fun · 28d ago · solouno.io

  • Scroll through all 43252003274489856000 Rubik's Cube states▲295

    Scroll through all 43,252,003,274,489,856,000 reachable Rubik's Cube permutations.

    Life & fun · 26d ago · everycube.alen.is

  • Expeditione▲265

    The Interactive 3D Encyclopedia

    Life & fun · 21d ago · expeditione.fun

  • Eigendrum - Draw any shape and hear what it sounds like as a drum▲243

    Hi HN, I built Eigendrum, a web tool that solves the 2D wave equation for arbitrary shapes so you can hear what they sound like as drums. How it works: * Solves -∇²u = λu using finite element analysis (Kφ = λMφ) on a triangle mesh. * Validated to <0.1% error against closed-form solutions for circles (Bessel zeros) and rectangles. * Sound model factors in strike location, Rayleigh damping, and mallet width. * Includes Kac drums I & II to demonstrate identical sound spectra from different geometries. * No frameworks, build steps, or dependencies. Repo and tests:…

    Life & fun · 27d ago · baselashraf81.github.io

Launched alongside, January 2024

the whole month →