Welcome to the project page for pyDaSSQLiteMan (Python Data and SQLite Manager). This application is a Python Tkinter application designed to enable easy SQLite database file manipulation, and an easy method to run SQL styled queries on CSV files.

If you're not downloading the pre-compiled executable you will need Python to run this app. You can download it from http://www.python.org/ . I'd recommend something after version 3. Testing has been Windows based.

SQLite is a free database format released into the public domain. See http://www.sqlite.org/

Please check out the Wiki Home page https://sourceforge.net/p/pycsvdb/wiki/Home/ and the General Help page (https://sourceforge.net/p/pycsvdb/wiki/General%20Help/) to find extra information and help.

Please check out the Wiki Home page for an introduction.

Features

  • SQLite management with SQL
  • Import and Export Delimited files (CSV, PSV etc)
  • View simple Spatial objects in WKT, WKB, Spatialite, and Geopackage (all experimental)
  • Query data using SQL
  • Pre-built method for importing the Australian Georeferenced National Address File (G-NAF)

Project Samples

Main SQL editor window Display simple geometry objects Import delimited files Export tables and views to delimited files

Project Activity

See All Activity >

Categories

Database, Front-Ends, CSV

License

BSD License

Follow pyDaSSQLiteMan

pyDaSSQLiteMan Web Site

Other Useful Business Software
Full-stack observability with actually useful AI | Grafana Cloud Icon
Full-stack observability with actually useful AI | Grafana Cloud

Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.

Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.
Create free account
Rate This Project
Login To Rate This Project

User Ratings

3.0 out of 5 stars
★★★★★
★★★★
★★★
★★
★
1
0
0
0
1
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5

User Reviews

Filter Reviews:
All
  • s-r-grass Posted 2020-05-24
    What does the program do in general? The program is generally incomprehensible. I used a lot of programs for working with SQLite, since I have a database in it. How to connect the database is not convenient at all, why by default press the "use memory" button? Who needs it, they will put it themselves. If you want someone to need the program, make it so that it is convenient for others, and not just you. Well, I indicated the base, I select the table on the left and click the "Run" button, but the program writes an error that I can not even copy. Do the processing of pressing CTRL + C or add the context menu and copy the item there. I switched to pyqt, there by default out of the box all the amenities familiar to users work out of the box.
  • adepoch Posted 2018-08-05
    This has enabled me to query Geopackages and other SQL in amazingly flexible ways. I have even been able to analyse CSV files quickly and easily by importing them and running SQL queries over them.
Read more reviews >

Additional Project Details

Intended Audience

Architects, Developers, Government, Management, System Administrators

User Interface

Tk

Programming Language

Python

Database Environment

Python Database API, SQL-based, SQLite

Related Categories

Python Database Software, Python Front-Ends, Python CSV Software

Registered

2012-08-25
Report inappropriate content