Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: What is the best newbie database app?

  1. #1

    Default What is the best newbie database app?

    I need to build a database to track some information.
    I am a novice, which would be usable for a newbie?

    Suggestions?

    What about Calligra, Sqlite, Firebird, or MySql-workbench?



    Thanks for the input.
    openSUSE Tumbleweed 64-bit / Cimmamon

  2. #2

    Default Re: What is the best newbie database app?

    Here running Firebird 3.0 on openSuse13.2 and Tumbleweed.

    see here and select desired version
    http://download.opensuse.org/reposit...k:/firebird30/

    As to newbie friendly , well, once you have the server running and permissions set
    you can write your programs to send data to the database you created.

    Firebird itself does not come with gui tools , but you can do anything
    on the command line and there are good drivers like fdb for python
    and others.

  3. #3

    Default Re: What is the best newbie database app?

    The gui tools would be kind of important. Any other thoughts?



    MySql-workbench has some missing dependencies and will not install. Any workarounds?
    openSUSE Tumbleweed 64-bit / Cimmamon

  4. #4
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,296
    Blog Entries
    2

    Default Re: What is the best newbie database app?

    Depends on what kind of data you're using and the application accessing the data.

    So, for some people
    Simply storing the data in a text file is sufficient, can be a couple columns (or even comma or tab separated).

    The next step up from a simple text file (which many apps use, don't laugh at that), a spreadsheet is a popular way to store data since they often come with sorting and query tools. The data must be flat and "de-normalized." There are whole industries built on apps that are built on spreadsheets, and MS Excel is one of the most popular way for non-technical executives to analyze data.

    If you need structured relational data, then apps like MySQL are popular and are the bedrock of powerful line of production apps. A lightweight version that supports relational database concepts but is stored in a simpler file is SQLite.

    There are also NoSQL databases like MongoDB that can provide much of the power of traditional relational databases like MySQL but without fixed database schemas which make them more flexible for various uses, particularly for queries (which often have different objectives than line of production apps).

    There are key-value pair databases which are useful for their high performance and simplicity, although usually run purely in RAM some also can have disk-based backing.

    So,
    As you might see there are a great many types of databases that can store and perform a great many ways, even for small apps (the examples I mention). I didn't even start to mention examples of these types of database that can scale up and out for large data-intensive use.

    When you say you need something to "track some information," the details and size would affect an optimal selection... How complex is the data? How many simultaneous users? Deployed on a limited resource device or a desktop or a larger server? Running only on one machine or a distributed application where different parts of your app might be running on different machines? Is this a simple, personal app or an app to be offered to others, maybe even commercially? What coding language app is your app written in, and are there pre-built database connectors or middleware to simplify how your solution is built?

    And there may be more considerations when you select something to be your database...

    HTH,
    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  5. #5

    Default Re: What is the best newbie database app?

    Thanks for the reply.

    I am managing a sports club. It contains 3 teams. I am currently using a spread sheet, but it is a monster and really need to build a relational dB. I am tracking personal information, inventory, player stats, player equipment, fund-raising, summer camps, prospects and expenses. Over the past couple of years it has gotten too complex for the spread sheets.

    Initially it would start as a single user database that would allow me to better manage the team.

    Stage 2 is to place a web based portal on line that could be accessed with permissions for player or coach input. I would like to limit access based on passwords.

    Anymore information you need, please let me know.
    openSUSE Tumbleweed 64-bit / Cimmamon

  6. #6
    Join Date
    Jun 2008
    Location
    Podunk
    Posts
    26,864
    Blog Entries
    15

    Default Re: What is the best newbie database app?

    Quote Originally Posted by idee View Post
    Thanks for the reply.

    I am managing a sports club. It contains 3 teams. I am currently using a spread sheet, but it is a monster and really need to build a relational dB. I am tracking personal information, inventory, player stats, player equipment, fund-raising, summer camps, prospects and expenses. Over the past couple of years it has gotten too complex for the spread sheets.

    Initially it would start as a single user database that would allow me to better manage the team.

    Stage 2 is to place a web based portal on line that could be accessed with permissions for player or coach input. I would like to limit access based on passwords.

    Anymore information you need, please let me know.
    Hi
    I would suggest using LibreOffice then (sqlite I think?), at least for the integration for any reports and such, form letters etc can be pumped out on writer and calc.
    Cheers Malcolm °¿° SUSE Knowledge Partner (Linux Counter #276890)
    SUSE SLE, openSUSE Leap/Tumbleweed (x86_64) | GNOME DE
    If you find this post helpful and are logged into the web interface,
    please show your appreciation and click on the star below... Thanks!

  7. #7
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,450

    Default Re: What is the best newbie database app?

    For the sorts of things you eventually want to do MariaDB is your best option, not least because it allows you to limit access to database table columns which is going to be essential for player/coach access. I am not aware of a non-SQL which allows this option.

    If you have a WordPress, Drupal or Joomla! website, you might be able to use CiviCRM as the basis for your web portal - they all rely on mysql files and so you could import whatever you had developed.

  8. #8

    Default Re: What is the best newbie database app?

    I have installed MariaDB. What would you recommend as a gui tool? frontend?

    Heidi? dbForge?

    MySQL-workbench won't install, missing proj dependency.
    openSUSE Tumbleweed 64-bit / Cimmamon

  9. #9

    Default Re: What is the best newbie database app?

    do you know anything about Navicat?
    openSUSE Tumbleweed 64-bit / Cimmamon

  10. #10
    Join Date
    Oct 2009
    Location
    Sweden
    Posts
    1,015

    Default Re: What is the best newbie database app?

    Quote Originally Posted by idee View Post
    I have installed MariaDB. What would you recommend as a gui tool? frontend?

    Heidi? dbForge?

    MySQL-workbench won't install, missing proj dependency.
    Hi!

    What about phpMyAdmin (( https://www.phpmyadmin.net/ )exist as a package in Leap42.1))? It does solve some things as a gui för sql. I also recommend as malcolmlewis above to use Libreoffice Base and Calc for reports.

    regards
    I'm shameless like others in the forum -was I to any help or made sense? If yes: click the on the star below to the left. Written whit a ;-) in my eye.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •