Simple DB app

This is the place to offer or seek development services - offer to build apps for others or find a developer to work for you

Moderators: heatherlaine, Klaus, FourthWorld, robinmiller, kevinmiller

Post Reply
kbts
Posts: 1
Joined: Sat Jul 14, 2018 1:00 am

Simple DB app

Post by kbts » Sat Jul 14, 2018 3:46 am

Hello all,

I'm looking to hire an experienced developer to develop a simple livecode app with sourcecode that connects to a sqlite database
and displays records one at a time with previous and next buttons. I've programmed with VBA and access but at the moment don't have time to learn the specifics of Livecode.

Schema:

filename: db1.sql

Table name: table1

Fields and data:
Id,Name,picture
1,Tom,tom1.jpg
2,Karen,karen.jpg
3, Carl, Carl.jpg

App opens showing a picture of tom1.jpg with the name Tom displayed. It has two navigation buttons, prev and next. at first record, the prev button is hidden and at last record next button is hidden.

I may want to add more depending on how it works out. PM me and let me know how much this simple app and source would be to develop.

Thanks,

Tom

bogs
Posts: 2086
Joined: Sat Feb 25, 2017 10:45 pm

Re: Simple DB app

Post by bogs » Sat Jul 14, 2018 1:01 pm

Hello Tom :)

I know your not looking to program it yourself, but I believe I came across such a simple program already done, if I come across it again, I'll post the location to it and you can see if it fits your needs.

The main problem I was chiming in about here though is that you are new to this forum, and while you would be able to receive pm contact, until you hit 10 posts you will not be able to reply to them ( I think I have that right ).

Although it is tempting, I wouldn't put your email blatantly in any forum either, although the usual tricks such as "my_email at this dot com" seems to work out ok for form.

There is also a Lc developer market place that you might try from the Lc web site in the directory, and Richard mentioned (elsewhere) the LiveCode group on LinkedIn if you haven't already caught it.

Good luck with your project!
Image

AndyP
Posts: 359
Joined: Wed Aug 27, 2008 12:57 pm
Location: Seeheim, Germany (ex UK)
Contact:

Re: Simple DB app

Post by AndyP » Sun Jul 15, 2018 11:54 am

Hi Tom,

If you want to do this yourself which is relatively easy with LiveCode, the this example has all the code you will need.

http://livecodeshare.runrev.com/stack/6 ... te-Sampler

Good luck!
Andy Piddock

http://2108.co.uk/tinyide/ - TinyIDE gives you more space to develop your ideas

http://2108.co.uk/script-editor-themer/ Script Editor Themer - Your code has never looked so good

My software never has bugs. It just develops random features

bogs
Posts: 2086
Joined: Sat Feb 25, 2017 10:45 pm

Re: Simple DB app

Post by bogs » Sun Jul 15, 2018 6:57 pm

I thought of mentioning the sampler stack (Resources Icon on the toolbar -> Databases -> SQLite), but that doesn't include handling inserting pictures unless you go the binary route.

There is also the SQLite CRUD demo (in this "CRUD SQLite example" thread in the forums posted by townsend) which demonstrates it all in a lot more depth.

But the version I had come across mentioned above (which I haven't remembered where yet) was literally what he was looking to do, i.e.
kbts wrote:
Sat Jul 14, 2018 3:46 am
Fields and data:
Id,Name,picture
1,Tom,tom1.jpg
2,Karen,karen.jpg
3, Carl, Carl.jpg
I keep thinking it was done by MaxV, but I could be wrong on that score.

Andy is right though Tom, this is a relatively easy project, probably less than a full days research and code, and of course if you write it yourself modification of it later will be easier for you to accomplish.
Image

Mikey
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 630
Joined: Fri Jun 27, 2008 9:00 pm

Re: Simple DB app

Post by Mikey » Mon Jul 16, 2018 2:57 pm

I was thinking about making this month's LCG session on building a simple DB app in LC anyway, so keep the thoughts going...

Post Reply

Return to “Developer Services Marketplace”