Exploring Python Data Jobs with Space and Time

Jack R. Mitchell

If you’ve been following developments in Space and Time, you may have heard about our recent achievement—the introduction of a Zero-Knowledge (ZK) proof for SQL. This Proof of SQL is a significant advancement, allowing smart contracts to securely process data using SQL, which has promising implications for blockchain technology.

Photo by Shubham's Web3 on Unsplash

While SQL is a robust tool, it doesn’t cover all business use cases. To address this gap, Chainlink introduced Chainlink Functions, enabling JavaScript to run redundantly on Chainlink nodes, facilitating the execution of fast-running scripts.

The Need for Long-Running Python Jobs in Web3: Despite these developments, a specific set of use cases remained unaddressed in the Web3 landscape: long-running Python jobs. Many businesses and developers within Space and Time extensively use Python for data-related tasks. Recognizing this, Space and Time set out to address two key challenges. First, Space and Time aimed to enable users to utilize Python for data extraction, transformation, and loading into Space and Time without the need for extensive coding. Second, Space and Time sought to establish a cryptographic connection between Python jobs and smart contracts to ensure security. We are pleased to introduce Space and Time Python Data Jobs, currently available in beta on the Space and Time Studio.

Streamlining Data Ingestion: Python Data Jobs simplify the process of importing data into Space and Time from various sources without requiring coding skills. Earlier this year, Space and Time introduced AI SQL, a service powered by OpenAI, enabling users to create natural language prompts converted into SQL queries.

Space and Time is excited to announce that Houston, the AI chatbot in the Space and Time Studio, can now generate straightforward ETL (Extract, Transform, Load) scripts. These scripts can extract data from Web2 databases or Web3 decentralized storage platforms, perform transformations, and load the data into Space and Time seamlessly.

Houston takes care of tasks such as connecting to databases like PostgreSQL, Snowflake, or IPFS, understanding database structures, data transformation, and efficient loading. What used to be a time-consuming and costly Python-driven process can now be accomplished with natural language commands in a single step.

Efficient Data Retrieval and Smart Contract Integration: Python Data Jobs also facilitate data extraction from Space and Time, processing, and secure transmission to smart contracts. The challenge in Web3 has been managing long-running Python jobs that may take substantial time to execute.

For example, a script calculating the probability of BTC staying above $40k for the year involves data capture, processing, and complex Python simulations, taking around 20 seconds. Ensuring the tamperproof nature of such operations when connected to smart contracts requires an innovative approach.

Throughout the Python Data Jobs beta phase, Space and Time is developing a ZK (Zero-Knowledge) proof for Python, enhancing real-time security. Currently, an optimistic security approach is employed, where the script’s inputs, outputs, and code are hashed onto a major chain for a single execution. In case of unexpected outcomes, users can request a proof, and Space and Time cryptographically verifies the execution. This approach replaces real-time redundant computation with a tamperproof audit trail, incentivizing node operators to maintain execution integrity.

Simplified Database Migrations: Houston simplifies database migrations by generating Python scripts based on user requirements. Users can specify the migration they want to perform, grant access to the source database, and Houston utilizes a prompt-to-SQL framework to retrieve database information. For example, if you instruct Houston to “create a Python script to load my Snowflake data into Space and Time,” it will generate a Python script that queries Snowflake, retrieves data, determines the schema, and replicates it in one efficient operation.

Use Cases:

  • Truflation can efficiently process and prepare large volumes of real-time inflation data from various sources for on-chain exposure via oracles using Python Data Jobs.
  • dClimate can automate the extraction and transformation of weather data from multiple sources, loading it into IPFS, and streamlining the process with Python Data Jobs.

Complex Calculations for DeFi: Python Data Jobs empowers smart contracts to perform complex off-chain computations in a tamperproof manner, enabling more sophisticated business logic in DeFi protocols. This includes forecasting coin performance based on market conditions and executing calculations for options and futures pricing.

Getting Started: You can start using Python Data Jobs with Houston on the Space and Time Studio. To celebrate the beta release of our new product, they offer Python Data Jobs for free to all users for one month.

The subject matter and the content of this article are solely the views of the author. FinanceFeeds does not bear any legal responsibility for the content of this article and they do not reflect the viewpoint of FinanceFeeds or its editorial staff.

  • Read this next

    Technical Analysis

    FTSE 100 index Technical Analysis Report 20 February, 2024

    The FTSE 100 index is likely to fall to support level 7600.00 after reversing from resistance level 7750.00.

    Retail FX

    Afterprime enhances trade reporting with PrimeXM and TRAction

    “This collaboration has made setting up EMIR and MIFIR reporting for our CySEC entity a breeze, allowing us to maintain our focus on providing best-in-class pricing and top-notch customer service.”

    Market News

    US Market Stocks See a Dip Ahead of FOMC Minutes Announcement

    As the financial world eagerly awaits the release of the Federal Open Market Committee (FOMC) meeting minutes scheduled for today, the S&P 500 index begins trading slightly lower, marking a subtle shift in market sentiment following a prolonged rally.


    Adaptive proves that “the future of finance is in the cloud”

    “While workloads have migrated to the cloud over the past decade, some have doubted whether its latency and fault tolerance can match that of on-premises solutions – our joint testing on Google Cloud, proves that this is the case.”

    Retail FX

    Axi Select offers live trading amid “end of demo account prop firm model”

    “We genuinely empathize with the thousands of talented traders who will now be denied access to their allocated funds, and we encourage anyone using the demo trading registration model to question whether their prop firm partner will be able to continue as an ongoing concern given recent events. Unfortunately, this could be the beginning of the end for the demo account prop firm model.”

    Digital Assets

    Celsius founder Mashinsky agrees to shared lawyers with Sam Bankman-Fried

    Former Celsius CEO Alex Mashinsky has addressed potential conflicts of interest in his legal representation during a brief hearing in a New York courtroom.

    Digital Assets

    Sam Bankman-Fried captured in first jail photo

    Sam Bankman-Fried, the once-billionaire founder of FTX, has been spotted looking quite different with a new beard and a slimmer figure in a photo that’s been making rounds, reportedly taken inside New York’s Metropolitan Detention Centre.

    Market News

    Bitcoin stalls at $53,000 level, Ethereum reaches $3,000

    Bitcoin (BTC) faced renewed resistance at the crucial $53,000 level on Tuesday, indicating that the primary cryptocurrency is likely to continue consolidating before making its next decisive move.

    Digital Assets

    UK targets new laws for stablecoins and crypto staking within six months

    The United Kingdom is gearing up to enact fresh legislation regulating stablecoins and crypto staking within the next six months.