- Sqliteman Portable - create/design/edit
http://portableapps.com/apps/developmen ... n-portable
Sqlite Database Browser Portable - interface for developer / admin
http://portableapps.com/apps/developmen ... r_portable
There's of course always been Apache OpenOffice/LibreOffice Base, but I never seemed to make it very far with that program.
Two Sqlite programs: Sqliteman and Sqlite Database Browser
Two Sqlite programs: Sqliteman and Sqlite Database Browser
Back when I was doing a lot of database work, I was annoyed that open source databases (mysql, postgres, firebird) were all the rage, but there were so few open viewers/managers, much less portable ones. PortableApps offered a query tool/viewer a while back that worked pretty well, but not an open one. Fortunately there are now two available from PortableApps, including one that allows some database creation that would work as an amazing "intro to databases" tool:
Last edited by webfork on Mon Sep 10, 2012 5:15 pm, edited 1 time in total.
Reason: (fixed links -- thanks JohnW)
Reason: (fixed links -- thanks JohnW)
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
Anyone knows what's the most suited and popular programming language to develop a fairly basic database desktop app using sqlite (a network app to be used in say 2 or 3 PCs), I used to work a lot with Visual FoxPro in years gone but I guess life goes on.
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
I have used Sqlite Database Browser Portable for SQLite databases (I was developing in Android), though recently started to use HeidiSQL -> TPFC, as the whole %APPDATA% out weighs the functionality it provides. I am connecting to an SQL Server 2012 database, which is awesome, as I didn't have to install SQL Server Express.
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
You're essentially asking "what's the most suited and popular programming language to develop a desktop app". SQLite has bindings for a lot of languages. The "desktop app" bit is the harder part.xor wrote:Anyone knows what's the most suited and popular programming language to develop a fairly basic database desktop app using sqlite (a network app to be used in say 2 or 3 PCs), I used to work a lot with Visual FoxPro in years gone but I guess life goes on.
I think the most popular language for new desktop apps is C#. C++ and Delphi are fairly popular as well.
My YouTube channel | Release date of my 13th playlist: August 24, 2020
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
Thanks for all suggestions although I'm still feeling thoughtful. I was thinking of sqlite as a backend for a mini POS app due to simplicity (high-end databases are for enterprise solutions) and I'm kind of Trying to figure out how to build a convenient front-end to manipulate, store, query, search that data (records), pretty the same as mysql+php in a shopping cart web page. I never felt comfortable with Visual basic + access because being Visual FoxPro a modern form of Clipper + DBase it was a natural database development monster.
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
AutoIt? But if guinness haven't recommended it I won't dare to do
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
I would recommend C# for desktop these days.tproli wrote:AutoIt? But if guinness haven't recommended it I won't dare to do
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
Bruce Lee telling me to learn boxing instead of Jet-Kune-Do?guinness wrote:I would recommend C# for desktop these days.tproli wrote:AutoIt? But if guinness haven't recommended it I won't dare to do
@guiness I'm not very familiar with the C languages although I'll find some time to take a look at their power and feeling (and to figure out an editor, IDE, compiler, license, efc)
@tproli It's OK to dare, AutoIt is something I have tried a bit before and I liked what I felt and achieved, in the end any language is good as long as the result is satisfactory.
Now, I have always wondered why to move to the next record in a table has to be either a pain or a delight:
e.g.
VB: Data1.Recordset.MoveNext
VFoxPro: skip
That's the kind of stuff that makes a difference, I guess that's why AutoIt is widely used, Javascript is a standard and PHP is so loved.
Anyway, for me getting to hear from your opinions that get me learning from the right people that point me in the right direction is ... an honor.
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
@xor I've used Delphi for ages and now I use VS and C# at work. .net framework is very powerful and development with Visual Studio is a joy (specially with resharper). There are express editions of it but there is also an open-source alternative called SharpDevelop (http://www.icsharpcode.net/opensource/sd/) if you wish to try.
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
ReSharper is awesome. I would also recommend SharpDevelop for those who can't afford VS2013 or don't have a student license. SharpDevelop also includes some refactoring hints as well.
Re: Two Sqlite programs: Sqliteman and Sqlite Database Brows
Thankyou @Ozok and @guiness, #develop looks and feels quite familiar to me and is definitely a very good option, the more I read about what you guys use, like and know about anything regarding Development the more my mind gets open and the more I realize how professional you guys are as well as of a high quality of human beings.ozok wrote:@xor I've used Delphi for ages and now I use VS and C# at work. .net framework is very powerful and development with Visual Studio is a joy (specially with resharper). There are express editions of it but there is also an open-source alternative called SharpDevelop (http://www.icsharpcode.net/opensource/sd/) if you wish to try.
Re: Sqlite programs...
Topic update: upstream Sqlite Database Browser AKA DB Browser for SQLite v3.11.2 released 2019-04-03 (changelog at https://github.com/sqlitebrowser/sqlitebrowser/releases).
PortableApps.com version is in sync: currently there's v3.11.2 Rev 2 at portableapps.com /apps/development/sqlite_database_browser_portable.
Sqliteman development appears to have stalled somewhere around 2011 -- see https://sourceforge.net /projects/sqliteman/files/sqliteman/ and http://sqliteman.yarpen.cz/.
Related programs already included in TPFC's database:
PortableApps.com version is in sync: currently there's v3.11.2 Rev 2 at portableapps.com /apps/development/sqlite_database_browser_portable.
Sqliteman development appears to have stalled somewhere around 2011 -- see https://sourceforge.net /projects/sqliteman/files/sqliteman/ and http://sqliteman.yarpen.cz/.
Related programs already included in TPFC's database:
- Database .NET -- https://www.portablefreeware.com/?id=2417
- Database Browser -- https://www.portablefreeware.com/?id=1915
- SQLiteSpy -- https://www.portablefreeware.com/?id=1165