Inviting ideas for Personal database

--000e0cd4cafe8143a304ae7fde8d
Content-Type: text/plain; charset=UTF-8

I am planning to write a small, non-bulky, easy to use and easy to port
application for my personal use.

There is lot of information I store on Google docs like commands, key words,
directory locations, script names etc. Pretty much everything which I use
daily.

Switching from shell to Web-browser is sometimes not so convenient.

Hence I am planning to store these information in flat files with some
keyword/switch and then use my application to parse and fetch the
information I am looking for.

Is there any better approach I can use instead of flat files like some
personal db etc. One of the concern I have with databases like MySQL etc is
that I would also have to install which would become a dependency and being
honest I also dont' have that huge of a data.

Does Perl have any standard database which comes installed with the standard
package ON ALL Operating Systems.

Feel free to share your thoughts.

TIA

Parag

--000e0cd4cafe8143a304ae7fde8d--

Re: Inviting ideas for Personal database

On 11-10-04 05:35 PM, Parag Kalra wrote:
> Feel free to share your thoughts.

If the database is small, I would consider using SQLite. It stores the
entire database in a single file which makes it easy to backup and
transfer. Thunderbird and Firefox use it extensively.


--
Just my 0.00000002 million dollars worth,
Shawn

Confusion is the first step of understanding.

Programming is as much about organization and communication
as it is about coding.

The secret to great software: Fail early & often.

Eliminate software piracy: use only FLOSS.

"Make something worthwhile." -- Dear Hunter

--
To unsubscribe, e-mail: beginners-unsubscribe@perl.org
For additional commands, e-mail: beginners-help@perl.org
http://learn.perl.org/

Re: Inviting ideas for Personal database

On Tue, Oct 4, 2011 at 5:41 PM, Shawn H Corey wrote:
> If the database is small, I would consider using SQLite. It stores the
> entire database in a single file which makes it easy to backup and transfer.
> Thunderbird and Firefox use it extensively.

I second SQLite. :) It's basically perfect for a lightweight database.

Though I question the types of information you have and what you
do with it. If it's just like configuration and documentation to
remind yourself of commands and APIs and such then I might
suggest you instead just use shell scripts/config files and man
pages or PODs and version it all with Git (possibly in different
repos). :) You can create a public repository on one of the DVCS
Web sites and make it available where ever you go. :) That way
all of your stuff is only a clone away.

For example, I try to keep all of my non-sensitive dotfiles in my
'rc' repository: https://github.com/bamccaig/rc/

This way when I login to a new system for the first time I just
clone my rc repo from GitHub and create symlinks and that fast I
have all of my personal configuration setup. :)


--
Brandon McCaig
Castopulence Software
Blog
perl -E '$_=q{V zrna gur orfg jvgu jung V fnl. }.
q{Vg qbrfa'\''g nyjnlf fbhaq gung jnl.};
tr/A-Ma-mN-Zn-z/N-Zn-zA-Ma-m/;say'

--
To unsubscribe, e-mail: beginners-unsubscribe@perl.org
For additional commands, e-mail: beginners-help@perl.org
http://learn.perl.org/

Re: Inviting ideas for Personal database

--0015174bef40615a0a04ae813288
Content-Type: text/plain; charset=UTF-8

On Tue, Oct 4, 2011 at 3:38 PM, Brandon McCaig wrote:

> On Tue, Oct 4, 2011 at 5:41 PM, Shawn H Corey
> wrote:
> > If the database is small, I would consider using SQLite. It stores the
> > entire database in a single file which makes it easy to backup and
> transfer.
> > Thunderbird and Firefox use it extensively.
>
> I second SQLite. :) It's basically perfect for a lightweight database.
>

PK> Thank you all for pointing to SQLite. Other question I have is SQLite
and DBI part of standard Perl package or do I need to explicitly install the
modules.


> Though I question the types of information you have and what you
> do with it. If it's just like configuration and documentation to
> remind yourself of commands and APIs and such then I might
> suggest you instead just use shell scripts/config files and man
> pages or PODs and version it all with Git (possibly in different
> repos). :) You can create a public repository on one of the DVCS
> Web sites and make it available where ever you go. :) That way
> all of your stuff is only a clone away.
>
> For example, I try to keep all of my non-sensitive dotfiles in my
> 'rc' repository: https://github.com/bamccaig/rc/


PK>> Yes I also keep my personal projects on Github, most likely would keep
this one as well.


>
>
> This way when I login to a new system for the first time I just
> clone my rc repo from GitHub and create symlinks and that fast I
> have all of my personal configuration setup. :)
>
>
> --
> Brandon McCaig
> Castopulence Software
> Blog
> perl -E '$_=q{V zrna gur orfg jvgu jung V fnl. }.
> q{Vg qbrfa'\''g nyjnlf fbhaq gung jnl.};
> tr/A-Ma-mN-Zn-z/N-Zn-zA-Ma-m/;say'
>
> --
> To unsubscribe, e-mail: beginners-unsubscribe@perl.org
> For additional commands, e-mail: beginners-help@perl.org
> http://learn.perl.org/
>
>
>

--0015174bef40615a0a04ae813288--

Re: Inviting ideas for Personal database

Hi Parag,

On Tue, 4 Oct 2011 16:10:06 -0700
Parag Kalra wrote:

> On Tue, Oct 4, 2011 at 3:38 PM, Brandon McCaig wrote:
>=20
> > On Tue, Oct 4, 2011 at 5:41 PM, Shawn H Corey
> > wrote:
> > > If the database is small, I would consider using SQLite. It stores the
> > > entire database in a single file which makes it easy to backup and
> > transfer.
> > > Thunderbird and Firefox use it extensively.
> >
> > I second SQLite. :) It's basically perfect for a lightweight database.
> >
>=20
> PK> Thank you all for pointing to SQLite. Other question I have is SQLite
> and DBI part of standard Perl package or do I need to explicitly install =
the
> modules.

DBI and DBD::SQLite are not part of the core perl5 source distribution, but=
on
the other hand:

1. Nothing prevents people from creating Perl distributions with them inclu=
ded.

2. Even the core Perl distribution is sometimes split into several componen=
ts
by downstream distributors (like Linux distributions, etc.).

3. You can easily install them from CPAN or using different means:
http://perl-begin.org/topics/cpan/ .

4. I should note that DBD-SQLite includes the sources of the SQLite C libra=
ry,
for cases it's not available on the system, so you don't even need to insta=
ll
the latter.

>=20
>=20
> > Though I question the types of information you have and what you
> > do with it. If it's just like configuration and documentation to
> > remind yourself of commands and APIs and such then I might
> > suggest you instead just use shell scripts/config files and man
> > pages or PODs and version it all with Git (possibly in different
> > repos). :) You can create a public repository on one of the DVCS
> > Web sites and make it available where ever you go. :) That way
> > all of your stuff is only a clone away.
> >
> > For example, I try to keep all of my non-sensitive dotfiles in my
> > 'rc' repository: https://github.com/bamccaig/rc/
>=20
>=20
> PK>> Yes I also keep my personal projects on Github, most likely would ke=
ep
> this one as well.

You may wish to look at http://ikiwiki.info/ or similar for that.

-----------

Finally, I should note that you shouldn't prefix your replies with "PK>" or
"PK>>" because that way it seems like you're quoting someone else. Instead,
write your replies directly at the start of line

Regards,

Shlomi Fish=20

--=20
------------------------------------------------------------ -----
Shlomi Fish http://www.shlomifish.org/
UNIX Fortune Cookies - http://www.shlomifish.org/humour/fortunes/

If his programming is anything like his philosophising, he would find ten
imaginary bugs in the â€=9CHello Worldâ€=9D program.

Please reply to list if it's a mailing list post - http://shlom.in/reply .

--
To unsubscribe, e-mail: beginners-unsubscribe@perl.org
For additional commands, e-mail: beginners-help@perl.org
http://learn.perl.org/

Re: Inviting ideas for Personal database

--00151747b0da745d6404ae91aade
Content-Type: text/plain; charset=UTF-8

>
>
>
> Finally, I should note that you shouldn't prefix your replies with "PK>" or
>
>
Agreed. My mistake. Thanks for bringing it to my notice. BTW I have started
using sqllite and I am really enjoying it. Thanks to all.

Parag

--00151747b0da745d6404ae91aade--

Re: Inviting ideas for Personal database

Parag Kalra, Wed, 05 Oct 2011 11:49:00 -0700:


>>
>>
>> Finally, I should note that you shouldn't prefix your replies with
>> "PK>" or
>>
>>
> Agreed. My mistake. Thanks for bringing it to my notice. BTW I have
> started using sqllite and I am really enjoying it. Thanks to all.
>=20
> Parag

Hi Parag,

sqlite is nice, however you should take care that it is quite slow
with some filesystems (namely btrfs).

Lubos


--=20
To unsubscribe, e-mail: beginners-unsubscribe@perl.org
For additional commands, e-mail: beginners-help@perl.org
http://learn.perl.org/

Re: Inviting ideas for Personal database

--bcaec51dd579f6af2504ae927744
Content-Type: text/plain; charset=ISO-8859-1

Any database system will react differently under different file systems...

On Wed, Oct 5, 2011 at 2:58 PM, Lubos Kolouch wrote:

> Parag Kalra, Wed, 05 Oct 2011 11:49:00 -0700:
>
>
> >>
> >>
> >> Finally, I should note that you shouldn't prefix your replies with
> >> "PK>" or
> >>
> >>
> > Agreed. My mistake. Thanks for bringing it to my notice. BTW I have
> > started using sqllite and I am really enjoying it. Thanks to all.
> >
> > Parag
>
> Hi Parag,
>
> sqlite is nice, however you should take care that it is quite slow
> with some filesystems (namely btrfs).
>
> Lubos
>
>
> --
> To unsubscribe, e-mail: beginners-unsubscribe@perl.org
> For additional commands, e-mail: beginners-help@perl.org
> http://learn.perl.org/
>
>
>

--bcaec51dd579f6af2504ae927744--