soci VS sparkmagic

Compare soci vs sparkmagic and see what are their differences.

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
soci sparkmagic
3 4
1,338 1,282
0.8% 0.3%
8.7 7.8
9 days ago 8 days ago
C++ Python
Boost Software License 1.0 GNU General Public License v3.0 or later
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

soci

Posts with mentions or reviews of soci. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-02-09.

sparkmagic

Posts with mentions or reviews of sparkmagic. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-06-05.
  • Doing ML works in AWS. Need help installing cartopy
    2 projects | /r/aws | 5 Jun 2023
    Please file an issue at https://github.com/jupyter-incubator/sparkmagic
  • Ask HN: Who's an open source maintainer/project that needs sponsorship or help?
    10 projects | news.ycombinator.com | 28 Feb 2023
    I maintain several open source projects, most notably:

    Sparkmagic (https://github.com/jupyter-incubator/sparkmagic)

    Sparkmagic provides jupyter magics and kernels for working with remote Spark clusters. It's used by thousands of developers and companies like Pinterest, Amazon, more!

    I've been maintaining for the past few years and would love help!

    KSOPS (https://github.com/viaduct-ai/kustomize-sops)

    KSOPS, or kustomize-SOPS, is a kustomize KRM exec plugin for SOPS encrypted resources. KSOPS can be used to decrypt any Kubernetes resource, but is most commonly used to decrypt encrypted Kubernetes Secrets and ConfigMaps. As a kustomize plugin, KSOPS allows you to manage, build, and apply encrypted manifests the same way you manage the rest of your Kubernetes manifests.

    KSOPS is the most popular kustomize plugin and I'd love help maintaining and improving it from out GitOps fanatics.

  • Spark is lit once again
    6 projects | dev.to | 29 Oct 2021
    Things get a bit more complicated on interactive sessions. We've created Sparkmagic compatible REST API so that Sparkmagic kernel could communicate with Lighter the same way as it does with Apache Livy. When a user creates an interactive session Lighter server submits a custom PySpark application which contains an infinite loop which constantly checks for new commands to be executed. Each Sparkmagic command is saved on Java collection, retrieved by the PySpark application through Py4J Gateway and executed.
  • An SQL Solution for Jupyter
    6 projects | news.ycombinator.com | 9 Feb 2021
    Jupyter would be even better if it supported the seamless combination of Python and SQL code cells.

    My notebook code typically involves a data prep stage with querying a SQL database, then downloading into Python for more complex analysis, ML modelling, integration with external data sources, etc. So the notebook has a Python kernel with SQL usually as embedded """-quoted strings.

    Does anyone have a solution to treating selected code cells as SQL - with SQL highlighting and tooltips - exposed as string variables to the Python code?

    Sparkmagic [1] does part of this for Python/SQL/Spark interoperability, but as far as I recall, doesn't support SQL syntax highlighting.

    [1] https://github.com/jupyter-incubator/sparkmagic

What are some alternatives?

When comparing soci and sparkmagic you can also consider the following projects:

sqlite_modern_cpp - The C++14 wrapper around sqlite library

lighter - REST API for Apache Spark on K8S or YARN

SQLite - Unofficial git mirror of SQLite sources (see link for build instructions)

Jupyter Scala - A Scala kernel for Jupyter

TileDB - The Universal Storage Engine

Apache Spark - Apache Spark - A unified analytics engine for large-scale data processing

turbodbc - Turbodbc is a Python module to access relational databases via the Open Database Connectivity (ODBC) interface. The module complies with the Python Database API Specification 2.0.

nbmake - 📝 Pytest plugin for testing notebooks

tntdb

nbgrader - A system for assigning and grading notebooks

LevelDB - LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.

xeus-sql - Jupyter kernel for SQL databases