OctoSQL Reviews

FastAPI Reviews

OctoSQL mentions (22)

• Analyzing multi-gigabyte JSON files locally

  OctoSQL[0] or DuckDB[1] will most likely be much simpler, while going through 10 GB of JSON in a couple seconds at most. Disclaimer: author of OctoSQL [0]: https://github.com/cube2222/octosql. - Source: Hacker News / over 1 year ago

• DuckDB: Querying JSON files as if they were tables

  This is really cool! With their Postgres scanner[0] you can now easily query multiple datasources using SQL and join between them (i.e. Postgres table with JSON file). Something I strived to build with OctoSQL[1] before. It's amazing to see how quickly DuckDB is adding new features. Not a huge fan of C++, which is right now used for authoring extensions, it'd be really cool if somebody implemented a Rust extension... - Source: Hacker News / over 1 year ago

• Show HN: ClickHouse-local – a small tool for serverless data analytics

  Congrats on the Show HN! It's great to see more tools in this area (querying data from various sources in-place) and the Lambda use case is a really cool idea! I've recently done a bunch of benchmarking, including ClickHouse Local and the usage was straightforward, with everything working as it's supposed to. Just to comment on the performance area though, one area I think ClickHouse could still possibly improve... - Source: Hacker News / over 1 year ago

• Command-line data analytics made easy

  SPyQL is really cool and its design is very smart, with it being able to leverage normal Python functions! As far as similar tools go, I recommend taking a look at DataFusion[0], dsq[1], and OctoSQL[2]. DataFusion is a very (very very) fast command-line SQL engine but with limited support for data formats. Dsq is based on SQLite which means it has to load data into SQLite first, but then gives you the whole breath... - Source: Hacker News / over 1 year ago

• Steampipe – Select * from Cloud;

  To add somewhat of a counterpoint to the other response, I've tried the Steampipe CSV plugin and got 50x slower performance vs OctoSQL[0], which is itself 5x slower than something like DataFusion[1]. The CSV plugin doesn't contact any external API's so it should be a good benchmark of the plugin architecture, though it might just not be optimized yet. That said, I don't imagine this ever being a bottleneck for the... - Source: Hacker News / over 1 year ago

FastAPI mentions (240)

• How to Deploy your FastAPI Backend with PostgreSQL Database to Render

  FastAPI is a popular Python backend web development framework. Many Python developers use FastAPI to built Application Programming Interfaces (APIs) and connect other backend infrastructure such as databases. FastAPI is suitable for API design for several reasons:. - Source: dev.to / about 17 hours ago

• Essential Deep Learning Checklist: Best Practices Unveiled

  How to Accomplish: Create a simple interface (CLI or GUI) where users can input an image, and the script processes and displays the model's prediction. For a CLI, use argparse to handle input arguments. For a GUI, consider libraries like Tkinter or web-based interfaces using FastAPI or Flask. The script should perform necessary preprocessing, invoke the model prediction, and present the results clearly, such as... - Source: dev.to / 6 days ago

• Super-charging Django: Tips & Tricks

  Consider integrating Django with FastAPI for asynchronous endpoints if your application needs high-performance, non-blocking I/O operations. - Source: dev.to / 4 days ago

• Documenting my pin collection with Segment Anything: Part 3

  FastAPI: A web framework for building APIs (and web pages). It is used as the backbone of the application to handle web requests, routing, and server logic, and orchestrates the overall API structure. Although not used here, FastAPI provides robust features such as data validation, serialisation, and asynchronous request handling. - Source: dev.to / 6 days ago

• Setting up Fast API in IIS and run APIs in Python

  This article will show you how to setup an API written in Python using an amazing framework called FastAPI. This article is an introduction on how to use the framework, I blog later on more advanced use cases. - Source: dev.to / 23 days ago