Pydb

Data

embedded database

SHOW HN2017

Pydb

a lightweight database with Python syntax queries, using ZeroMQ

github.com

#python database#zeromq#embedded database#python queries

130points
31comments
#321of 2,242 in 2017
Top 15%of 2017 by points

How HN took it

DebatedReal support and real criticism

5 positive, 7 neutral or asking, 0 mixed, 5 critical, out of 17 comments about the project. Thread score -0.01.

Idea: 3 for, 1 againstDesign: 1 for, 1 againstExecution: 0 for, 1 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Useful for small Python scripts and personal dashboards

    From 2 comments
    • It might not hold up to heavy use cases, but I can already imagine a bunch of ways this would make my life easier (I use Python scripts to handle a bunch of social media stuff…
      jmduke on HN
    • Seems like this could be a good idea for small personal or temporary dashboards. Especially those with viz powered by packages that work natively with Python data structures like…
      vapemaster on HN
  • Interesting idea, a better shelve

    From 2 comments
    • Looks like a better shelve https://docs.python.org/3.6/library/shelve.html
      d0vs on HN
    • Hmm this is pretty interesting. Going to check this out.
      gigatexal on HN

Objections

  • Vanilla ZeroMQ gives no reliable delivery guarantees

    From 1 comment
    • vanilla zeromq is a pretty bad choice for any database. zmq explicitly makes no guarantees about reliable delivery, so losing random inserts or queries here or there would be…
      toumorokoshi on HN
  • Name clashes with the existing pydb debugger package on PyPI

    From 1 comment
    • There's already an (albeit deprecated) debugger package called pydb (http://bashdb.sourceforge.net/pydb/). It would be good to choose a different name for this, most importantly…
      goerz on HN
  • Unclear what advantage ZeroMQ adds

    From 1 comment
    • What's the purpose/gain of layering ZMQ into this? I read the architecture bit but I'm still unclear as to what benefit this brings. I guess it allows for multiple clients to use…
      daenney on HN
  • Why use this over SQLite

    From 1 comment

Requests

  • Way to start the server from within the client

    From 1 comment
    • It might not hold up to heavy use cases, but I can already imagine a bunch of ways this would make my life easier (I use Python scripts to handle a bunch of social media stuff…
      jmduke on HN
  • Proper packaging for pip install

    From 2 comments
    • You could use `-e git://github.com/asrp/undoable` in requirements.txt to save some steps.
      jlpdyh on HN
    • Oh, thanks, I wasn't aware of that flag. Though for the moment ``` pip install -e git://github.com/asrp/undoable#egg=undoable ``` tells me `setup.py` doesn't exist (because it…
      asrp on HN

Questions

  • Why ZeroMQ is used and what it gains

    From 1 comment
    • What's the purpose/gain of layering ZMQ into this? I read the architecture bit but I'm still unclear as to what benefit this brings. I guess it allows for multiple clients to use…
      daenney on HN
  • How nesting is handled

    From 1 comment
    • Interesting! I will have to take a deeper look at BlitzDB. I don't know much about MongoDB (so probably wouldn't be a good maintainer) but the sample code looks good. I can't…
      asrp on HN

Alternatives named

  • BlitzDB

    From 1 comment
    • I wrote a similar library -BlitzDB- a while ago: https://github.com/adewes/blitzdb It's a pure Python database engine with a MongoDB-like query engine and support for three…
      ThePhysicist on HN
  • ZODB

    From 1 comment
  • TinyDB

    From 1 comment
  • Python shelve

    From 1 comment
    • Looks like a better shelve https://docs.python.org/3.6/library/shelve.html
      d0vs on HN
  • pyDAL

    From 1 comment
    • The syntax reminds me of PyDal: https://pypi.python.org/pypi/pyDAL http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Shortcuts
      MeteorMarc on HN
  • SQLite

    From 1 comment

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/13506670)