YADA - Yet another database application

Applications, Games, Tools, User libs and useful stuff coded in PureBasic
User avatar
kpeters58
Enthusiast
Enthusiast
Posts: 341
Joined: Tue Nov 22, 2011 5:11 pm
Location: Kelowna, BC, Canada

YADA - Yet another database application

Post by kpeters58 »

Image


In July of last year, RobertSF posted this: viewtopic.php?f=27&t=70998

I had a look at it, and it motivated me to do another version of it, also aimed at PB beginners but using
SQLite instead.

My application is written in PB 5.70 and has only been tested under Windows 10. It should be easily adaptable
to slightly older versions of PB, and to MacOS & Linux as well.

It will automatically create its own database and populate it with sample data for immediate exploration upon the first run.

I would be remiss if I didn't thank all the friendly folks at the forums who have helped me time and again over the years - thank you!
Some of your wisdom and kindness is included in the source!

This little desktop application is not quite end-user release quality, but pretty close.

If you find something wrong with it, please post it here and I will try and fix it - time permitting. Enjoy!

You can download it here: http://www.otaksoft.com/purebasic/ContactManager.zip
PB 5.73 on Windows 10 & OS X High Sierra
User avatar
blueb
Addict
Addict
Posts: 1041
Joined: Sat Apr 26, 2003 2:15 pm
Location: Cuernavaca, Mexico

Re: YADA - Yet another database application

Post by blueb »

Very nice Kai,

Clean and very intuitive, I like it. :mrgreen:
- It was too lonely at the top.

System : PB 6.10 Beta 9 (x64) and Win Pro 11 (x64)
Hardware: AMD Ryzen 9 5900X w/64 gigs Ram, AMD RX 6950 XT Graphics w/16gigs Mem
User avatar
Kwai chang caine
Always Here
Always Here
Posts: 5342
Joined: Sun Nov 05, 2006 11:42 pm
Location: Lyon - France

Re: YADA - Yet another database application

Post by Kwai chang caine »

Nice !!! thanks for sharing 8)
ImageThe happiness is a road...
Not a destination
User avatar
kpeters58
Enthusiast
Enthusiast
Posts: 341
Joined: Tue Nov 22, 2011 5:11 pm
Location: Kelowna, BC, Canada

Re: YADA - Yet another database application

Post by kpeters58 »

Image


Version 1.0.1 of YADA Contactmanager is now available from

http://www.otaksoft.com/purebasic/ContactManager.zip

Change log:

- Added support for: Address, City & PostalCode
- Find function now scrolls found record into view
- Filter now highlights matches in the column used for filtering and no longer in the ID column
- Change detection in form_Config is now handled via bit flags
- Support for default export directory added
- Support for filtering all exports (XML, JSON, CSV) added

Fixes:
- Error messages: The title caption and the actual message were swapped.

Notes:
- This release is not backwards compatible with databases generated by version 1.0.0. If you have one of these, simply delete it.
- The preference item 'PropercaseNames' has been renamed to 'PropercaseStrings' since it now applies to addresses and city names
as well. Deleting an existing Contactmanager.prefs file will get rid of that redundant entry.

Enjoy!
Last edited by kpeters58 on Sat Jun 08, 2019 5:44 am, edited 1 time in total.
PB 5.73 on Windows 10 & OS X High Sierra
User avatar
RSBasic
Moderator
Moderator
Posts: 1218
Joined: Thu Dec 31, 2009 11:05 pm
Location: Gernsbach (Germany)
Contact:

Re: YADA - Yet another database application

Post by RSBasic »

Nice 8)
Image
Image
mchael
User
User
Posts: 15
Joined: Mon Oct 14, 2019 7:31 am

Re: YADA - Yet another database application

Post by mchael »

Trying to download and have a look and learn from and I see the domain is expired - look forward to looking and learning from it. Thanks in advance!
User avatar
spikey
Enthusiast
Enthusiast
Posts: 581
Joined: Wed Sep 22, 2010 1:17 pm
Location: United Kingdom

Re: YADA - Yet another database application

Post by spikey »

RSBasic sometimes squirrels away any goodies he likes the look of at:
https://www.rsbasic.de/backups/

I think this is the one you're looking for:
http://backup.rsbasic.de/?file=ContactManager.zip
mchael
User
User
Posts: 15
Joined: Mon Oct 14, 2019 7:31 am

Re: YADA - Yet another database application

Post by mchael »

thank you
User avatar
kpeters58
Enthusiast
Enthusiast
Posts: 341
Joined: Tue Nov 22, 2011 5:11 pm
Location: Kelowna, BC, Canada

Re: YADA - Yet another database application

Post by kpeters58 »

Domain should have auto-renewed but didn't :(

Fixed. Sorry for any inconvenience!
PB 5.73 on Windows 10 & OS X High Sierra
Rinzwind
Enthusiast
Enthusiast
Posts: 636
Joined: Wed Mar 11, 2009 4:06 pm
Location: NL

Re: YADA - Yet another database application

Post by Rinzwind »

Not sure whats purpose of magic line

offset = RowCount / 20 ; 20 works pretty well in initial, minimized and maximized window sizes

in form_main.pbi is for, but needs to be commented on macOS, otherwise last item will always be selected and can't select anything else.
User avatar
kpeters58
Enthusiast
Enthusiast
Posts: 341
Joined: Tue Nov 22, 2011 5:11 pm
Location: Kelowna, BC, Canada

Re: YADA - Yet another database application

Post by kpeters58 »

Rinzwind wrote:Not sure whats purpose of magic line

offset = RowCount / 20 ; 20 works pretty well in initial, minimized and maximized window sizes

in form_main.pbi is for, but needs to be commented on macOS, otherwise last item will always be selected and can't select anything else.

On Windows, with screen scaling > 100% and using the program's find functionality, the 'found' record doesn't always fully scroll into view - hence the addition of a small offset to ensure that it does. Removing it should be harmless. It looks like macOS does something not too smart when asked to scroll past the last record...??

I assume your statement is only true for locating one of the last 3 records or so? I can't see how your blanket statement could be true in all cases - unless there also is some bug involved.
PB 5.73 on Windows 10 & OS X High Sierra
User avatar
kpeters58
Enthusiast
Enthusiast
Posts: 341
Joined: Tue Nov 22, 2011 5:11 pm
Location: Kelowna, BC, Canada

Re: YADA - Yet another database application

Post by kpeters58 »

I just uploaded YADA version 1.03.

Changes:

- moved variables from global namespaces to protected ones wherever possible
- fixed reported bug with exports (sometimes empty export files were generated)
- misc. small modifications
- updated year and version in copyright notices
PB 5.73 on Windows 10 & OS X High Sierra
User avatar
Kwai chang caine
Always Here
Always Here
Posts: 5342
Joined: Sun Nov 05, 2006 11:42 pm
Location: Lyon - France

Re: YADA - Yet another database application

Post by Kwai chang caine »

Thanks 8)
ImageThe happiness is a road...
Not a destination
dmontaine
User
User
Posts: 45
Joined: Tue Jun 04, 2019 1:03 pm

Re: YADA - Yet another database application

Post by dmontaine »

The images directory is missing in the zip.
User avatar
VB6_to_PBx
Enthusiast
Enthusiast
Posts: 617
Joined: Mon May 09, 2011 9:36 am

Re: YADA - Yet another database application

Post by VB6_to_PBx »

dmontaine wrote:The images directory is missing in the zip.
you need to download this Link to get the Folder with the Images
and then move that Image Folder as a Sub Folder of the ContactManager's Folder
http://backup.rsbasic.de/?file=ContactManager.zip

Only use the Image Folder , nothing else from the above Link
just merge it to the new version of ContactManager
 
PureBasic .... making tiny electrons do what you want !

"With every mistake we must surely be learning" - George Harrison
Post Reply