Re: [Dorset] Database with GUI Front End for Non-Database Experts
On 13/11/2018 09:27, Stephen Wolff wrote: Hi, Once you've written the requirements, you can look at how you could implement them. From what you've said so far, I'd be looking at a Flask app (or, if you'd prefer to spend nine months learning the platform, Django). Shouldn’t take 9 months with Django unless you had absolutely no knowledge of web development, python or linux. I’d be happy to help if you went down that path. As mentioned earlier, my hosting provider includes MySQL as part of my package, and Stephen Wolff has suggested off list that the hosting provider might also provide access to PHPMyAdmin. It does; so I am looking into how suitable that is for our purpose. If there are non-technical users, it probably isn’t much use. It’s more a database administration tool. On that subject, can anyone comment on that? I can see that PHPMyAdmin allows the database to be developed, (and the records can be imported from LibreOffice Calc) but I'm not sure how the users would then access it. As I said at the beginning, I have very little knowledge of database development (yet). But start with the requirements. Well I thought I had; albeit a bit informal. -- In my teaching at the university, I got thrown in to teaching a Database course to 2nd year. I learned a lot in a hurry. The students used Dreamweaver to build a web page that accessed a database. Here is a link to FOSS equivalents: https://www.ionos.co.uk/digitalguide/websites/website-creation/dreamweaver-alternatives-open-source-solutions/ Caveat: I have not tried any. But I may do one day. Peter -- Next meeting at *new* venue: Bournemouth, Tuesday, 2018-12-04 20:00 Check if you're replying to the list or the author Meetings, mailing list, IRC, ... http://dorset.lug.org.uk/ New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
Re: [Dorset] Database with GUI Front End for Non-Database Experts
On Tuesday, 13 November 2018 09:27:57 GMT Stephen Wolff wrote: > > As mentioned earlier, my hosting provider includes MySQL as part of my > > package, and Stephen Wolff has suggested off list that the hosting > > provider > > might also provide access to PHPMyAdmin. It does; so I am looking > > into how > > suitable that is for our purpose. > > If there are non-technical users, it probably isn’t much use. It’s > more a database administration tool. I had a suspicion it might be, which is why I asked the question. So if I want to take advantage of the MySQL offering from my provider (it is free as it's part of the contract that I have with them), I only use PHPMyAdmin to initially populate, configure and structure the database? So I would probably have to use something else for the users so are there any suggestions? Or is this going to need a bespoke development, necessitating the use of Flask, Django or similar? My database experience is quite limited, being confined to being a User of the CMS I mentioned earlier, simple tasks using MS Access and even simpler ones using an early Mac tool that I think was called 4th Dimension (that was about 25 years ago). Hence my rather naive questions. > Shouldn’t take 9 months with Django unless you had absolutely no > knowledge of web development, python or linux. I’d be happy to help if > you went down that path. I might take you up on that. My experience of web development is definitely beginner level, of Python only slightly more (as some of my posts on this list will testify) and I've never used Django. Having said that, at the moment I'm just exploring all the options and don't expect to do much active development on this until we've completed some hardware development that is currently ongoing (or at least reach a slack point, while I wait for some dependency to come through. -- Terry Coles -- Next meeting at *new* venue: Bournemouth, Tuesday, 2018-12-04 20:00 Check if you're replying to the list or the author Meetings, mailing list, IRC, ... http://dorset.lug.org.uk/ New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
Re: [Dorset] Database with GUI Front End for Non-Database Experts
Hi, Once you've written the requirements, you can look at how you could implement them. From what you've said so far, I'd be looking at a Flask app (or, if you'd prefer to spend nine months learning the platform, Django). Shouldn’t take 9 months with Django unless you had absolutely no knowledge of web development, python or linux. I’d be happy to help if you went down that path. As mentioned earlier, my hosting provider includes MySQL as part of my package, and Stephen Wolff has suggested off list that the hosting provider might also provide access to PHPMyAdmin. It does; so I am looking into how suitable that is for our purpose. If there are non-technical users, it probably isn’t much use. It’s more a database administration tool. On that subject, can anyone comment on that? I can see that PHPMyAdmin allows the database to be developed, (and the records can be imported from LibreOffice Calc) but I'm not sure how the users would then access it. As I said at the beginning, I have very little knowledge of database development (yet). But start with the requirements. Well I thought I had; albeit a bit informal. -- Next meeting at *new* venue: Bournemouth, Tuesday, 2018-12-04 20:00 Check if you're replying to the list or the author Meetings, mailing list, IRC, ... http://dorset.lug.org.uk/ New thread, don't hijack: mailto:dorset@mailman.lug.org.uk