Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Tue 21 Oct 2014, 21:59
All times are UTC - 4
 Forum index » Advanced Topics » Puppy Projects
Puppy Personal Database
Moderators: Flash, JohnMurga
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
Page 3 of 8 Posts_count   Goto page: Previous 1, 2, 3, 4, 5, 6, 7, 8 Next
Author Message
hillside


Joined: 02 Sep 2007
Posts: 642
Location: Minnesota, USA. The frozen north.

PostPosted: Mon 18 May 2009, 23:12    Post_subject:  

Is this strictly a contacts database at this point or can I make my own fields?

I've been using OObase, but I would be interested in this project since OO is so large. But I would need to be able to design my own tables.

Related tables with subforms would really be beneficial, but I suppose that will be more in line with the RDBMS project.
Back to top
View user's profile Send_private_message 
gposil


Joined: 06 Apr 2009
Posts: 1305
Location: Stanthorpe (The Granite Belt), QLD, Australia

PostPosted: Mon 18 May 2009, 23:19    Post_subject:  

hillside said
Quote:
Is this strictly a contacts database at this point or can I make my own fields?


There will be an option in upcoming version to create and view/edit your own tables...flatfile only...table linking will be part of RDBMS.

_________________
Dpup Home
Back to top
View user's profile Send_private_message Visit_website MSNM 
Lobster
Official Crustacean


Joined: 04 May 2005
Posts: 15117
Location: Paradox Realm

PostPosted: Tue 19 May 2009, 05:06    Post_subject:  

I was interested in one point at writing a database - tried a whole week of experiments in Javascript, XUL, C and Genie and Bash and realised I was not up to the task.

You seem to be doing OK - so in case it is of any use I enclose the graphic from those efforts

Smile
pdblogo.jpg
 Description   
 Filesize   11.69 KB
 Viewed   934 Time(s)

pdblogo.jpg


_________________
Puppy WIKI
Back to top
View user's profile Send_private_message Visit_website 
gposil


Joined: 06 Apr 2009
Posts: 1305
Location: Stanthorpe (The Granite Belt), QLD, Australia

PostPosted: Tue 19 May 2009, 05:36    Post_subject:  

Lobster

I love it...i'll use it as splash screen...BTW ppdblite is coming along nicely should have something to show you soon, and big brother ppdb will be able to import ppdblite databases for more advanced manipulation if required.

_________________
Dpup Home
Back to top
View user's profile Send_private_message Visit_website MSNM 
Minnesota

Joined: 11 Sep 2008
Posts: 313

PostPosted: Tue 19 May 2009, 06:47    Post_subject:  Very GOOD
Sub_title: Just starting the questions
 

Good Morning:

Just ran into this thread... This looks great and promising!

Lots of questions.

First and foremost SORTING? Are their plans to sort the data for reports?

Please add to search options "Any Field".

If search returns with no selected records.. not obvious what to do with blank screen. No back buttons or similar directions on how to get back to initial screen.

Inserting or adding new records.
1) Not obvious that Insert means ADD new Records.
2) Once Insert is pressed cursor should start at the "Title Box" ready for input.

3) When inserting a new record Most of the data automatically fills in at the top... except the TITLE. That waits for a save.

Open the test database... .and I was able to change the First Name... when I did so... at the TOP pane. Doing so eliminated "Alfred"... never to be seen again.... unless I reloaded backup.....

More as we progress... LOOKING GOOD.. .KEEP up the good work!

Any way to change the format?

Laughing
Back to top
View user's profile Send_private_message 
gposil


Joined: 06 Apr 2009
Posts: 1305
Location: Stanthorpe (The Granite Belt), QLD, Australia

PostPosted: Tue 19 May 2009, 07:38    Post_subject:  

Hello Minnesota

To answer your questions:

1.) Sorting for reports will be available
2.) Search on any field will be available
3.) No record found message box will be instituted
4.) Insert/add new records problem already in 0.5a(not released yet)
5.) Title problem you mentioned is already fixed in 0.5a
6.) Wasn't able to duplicate your disappearing "Alfred" problem will look at it.
7.) With regards to format...there is already custom format being worked on for future release.

Please add any suggestions...

_________________
Dpup Home
Back to top
View user's profile Send_private_message Visit_website MSNM 
Minnesota

Joined: 11 Sep 2008
Posts: 313

PostPosted: Wed 20 May 2009, 11:46    Post_subject: Update top Pane
Sub_title: Am I supposed to be able to update the top pane
 

Am I supposed to be able to update the top display pane. It is OK, not a real problem..if it is by design.. it gives an easier way to update...

Are their plans for a Ctrl-z UNDO? In any way? If you make a mistake.. or accidentally hit a key in a field.. the field previous data is gone.

At least at the top pane.
Database change top pane.jpg
 Description   
 Filesize   30.94 KB
 Viewed   419 Time(s)

Database change top pane.jpg

Back to top
View user's profile Send_private_message 
gposil


Joined: 06 Apr 2009
Posts: 1305
Location: Stanthorpe (The Granite Belt), QLD, Australia

PostPosted: Thu 21 May 2009, 00:00    Post_subject:  

From version 0.5a onwards, the top pane will be read only by default...but you will have the option to open it to writing...A Ctrl-z feature will be included.
_________________
Dpup Home
Back to top
View user's profile Send_private_message Visit_website MSNM 
Minnesota

Joined: 11 Sep 2008
Posts: 313

PostPosted: Thu 21 May 2009, 08:02    Post_subject: Version 0.5a
Sub_title: Update time frame
 

Quote:
From version 0.5a onwards, the top pane will be read only by default...but you will have the option to open it to writing...A Ctrl-z feature will be included.


Looking forward to Version five. Smile Sounds like a big update. Any time frame for when you will release it? Keep up the good work.
Back to top
View user's profile Send_private_message 
DaveS


Joined: 09 Oct 2008
Posts: 3726
Location: UK

PostPosted: Thu 21 May 2009, 08:24    Post_subject: Re: Just a question  

gposil wrote:
Do we want this to grow into a full blown free form database creator/editor or should the RDBMS be a separate project.


OMG YES YES YES! Ever tried to work with OOBase? Nightmare

_________________
Spup Frugal HD and USB
Root forever!
Back to top
View user's profile Send_private_message 
gposil


Joined: 06 Apr 2009
Posts: 1305
Location: Stanthorpe (The Granite Belt), QLD, Australia

PostPosted: Fri 22 May 2009, 11:45    Post_subject: ppdblite  

Just thought i'd give you an update on the Lite version of ppdb...here's a screenshot...first release soon, and should be under 50k in size.
ppdblite.jpg
Description  Screenshot
jpg

 Download 
Filename  ppdblite.jpg 
Filesize  47.9 KB 
Downloaded  417 Time(s) 

_________________
Dpup Home
Back to top
View user's profile Send_private_message Visit_website MSNM 
Colonel Panic


Joined: 16 Sep 2006
Posts: 1521

PostPosted: Fri 22 May 2009, 13:12    Post_subject:  

Thanks for this one, which I've just downloaded. I'm pretty happy with Portabase (covered elsewhere) as my needs for a database are quite modest and Portabase does everything I want, but I'll give it a try soon.

Like the avatar btw. Smile
Back to top
View user's profile Send_private_message 
gposil


Joined: 06 Apr 2009
Posts: 1305
Location: Stanthorpe (The Granite Belt), QLD, Australia

PostPosted: Mon 25 May 2009, 01:18    Post_subject: Update  

Version 0.5a posted at top of thread...bug fixes and the start of custom database creator...getting there... Smile
_________________
Dpup Home
Back to top
View user's profile Send_private_message Visit_website MSNM 
Lobster
Official Crustacean


Joined: 04 May 2005
Posts: 15117
Location: Paradox Realm

PostPosted: Mon 25 May 2009, 01:58    Post_subject: Re: ppdblite  

gposil wrote:
first release soon, and should be under 50k in size.

Woof might have a database
Woof! Woof! - sounds and looks ideal for Puppy 5
Be aware that the early netbooks have a small screen size - maybe a toggle button for the images field?

Quote:
start of custom database creator

had a look at this
tried the creator (not working yet?) totally obvious and straightforward Cool
in layout
Good to see my graphic made it Smile

_________________
Puppy WIKI
Back to top
View user's profile Send_private_message Visit_website 
Minnesota

Joined: 11 Sep 2008
Posts: 313

PostPosted: Mon 25 May 2009, 19:59    Post_subject: testing databae ppdb-0.5.pet
Sub_title: Blowing up.. kind of
 

Help.. cursor in top section... had two original records in old data base... put cursor I think in second field to see if I could modify.. at the top section... hit random keys.. and blew out the two records.. record count stayed... but current record indicator went to negative number... so something blew big time. Prior, next, first.. nothing will show old records.

Adding (insert) additional records start at three... so record count saved.. but impossible to get back to old records... reloading from open put me at count two... no data.. so you must be updating the disk file immediately...live?

From a standpoint of operator cursor movement... once you Insert a NEW record... and complete the input of date... YOU must stop your data entry.. get the mouse and move to the TOP to save the record.. extremely inconvenient... a data entry operator would have your hide...

Cursor needs to move to the save button....preferably on the input portion of the screen.

Of course once you save.. cursor should go back to first field for next record input.

Questions... you can enter any data in the phone fields.. indicate there is not any error checking for data type? Correct? Same for fax or mobile..

IS a spelling checker in the works?

Tried to create a database from scratch... took db name, took file location... tried to enter a field, took name and type then... nothing.. tried to save db.. nothing...

Will continue to test.

Greg
Back to top
View user's profile Send_private_message 
Display_posts:   Sort by:   
Page 3 of 8 Posts_count   Goto page: Previous 1, 2, 3, 4, 5, 6, 7, 8 Next
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
 Forum index » Advanced Topics » Puppy Projects
Jump to:  

Rules_post_cannot
Rules_reply_cannot
Rules_edit_cannot
Rules_delete_cannot
Rules_vote_cannot
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0829s ][ Queries: 13 (0.0072s) ][ GZIP on ]