📗
Repo reference
  • README
  • prototypes
    • apis
      • airtable
        • Bulk records inserter
        • Bulk records updater
        • Record deleter
        • Record fetcher
        • Record inserter
        • Record updater
        • Records deleter
        • Records fetcher
        • Records inserter
        • Records inserter (deprecated)
        • Records updater
        • utils
          • First record extractor
          • Record to AirTable record converter
          • Record URL builder
          • Records extractor
          • Records to AirTable records converter
          • Table URL builder
      • AirTable
        • Records deleter
      • dji
        • utils
          • FPV Goggles OSD parser
          • FPV Goggles SRT file to CSV converter
          • FPV Goggles SRT to CSV converter
          • FPV Goggles subtitle entry parser
      • firebase
        • auth
          • rest
            • Anonymous login
            • Email login
            • Email signup
            • Request dispatcher
        • rtdb
          • Query context builder
          • rest
            • Data pusher
            • Data reader
            • Data remover
            • Data updater
            • Data writer
            • Request dispatcher
            • URL builder
      • ga
        • measurement protocol
          • Event params builder
          • Event tracker
          • Page tracker
          • Pageview params builder
      • googlemaps
        • staticmaps
          • Image fetcher
      • mailjet
        • v3.1
          • Email sender
          • Simple email sender request builder
      • nftport
        • utils
          • File URL extractor
          • Metadata extractor
        • v0
          • All chain NFT transactions retriever
          • All chain NFTs retriever
          • Batch minted NFTs retriever
          • Batch NFT transferer
          • Collection contract deployer
          • Contract address finder
          • Counterfeit NFT finder with file
          • Counterfeit NFT finder with token id
          • Counterfeit NFT finder with url
          • Customizable batch NFT minter
          • Customizable NFT minter
          • Deployed product contracts lister
          • Easy minter with file upload
          • Easy minter with URL
          • File uploader
          • IPFS uploads lister
          • Metadata uploader
          • Minted NFT burner
          • Minted NFT details retriever
          • Minted NFT lister
          • Minted NFT updater
          • Multi-chain NFT searcher
          • NFT contract sales stats retriever
          • NFT contracts by owner retriever
          • NFT details retriever
          • NFT transactions by account retriever
          • NFT transactions by contract retriever
          • NFT transactions retriever
          • NFT transferer
          • NFTs by contract retriever
          • NFTs by creator retriever
          • NFTs by owner retriever
          • Product contract deployer
          • Similar NFTs finder with file
          • Similar NFTs finder with url
          • User settings retriever
      • poloniex
        • public
          • 24h volume sampler
          • Chart data fetcher
          • Currencies fetcher
          • Loan orders fetcher
          • Order book fetcher
          • Response error detector
          • Summary sampler
          • Trade history fetcher
      • what3words
        • Coordinates to words
        • Words to coordinates
      • yahoo finance
        • Daily rates getter
        • Historical adjusted closed price & timestamp getter
        • Rates per date converter
        • v8
          • Chart getter
          • Market price sampler
    • binary
      • Chunk builder
      • Joiner
    • blinkstick
      • Color setter
      • pro
        • Colors setter
      • strip
        • Colors setter
    • blockchain
      • ethereum
        • Contract caller
        • Contract deployer
        • Contract deployment logger
        • Contract deployment waiter
        • Contract executor
        • contracts
          • Compile and deploy contract preset
          • Contract preset
          • erc1155
            • ERC1155 abi
            • presets
              • ERC1155PresetMinterPauser
          • erc20
            • presets
              • ERC20PresetFixedSupply deployer
            • token decimals getter
            • Token transferer
          • ERC20
            • Approve
          • erc721
            • ERC721 abi
            • presets
              • ERC721PresetMinterPauserAutoId
        • Contracts compiler
        • demo
          • Demo pool creator
        • pancakeswap
          • Pancakeswap Factory ABI
          • Pancakeswap Factory Deployer
          • Pancakeswap Pair ABI
          • Pancakeswap Router ABI
          • Pancakeswap Router Deployer
          • WBNB Deployer
        • Uniswap
          • v2
            • Core compiler
            • Core source code
            • Factory compiler
            • Factory deployer
            • Init code pair hash requester
            • Liquidities adder
            • Liquidity adder
            • Liquidity adder ETH
            • Liquidity adder token
            • Periphery compiler
            • Periphery source code (instrumented)
            • Router
              • AddLiquidity
              • AddLiquidityETH
            • Router compiler
            • Router deployer
            • WETH addresses
        • Unit formatter
        • Unit parser
      • moralis
        • actions
          • Bulk auto-metadata uploader
          • Bulk auto-metadata uploader (simplified)
          • Bulk image uploader
          • Bulk image uploader (simplified)
          • Folder uploader
          • Image data builder
          • Image metadata builder
        • api v2
          • NFT data getter
          • NFT transfers lister
        • Folder uploader
    • boolean
      • And
      • Condition
      • Equality tester
      • Evaluator
      • Nand
      • Not
      • Or
      • Reverse condition
      • Type tester
    • data
      • array
        • Aggregation iterator
        • All same as expected tester
        • Array to string concatenator
        • Builder
        • Concatenator
        • Contains tester
        • Distinct items filter
        • Emptiness tester
        • Filter
        • First item getter
        • Flattener
        • Has same length tester
        • Item appender
        • Item deleter
        • Item getter
        • Item inserter
        • Item prepender
        • Iteration aggregator
        • Iterator
        • JSON parser
        • Last item getter
        • Length getter
        • Mapper
        • Order reverser
        • Order reverser (mutable)
        • Reducer
        • Repeater
        • Slicer
        • Sorter
        • Splitter
        • Step iterator
        • Step iterator (manual tags)
        • Step mapper
        • Type tester
        • Wrapper
      • csv
        • Dictionary array to csv converter
        • Naive parser
        • utils
          • Double quotes wrapper
          • Record serializer
      • dictionary
        • Builder (key & value)
        • Builder (key-value pairs)
        • Builder (keys & value)
        • Builder (keys & values)
        • Common keys extractor
        • Emptiness tester
        • Filter
        • Has key tester
        • Has keys tester
        • Inner joiner
        • Item deleter
        • Item deleter (mutable)
        • Item getter
        • Item getter with default
        • Item setter
        • Items getter
        • Iterator
        • JSON parser
        • JSON serializer
        • Key-value pairs getter
        • Keys getter
        • Mapper
        • Merger
        • Reducer
        • Repeater
        • Size getter
        • Structure tester
        • Type tester
        • Value parser
        • Value tester
        • Values getter
        • Values getter by keys
        • Values parser
      • Dynamic parser
      • Equality tester (strict)
      • invertible dictionary
        • Item adder
      • Shared store getter
      • Shared store setter
      • Store
      • Store (async)
      • table
        • Column adder
        • Empty row filter
        • Field serializer
        • Inner joiner
        • Unique field indexer
        • utils
          • Fields extractor
      • tree
        • Builder (paths & values)
        • Equality tester
        • Flattener
        • Has path tester
        • Iterator
        • Merger
        • Node getter
        • Node setter
        • Node setter (mutable)
        • Nodes getter
        • Nodes setter
        • Path parser
        • Path serializer
        • Values tester
      • vector
        • Maximum getter
    • db
      • sqlite3
        • Closer
        • Closer (deprecated)
        • Executor
        • Opener
        • Opener (deprecated)
        • Opener-creator
        • Row getter
        • Row iterator
        • Rows getter
        • Rows getter (deprecated)
        • Runner
        • Runner (deprecated)
        • Sqlite3
    • debug
      • Logger
      • Logger (unformatted)
      • Multiplexed event logger
      • Output formatter
      • Unsuccessfull http response logger
    • examples
      • apis
        • firebase
          • rtdb
            • rest
              • Login & query
      • db
        • sqlite3
          • Create, insert, & query
      • io
        • http
          • express
            • Basic server
      • projects
        • JUnit reporter
          • click me
    • flow
      • Aggregator
      • Aggregator (async)
      • Array emptiness fork
      • Debouncer
      • Delayer
      • Demultiplexer
      • Depot
      • Fork
      • Forked aggregator (async)
      • Forwarder
      • Forwarder (double)
      • Forwarder (quadruple)
      • Forwarder (triple)
      • Gate
      • Multiplexer
      • Parameter
      • Parameter with default
      • Queued forwarder
      • Repeater
      • Shifter
      • Splitter
      • Starter
      • Switch
      • Switch (deprecated)
      • Syncer
      • Tag extractor
      • Tag incrementer
      • Tag nester
      • Tag trimmer
      • Throttler
      • utils
        • Burst tester
    • fx
      • yahoo finance
        • Currency converter
    • html
      • XPath value finder
    • io
      • file
        • Binary reader
        • Binary writer
        • Deleter
        • Directory creator
        • Directory lister
        • Directory lister (paths)
        • Directory tester
        • Extension setter
        • File copier
        • File mover
        • File renamer
        • File tester
        • formats
          • srt
            • Entry parser
            • Parser
            • To CSV converter
        • Info getter
        • JSON reader
        • JSON reader (with param)
        • Path builder
        • Path creator
        • Path deleter
        • Path exist tester
        • Path joiner
        • Path parser
        • Path resolver
        • Path tester
        • Paths joiner
        • Text appender
        • Text reader
        • Text writer
      • http
        • Form-data request dispatcher
        • HTML Form POST request dispatcher
        • JSON request dispatcher
        • JSON request dispatcher (deprecated)
        • Request dispatcher
        • Request dispatcher (deprecated)
        • server
          • Endpoint listener
            • Server error checker
          • Error response generator
          • Simplified endpoint listener
          • utils
            • JSON request body parser
            • JSON response builder
            • Query params getter
            • Request authenticator
            • Request timeout handler
            • Response builder
            • Response content type applicator
        • URL search params serializer
        • URL-encoded request dispatcher
        • utils
          • API key inserter
          • Authorization inserter
          • Basic authorization inserter
          • Bearer token checker
          • Bearer token inserter
          • Body-less request builder
          • Content type inserter
          • File form field header builder
          • Form field data to chunk builder
          • Form field header builder
          • Form field header to chunk builder
          • Form request body builder
          • Form request builder
          • JSON request builder
          • JSON response error detector
          • Multi param appender
          • Multi params builder
          • Multipart content type inserter
          • Query param appender
          • Query param builder
          • Query param serializer
          • Query params flattener
          • Query string builder
          • Request body getter
          • Request builder
          • Response error detector
          • Response fork by status
          • Response header merger
          • Response splitter
          • Response success detector
          • Single param appender
          • URL query appender
          • URL-encoded request builder
      • stdio
        • Line writer
        • Line writer (conditional)
        • Text writer
    • json
      • Parser
      • Serializer
    • number
      • Abs
      • Adder
      • Ceiling
      • Counter
      • Differ
      • Divider
      • Equality tester
      • Even tester
      • Floor
      • Greater or equal than tester
      • Greater than tester
      • Less or equal than tester
      • Less than tester
      • Max picker
      • Min picker
      • Modulo
      • Multiplier
      • Odd tester
      • Parser
      • Power
      • Random generator
      • Rounder
      • Stringifier
      • Subtractor
      • Type tester
    • os
      • shell
        • Open file in default app
    • scripting
      • Action finished tester
      • Action maintainer
      • actions
        • Command runner
        • Directory lister
        • Dotenv appender
        • Express endpoint creator (simplified)
        • Express route creator
        • Express server starter (simplified)
        • File appender
        • File creator
        • Folder creator
        • Matched command runner
        • One-time action template
        • Paths joiner
        • Wait
      • One-time action result maintainer
      • Params copier
      • Starter
      • State writer
      • Status to params mapping creator
    • sdk
      • AWS
        • S3
        • S3 authenticator
        • S3 uploader
      • google
        • drive
          • Authenticated spreadsheet creator
          • Authenticator
          • Spreadsheet creator
        • Drive
          • File creator
        • spreadsheet
          • Authenticated spreadsheet value updater
          • Authenticator
          • Spreadsheet creator
          • Spreadsheet value updater
        • Spreadsheet
      • web3
        • eth
          • Transaction receipt getter
    • sdks
      • ccxt
        • private
          • Balance fetcher
          • Closed orders fetcher
          • My trades fetcher
          • Open orders fetcher
          • Order canceller
          • Order creator
          • Order fetcher
          • Orders fetcher
        • public
          • Exchange status fetcher
          • Markets loader
          • Orderbook fetcher
          • Orderbooks fetcher
          • Ticker fetcher
          • Tickers fetcher
        • utils
          • ccxt
      • expressjs
        • Express
        • JSON listener
        • Listener
        • Middleware applicator
        • Middlewares applicator
        • Route handler
        • Text listener
        • utils
          • Content type middleware applicator
          • DELETE handler
          • GET handler
          • PATCH handler
          • POST handler
          • PUT handler
    • streaming
      • Moving buffer
      • Time-based moving buffer
    • string
      • Base64 Decoder
      • Base64 Encoder
      • Concatenator
      • Contains tester
      • Custom template filler
      • Emptiness tester
      • Equality tester
      • Global regex replacer
      • Handlebar style template filler
      • Joiner
      • Length getter
      • Line splitter
      • Lowercaser
      • Regex matcher
      • Regex matcher - DEPRECATED
      • Regex splitter
      • Regex tester
      • Splitter
      • Template filler
      • Trimmer
      • Type tester
      • Uppercaser
      • URI component encoder
      • URL formatter
    • system
      • Command runner
      • Environment variable getter
      • Environment variable getter with fallback
      • Environment variables getter
      • Environment variables getter with fallback
      • Matched command runner
      • Simple command runner
      • Timer
      • utils
        • Command success tester
    • testing
      • Assertion builder
      • Assertion duration getter
      • Case decorator
      • Current timestamp inserter
      • Description inserter
      • Duration inserter
      • reporters
        • junit
          • Assertion description splitter
          • Assertion inserter
          • Assertion recorder
          • HTML report generator (from file)
          • HTML report generator (from xml)
          • Report context builder
          • Reporter
          • Serializer
          • Visualizer
    • time
      • Timestamp getter
    • tutorials
      • boolean
        • Condition example
      • data
        • array
          • Filter example
          • Iterator (parallel filter) example
          • Iterator example
          • Reducer example
        • Builder (array) example
        • Builder (dictionary) example
        • Concatenator (array) example
        • Deleter (array) example
        • Deleter (dictionary) example
        • Filter (emps by dept) example
        • Filter (query) example
        • Getter (array) example
        • Getter (dictionary) example
        • JSON parser example
        • Mapper (emps to dept) example
        • Mapper (get emp names) example
        • Mapper (join) example
        • Mapper (query) example
        • Reducer (query) example
        • Reducer (sum of emp salary) example
        • Serializer example
        • Setter (array) example
        • Setter (dictionary) example
        • Splitter (split dicionary) example
        • Syncer (build dictionary) example
        • Template filler example
      • flow
        • Fork example
        • Gate example
        • Polling example
        • Repeater (with mapper) example
        • Repeater example
        • Syncer & splitter example
Powered by GitBook
On this page
  1. prototypes
  2. examples

db

sqlite3
PreviousLogin & queryNextsqlite3