LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 08-07-2017, 08:09 AM   #1
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 8,444
Blog Entries: 4

Rep: Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896
I need to build a database front-end (non-web) application ... quickly


I need to build an application (not a web-site) that will be the front-end to a MySQL database and it should contain the usual suspects: forms and reports.

Do not ... ... talk to me about OpenOffice/LibreOffice Base or Access2Base!

I am envisioning a Java application which uses XML to describe the layout of pages and screens.

If you have a recommendation based on personal experience, I am anxious to hear from you. I am, of course, as thoroughly-experienced in programming as anyone could be, but I don't have (further) time to waste.

Last edited by sundialsvcs; 08-07-2017 at 08:12 AM.
 
Old 08-08-2017, 07:39 AM   #2
MensaWater
LQ Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, CoreOS, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 6,936
Blog Entries: 14

Rep: Reputation: 1160Reputation: 1160Reputation: 1160Reputation: 1160Reputation: 1160Reputation: 1160Reputation: 1160Reputation: 1160Reputation: 1160
Since no one else replied and I'm not really a programmer I didn't before now.

Yesterday I searched for open source form builders for MySQL and found this one:
https://forums.mysql.com/read.php?52,631550,631550

That seems like it might be a good place to start.
 
Old 08-08-2017, 07:52 AM   #3
schneidz
LQ Guru
 
Registered: May 2005
Location: boston, usa
Distribution: fc-15/ fc-20-live-usb/ aix
Posts: 5,143

Rep: Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877
since you describe quick-and-dirty, maybe calling the mysql queries via bash and presenting the results via zenity forms.
 
Old 08-08-2017, 08:03 AM   #4
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 8,444
Blog Entries: 4

Original Poster
Rep: Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896
Quote:
Originally Posted by schneidz View Post
since you describe quick-and-dirty, maybe calling the mysql queries via bash and presenting the results via zenity forms.
No, I don't mean that "dirty," nor "dirty" at all. Bash is quite out of the question. (I don't do any real-programming in Bash ... and wouldn't recommend that anyone else do so, either.)

What I need are ... switchboards, forms, and reports. In the form of a stand-alone application not a website. Yesterday.

OpenOffice and its brethren were an utter and complete failure / waste-of-time, even with "Access2Base." I don't have the option to use Microsoft Access, although if Microsoft ever chose to sell the thing for the OS/X or Linux environments I would have plunked down my money instantly to buy a license.

Last edited by sundialsvcs; 08-08-2017 at 08:04 AM.
 
Old 08-08-2017, 08:08 AM   #5
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 8,444
Blog Entries: 4

Original Poster
Rep: Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896
Quote:
Originally Posted by MensaWater View Post
Since no one else replied and I'm not really a programmer I didn't before now.

Yesterday I searched for open source form builders for MySQL and found this one:
https://forums.mysql.com/read.php?52,631550,631550

That seems like it might be a good place to start.
I'm reluctant to pay $135 for forms, then another $135 for charts, and then yet another $135 for reports, when I could buy FileMaker Pro for the Macintosh for less money.

And now, looking closer at their product description on their main page, I see that they describe it as a tool for producing PHP AJAX forms ... which disqualifies it for my stated purposes. Strange as it may seem these days, I specifically do not want to build an internal web site, nor have one built for me.

Last edited by sundialsvcs; 08-08-2017 at 08:10 AM.
 
Old 08-08-2017, 08:45 AM   #6
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 19,074

Rep: Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377
Quote:
Originally Posted by sundialsvcs View Post
I'm reluctant to pay $135 for forms, then another $135 for charts, and then yet another $135 for reports, when I could buy FileMaker Pro for the Macintosh for less money.

And now, looking closer at their product description on their main page, I see that they describe it as a tool for producing PHP AJAX forms ... which disqualifies it for my stated purposes. Strange as it may seem these days, I specifically do not want to build an internal web site, nor have one built for me.
I know you stated "no web"...but I'd suggest you look at Xataface. You can deploy it VERY quickly, customize it pretty easily, and even have different levels of security per user/group. And its free. You can deploy it in less than an hour, and be running. Granted, it IS a web front-end, but it's pretty robust.

Just throwing out a solution that is a quick implementation for a MySQL front-end. That's the best suggestion I have at the moment, and again, sorry for mentioning a web-based one when you stated otherwise.

Last edited by TB0ne; 08-08-2017 at 08:46 AM.
 
Old 08-08-2017, 09:56 AM   #7
frieza
Senior Member
 
Registered: Feb 2002
Location: harvard, il
Distribution: Ubuntu 11.4,DD-WRT micro plus ssh,lfs-6.6,Fedora 15,Fedora 16
Posts: 3,225

Rep: Reputation: 402Reputation: 402Reputation: 402Reputation: 402Reputation: 402
not sure if this would help, but you COULD look into libreoffice (or openoffice) base, it can connect to a mysql database and create forms without programming.
 
1 members found this post helpful.
Old 08-08-2017, 11:03 AM   #8
!!!
Member
 
Registered: Jan 2017
Posts: 237
Blog Entries: 3

Rep: Reputation: 88
Wild-guess: GNUe? Jasper? LQ

Last edited by !!!; 08-08-2017 at 12:00 PM.
 
Old 08-08-2017, 02:27 PM   #9
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,555
Blog Entries: 13

Rep: Reputation: Disabled
Quote:
Originally Posted by !!! View Post
Wild-guess: GNUe? Jasper? LQ
I was gonna reply with iReports, but it's anything but "fast" ;(
 
Old 08-08-2017, 07:55 PM   #10
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 8,444
Blog Entries: 4

Original Poster
Rep: Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896
No ... Web ... Sites.
 
Old 08-08-2017, 08:01 PM   #11
dugan
LQ Guru
 
Registered: Nov 2003
Location: Canada
Distribution: Slackware
Posts: 7,504

Rep: Reputation: 2866Reputation: 2866Reputation: 2866Reputation: 2866Reputation: 2866Reputation: 2866Reputation: 2866Reputation: 2866Reputation: 2866Reputation: 2866Reputation: 2866
.NET if you're targeting Windows. WPF for the GUI, Linq to Entities for the DB access.

Qt with Python bindings if you're targeting Linux.

Last edited by dugan; 08-08-2017 at 08:05 PM.
 
Old 08-09-2017, 01:58 AM   #12
astrogeek
Moderator
 
Registered: Oct 2008
Distribution: Slackware [64]-X.{0|1|2|37|-current} ::12<=X<=14, FreeBSD_10{.0|.1|.2}
Posts: 4,454
Blog Entries: 6

Rep: Reputation: 2394Reputation: 2394Reputation: 2394Reputation: 2394Reputation: 2394Reputation: 2394Reputation: 2394Reputation: 2394Reputation: 2394Reputation: 2394Reputation: 2394
I find use of a browser based UI with PHP on an Apache local vhost a useful rapid development platform for my database projects, even when the final application may be written in another language. It allows separation of concerns - data model and query requirements from the UI requirements. But your "not a web-site" requirement would apparently rule out any browser based UI configuration. Is that a fair statement?

That leaves stand-alone applications with a database interface (Open/LibreOffice type, which you have also ruled out), or some unknown to me commercial reporting application (Crystal Reports rings a bell), or to write your own.

In the write-your-own category, I would look for a way to leverage PHP simply because it provides really good instant database APIs and a complete language with few external dependencies - you can get instantly down to writing your application. All that is missing are the GUI form elements, but you may be able to build the UI with something like wxPhp or PHP-Gtk. I have not actually used either, but if you already know PHP they might quickly solve the UI problem within an already familiar language and let you get down to business. If you are a Python fan, wxPython might also provide an option.

Last edited by astrogeek; 08-09-2017 at 02:01 AM.
 
Old 08-09-2017, 07:52 AM   #13
schneidz
LQ Guru
 
Registered: May 2005
Location: boston, usa
Distribution: fc-15/ fc-20-live-usb/ aix
Posts: 5,143

Rep: Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877Reputation: 877
based on the op's constraints, i think all off-the-shelf remedies that i know of are ruled out. so the only thing i know thats left is boiling a pot of coffee, rolling up your sleeves and finger walking across the keyboard trying to learn another language (or another graphics api to that language) and also learn the methods/protocols/function calls to mysql select/delete/insert/update/grant/... various db entities to roll their own database program. since they needed this ...yesterday, that kinda' rules that out as an option as well.
 
Old 08-09-2017, 08:12 AM   #14
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 8,444
Blog Entries: 4

Original Poster
Rep: Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896Reputation: 2896
I know Java – I know how to do this "by hand" – but I don't want to go to the effort for what I know to be a very routine requirement. Yes, the target environment is Unix/Linux, not Windows. (If it were Windows, I would have used Microsoft Access long before now. And, if Microsoft included it in the MS-Office package which they sell for OS/X – which I damn well know to be a cross-platform code base – I would have used it as well. But Microsoft Corporation continues to leave money on the table.
 
Old 08-09-2017, 10:23 AM   #15
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 19,074

Rep: Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377Reputation: 4377
Quote:
Originally Posted by sundialsvcs View Post
I know Java I know how to do this "by hand" but I don't want to go to the effort for what I know to be a very routine requirement. Yes, the target environment is Unix/Linux, not Windows. (If it were Windows, I would have used Microsoft Access long before now. And, if Microsoft included it in the MS-Office package which they sell for OS/X which I damn well know to be a cross-platform code base I would have used it as well. But Microsoft Corporation continues to leave money on the table.
Well, you ruled out Libreoffice Base, which can do a lot of what Access can do, shot down doing it yourself, and using a pre-built web framework (xataface). Not sure where else to go. I can tell you from personal experience that xataface can be deployed in less than an hour, for your 'need-it-yesterday' needs.

I understand you don't want a web-based solution; but you haven't said why this is an issue. Would seem to me to be a better fit, since the client (Windows/Mac/Linux) wouldn't matter at all. A Linux-only solution is more limiting, but ok. You mentioned Java, so this may fit the bill:
http://squirrel-sql.sourceforge.net/index.php

And if you want Linux-centric, QT is a rapid development tool, with hooks into MySQL:
http://www.folding-hyperspace.com/re...-database.html

Seems like any suggestions we make get you a bit upset.
 
2 members found this post helpful.
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Front End Database Application carlosinfl Linux - Software 3 12-23-2010 08:39 AM
Apache+php => database front-end sylvaticus Linux - Server 0 01-09-2007 08:28 AM
Need small database app with front end red_nexus Linux - Software 3 05-08-2006 02:10 AM
How to build front-end (GUI) satimis Programming 3 12-02-2004 01:25 AM
Rich Text Widget/Database Front End Stranger Programming 5 10-03-2004 06:37 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 09:59 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration