Sqlite3 with exe GUI  [SOLVED]

This forum is reserved for everything you want to talk about. It could be about programming, opinions, open source programs, development in general, or just cool stuff to share!
issac_n
In need of some credit
In need of some credit
Posts: 3
Joined: Fri Oct 06, 2017 3:45 am

Sqlite3 with exe GUI

Postby issac_n » Fri Oct 06, 2017 4:25 am

Hi all,
i am newbie in coding and I am looking for suitable GUI for sqlite3, i saw some sqlite3 works with exe GUI interface, but how does it work?
my objective is to performs some DB update/calculation with txt/xlsx/csv input and therefore need a GUI input.

User avatar
doublemax
Moderator
Moderator
Posts: 11527
Joined: Fri Apr 21, 2006 8:03 pm
Location: $FCE2

Re: Sqlite3 with exe GUI

Postby doublemax » Fri Oct 06, 2017 7:51 am

Did you try Googling for "sqlite gui"? There are actually quite a few.
Use the source, Luke!

issac_n
In need of some credit
In need of some credit
Posts: 3
Joined: Fri Oct 06, 2017 3:45 am

Re: Sqlite3 with exe GUI

Postby issac_n » Fri Oct 06, 2017 8:00 am

I am not looking for some thing like SQLiteStudio Manager ,but i am looking for something that can create exe GUI interface and interact with Sqlite at background. the exe GUI is for import txt/csv/xlsx file.

User avatar
doublemax
Moderator
Moderator
Posts: 11527
Joined: Fri Apr 21, 2006 8:03 pm
Location: $FCE2

Re: Sqlite3 with exe GUI

Postby doublemax » Fri Oct 06, 2017 8:42 am

You can use wxWIdgets to build a GUI application that uses sqlite, the easiest way would be with wxSQLite3.
https://github.com/utelle/wxsqlite3

But unfortunately there is no easy "connector" class that just connects a database to a gui control like a wxGrid, wxDataViewCtrl or wxListCtrl and automatically displays its content. This is something you'd have to code yourself.
Use the source, Luke!

issac_n
In need of some credit
In need of some credit
Posts: 3
Joined: Fri Oct 06, 2017 3:45 am

Re: Sqlite3 with exe GUI

Postby issac_n » Fri Oct 06, 2017 11:00 am

firstly thanks for reply, i just found other key word like Tkinter and wxPython, em.. now come to next question ,
which one is the easier one for beginner like me? wxSqlite3, Tkinter or wxPython?
my objective is still the same, simple input such as xls,txt, csv and some basic calculation with Sqlite3 , and with exe format

User avatar
doublemax
Moderator
Moderator
Posts: 11527
Joined: Fri Apr 21, 2006 8:03 pm
Location: $FCE2

Re: Sqlite3 with exe GUI  [SOLVED]

Postby doublemax » Fri Oct 06, 2017 11:19 am

wxSQLite3 is just a library for wxWidgets. You'd use that if you want to program in C++
wxPython uses Python, if that's your preferred programming language.
I don't know Tkinter, but it seems like it's an alternative to wxPython.
Use the source, Luke!


Return to “Open Discussion”

Who is online

Users browsing this forum: No registered users and 2 guests