2 pointsby lotfijbe2 days ago2 comments
  • lotfijbe2 days ago

        I built this because I got tired of the 1,000-row limit on existing tools like Mockaroo, and I didn't want to upload my database schemas to the cloud just to generate seed data.
    
        MockBlast is a local-first generator that runs on a $5 VPS using Dockerized Postgres and Next.js.
    
        It supports: PostgreSQL, MySQL, SQLite, MongoDB (native ObjectId/ISODate), JSON, and CSV.
    
        The Technical Details:
    
            Parsing: It uses a regex engine to parse raw CREATE TABLE statements to auto-detect types like UUID, JSONB, and BOOLEAN.
    
            Streaming: To handle 1M+ rows without crashing the browser or server RAM, it uses Web Streams API to pipe generated data row-by-row directly to the response.
    
            Integrity: It performs a topological sort on your schema to generate parent tables first, caching IDs to ensure Foreign Key integrity in child tables.
    
        It generates 10,000 rows for free (no signup required for basic generation).
    
        I'm giving a Lifetime Pro status to the users who want to help me stress-test the streaming architecture and who sign up before 31st January. So grab it fast.
    
        Would love feedback on the SQL parsing logic—it's the hardest part to get right for edge cases.
  • 2 days ago
    undefined