GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — dbm.sqlite proof of concept · Issue #48033 · python/cpython

dbm.sqlite proof of concept #48033

New issue
Copy link
New issue
Copy link
Closed as not planned
Closed as not planned
dbm.sqlite proof of concept#48033
Copy link
Labels
stdlibStandard Library Python modules in the Lib/ directoryStandard Library Python modules in the Lib/ directorytopic-sqlite3type-featureA feature request or enhancementA feature request or enhancement

Description

@smontanaro
smontanaro
opened on Sep 4, 2008
Issue body actions
BPO 3783
Nosy @rhettinger, @doko42, @jcea, @pitrou, @merwok, @florentx, @erlend-aasland
Files
  • sq_dict.py: an alternate sqlite dbm-like interface v.5
  • dbsqlite.py: Fixed len
  • dbdict.py: Non-synchronous DB based on a dict subclass.
  • Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.

    Show more details

    GitHub fields:

    assignee = None
    closed_at = None
    created_at = <Date 2008-09-04.23:57:30.571>
    labels = ['type-feature', 'library']
    title = 'dbm.sqlite proof of concept'
    updated_at = <Date 2021-07-28.20:11:08.117>
    user = 'https://github.com/smontanaro'

    bugs.python.org fields:

    activity = <Date 2021-07-28.20:11:08.117>
    actor = 'erlendaasland'
    assignee = 'none'
    closed = False
    closed_date = None
    closer = None
    components = ['Library (Lib)']
    creation = <Date 2008-09-04.23:57:30.571>
    creator = 'skip.montanaro'
    dependencies = []
    files = ['11602', '12933', '12939']
    hgrepos = []
    issue_num = 3783
    keywords = ['patch']
    message_count = 51.0
    messages = ['72556', '72565', '72566', '72567', '72568', '72569', '72570', '72587', '72595', '72661', '72677', '72719', '72725', '72729', '73012', '73013', '73018', '73020', '73025', '73026', '73027', '73028', '73032', '73034', '73046', '73053', '73054', '73067', '73068', '73070', '73072', '73074', '73077', '73080', '73775', '73800', '79050', '80802', '80803', '80808', '80817', '81109', '81110', '81113', '81155', '81483', '85717', '95492', '95804', '97473', '248835']
    nosy_count = 11.0
    nosy_names = ['rhettinger', 'doko', 'jcea', 'ghaering', 'pitrou', 'erno', 'eric.araujo', 'gregburd', 'flox', 'rute', 'erlendaasland']
    pr_nums = []
    priority = 'low'
    resolution = None
    stage = 'needs patch'
    status = 'open'
    superseder = None
    type = 'enhancement'
    url = 'https://bugs.python.org/issue3783'
    versions = ['Python 3.4']

    Activity

    Next
    1. smontanaro commented on Sep 4, 2008

      @smontanaro
      smontanaro
      on Sep 4, 2008
      ContributorAuthor
      More actions

      Based on recent discussions about ridding Python of bsddb I decided to
      see how hard it would be to implement a barebones dbm.sqlite module.
      Turns out, not very hard.

      No docs. No test cases. Caveat emptor. But I think it can serve as
      at least a proof of concept, maybe as the basis for a new module in
      3.1.

    2. smontanaro
      added
      type-featureA feature request or enhancementA feature request or enhancement
      stdlibStandard Library Python modules in the Lib/ directoryStandard Library Python modules in the Lib/ directory
      on Sep 4, 2008
    3. smontanaro commented on Sep 5, 2008

      @smontanaro
      smontanaro
      on Sep 5, 2008
      ContributorAuthor
      More actions

      Attaching corrected module.

    4. smontanaro commented on Sep 5, 2008

      @smontanaro
      smontanaro
      on Sep 5, 2008
      ContributorAuthor
      More actions

      Attaching test cases based on dumbdbm tests.

    5. smontanaro commented on Sep 5, 2008

      @smontanaro
      smontanaro
      on Sep 5, 2008
      ContributorAuthor
      More actions

      Another slight revision to the module.

    6. smontanaro commented on Sep 5, 2008

      @smontanaro
      smontanaro
      on Sep 5, 2008
      ContributorAuthor
      More actions

      Trivial doc diffs against 3.0b3 doc.

    7. smontanaro commented on Sep 5, 2008

      @smontanaro
      smontanaro
      on Sep 5, 2008
      ContributorAuthor
      More actions

      Another tweak - add values()

    8. smontanaro commented on Sep 5, 2008

      @smontanaro
      smontanaro
      on Sep 5, 2008
      ContributorAuthor
      More actions

      Updated test cases

    9. pitrou commented on Sep 5, 2008

      @pitrou
      pitrou
      on Sep 5, 2008
      Member
      More actions

      It would be more efficient to base keys() on iterkeys() than the
      reverse, IMO.
      Other than that, why not open a branch or at least upload full-fledged
      patch files? :)

    10. smontanaro commented on Sep 5, 2008

      @smontanaro
      smontanaro
      on Sep 5, 2008
      ContributorAuthor
      More actions

      Antoine> It would be more efficient to base keys() on iterkeys() than the
      Antoine> reverse, IMO.

      True. I was just modifying the dumbdbm implementation.

      Antoine> Other than that, why not open a branch or at least upload
      Antoine> full-fledged patch files? :)
      

      Well, I only intended to create the initial proof of concept, but then last
      night I couldn't sleep so I cobbled the test module and docs from the
      existing stuff ... ;-)

      When I get a couple minutes free I'll try and condense it into a more
      suitable form. Probably not until the weekend though.

      Skip

    11. smontanaro commented on Sep 6, 2008

      @smontanaro
      smontanaro
      on Sep 6, 2008
      ContributorAuthor
      More actions

      OK, I made a sandbox project out of it:

      svn+ssh://[email protected]/sandbox/trunk/dbm_sqlite

      Hack away!

    12. smontanaro
      self-assigned this
      on Sep 6, 2008
    13. rhettinger commented on Sep 6, 2008

      @rhettinger
      rhettinger
      on Sep 6, 2008
      Contributor
      More actions

      I would like to see something like this go into 3.0 so that shelves
      don't become useless for Windows users.

    14. josiahcarlson commented on Sep 6, 2008

      @josiahcarlson
      josiahcarlsonmannequin
      on Sep 6, 2008
      Mannequin
      More actions

      Here's an alternate version with most of bsddb's interface intact.

    15. 44 remaining items

    16. pitrou
      added
      type-featureA feature request or enhancementA feature request or enhancement
      on Mar 17, 2010
    17. ghaering commented on Aug 19, 2015

      @ghaering
      ghaeringmannequin
      on Aug 19, 2015
      Mannequin
      More actions

      This wiki page is out of date. It appears that SQlite is now threadsafe by default: http://www.sqlite.org/threadsafe.html

    18. ezio-melotti
      transferred this issue fromon Apr 10, 2022
    19. erlend-aasland commented on Apr 29, 2022

      @erlend-aasland
      erlend-aasland
      on Apr 29, 2022
      Contributor
      More actions

      I would like to try and resurrect this issue using @rhettinger's last submitted code (on bpo). @ambv almost mentioned shelve and sqlite3 in the same sentence in one of his developer-in-residence blog posts last year, so it may be worth it to try and get this up and running. (If not, it will at least be a fun exercise.)

    20. erlend-aasland
      added
      topic-sqlite3
      on May 16, 2022
    21. erlend-aasland
      added this to sqlite3 issueson May 21, 2022
    22. erlend-aasland
      moved this to Decision needed in sqlite3 issueson May 21, 2022
    23. erlend-aasland
      moved this from Decision needed to No status in sqlite3 issueson May 21, 2022
    24. presidento commented on Dec 5, 2022

      @presidento
      presidento
      on Dec 5, 2022
      More actions

      @erlend-aasland do you have any knews about this?

    25. erlend-aasland commented on Dec 29, 2022

      @erlend-aasland
      erlend-aasland
      on Dec 29, 2022
      Contributor
      More actions

      @erlend-aasland do you have any knews about this?

      Nope, and I've been busy with $work. Raymond has created a duplicate issue, though: see #100414

      Reacted by Máté FARKAS
    26. erlend-aasland commented on Jan 2, 2023

      @erlend-aasland
      erlend-aasland
      on Jan 2, 2023
      Contributor
      More actions

      Raymond and I prefer to close this (stale) issue in favour of #100414; if we're going to do this, I think we can benefit from a fresh start.

      Closing this issue as stale and superseded by #100414; please re-open if you disagree.

      Reacted by Máté FARKAS and Skip Montanaro
    27. erlend-aasland
      closed this as not plannedon Jan 2, 2023
    28. github-project-automation
      moved this to Done in sqlite3 issueson Jan 2, 2023
    29. erlend-aasland
      moved this from Done to Discarded in sqlite3 issueson Jan 2, 2023
    30. erlend-aasland commented on Jan 23, 2024

      @erlend-aasland
      erlend-aasland
      on Jan 23, 2024
      Contributor
      More actions

      Just a heads-up; the gh-100414 now has a PR based on a recent patch Raymond posted. Feel free to review it:

      • gh-100414: Add SQLite backend to dbm #114481
    Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

    Metadata

    Metadata

    Assignees

    No one assigned

      Labels

      stdlibStandard Library Python modules in the Lib/ directoryStandard Library Python modules in the Lib/ directorytopic-sqlite3type-featureA feature request or enhancementA feature request or enhancement

      Projects

      • sqlite3 issues
        Status
        Discarded
        Show more project fields

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.