I have connected my Base to MySql. Can you please clarify which tasks must
I perform in Base and which ones in MySql..............for example....I
guess I must create tables in MySql.......what about "Forms" and "Queries"?
Where must I make the data entry? Sorry.....total newbie!!(and intermediate
Filemaker user)
What version of MySQL are you using? The answer to this determines what you should do and how.
Tables and their data are kept within MySQL. Forms, queries, views, and reports are created within the Base file you use to connect to MySQL.
Databases and schema must be created within MySQL. How this is done depends upon the answer to my first question. A database must be created first. Then the schema for the database are created second. After creating the schema, you can use Base to create the tables for the schema.
You have probably heard the advice RTM (read the manual). Well, you need to get a manual for the version of MySQL that you are using.
I use MySQL 5.5 and the program, Workbench, is what I use for all administrative tasks for MySQL. When I used MySQL 5.1, I used mysqladmin to do these things.
--Dan
[quote]What version of MySQL are you using?[/quote]
$ which mysql
/usr/local/mysql-5.6.11-osx10.7-x86_64/bin/mysql
[quote] Tables and their data are kept within
MySQL.........................After creating the schema, you can use Base
to create the tables for the schema.[/quote]
Confusing.....tables are to be created in MySQL or BASE?
Hi
That is a good question.
Ultimately the Tables 'should' be in MySql (or whichever back-end you are using). One thing i don't know is if you can use the nice GUI front-end in Base to create the Tables and find the Tables are automatically in the external back-end. If it does work that way then it greatly reduces complexity by hiding the complexity away from the Database Designer.
Ian, Alex, Dan, anyone any idea?
Regards from
Tom
Hi
Found the answer to my question ...
Dan Lewis wrote
<snip />
Databases and schema must be created within MySQL.
<snip />
--Dan
Thanks Dan!
Regards from
Tom
I have sent my procedure to Rounak off-list and replied to a couple of his questions.
AFAIK once you have got ONE Table in MySQL and "Linked" to it you control everything with Base and any new tables created are in MySQL.
At least that's what I see here!!*
*IanW
Pretoria RSA*
Hi
Wow!!! That sounds good
Thanks Ian.
Regards from
Tom
Hi Tom, all,
Wow!!! That sounds good
Thanks Ian.
Unfortunately not true. There are mysql objects you can not create from
within LO Base, even if you have already got one table defined.
An example : try creating a table with a tinyint autoincrement field in
LO Base using mysql backend and see if your table definition
sticks/works properly - it doesn't (or at least it didn't last time I
tried).
Try adding a field to an existing table at the position where you want
it - it won't work.
Try defining DEFAULT values using mysql builtin functions (e.g.
CURRENT_USER) in your fields via LO - that won't work.
Try defining a view using CAST statements in LO and watch it fail
because there's a mismatch between what LO promises and what it can
actually do.
For all of these things and more, you need to know how to manipulate the
mysql backend from the command line or from a graphical UI tool, such as
mysqlnavigator (Linux), or MySQL Workbench (multi-OS graphical tool for
managing and manipulating your mysql servers and data)
LO Base is not FMPro (unfortunately), nor Access, not Lotus Approach,
and I seriously doubt that it ever will be.
If you are working on Mac, as the original poster seems to be, the
situation is even less evident for the user who has been used to working
with FMPro. FMPro is user friendly, and even Bento is user-friendlier
than LO Base, but FMPro now costs you an arm and a bloody leg, and Bento
is not for networked, multi-user sharing (at least from what I have seen
so far).
Alex
Hi,
I have connected my Base to MySql. Can you please clarify which tasks must
I perform in Base and which ones in MySql..............for example....I
guess I must create tables in MySql.......what about "Forms" and "Queries"?
Where must I make the data entry? Sorry.....total newbie!!(and intermediate
Filemaker user)
Unfortunately, you will have a big shock with LO Base if you are moving
from FMPro. There will be a steeper learning curve, and much frustration.
I migrated from Mac FMPro to mysql/Base nearly 10 years ago, but I
didn't have sophisticated needs with regard to UI, and I learnt the hard
way how to create/manage/work with my data and mysql from the command line.
Alex
[quote]FMPro is user friendly, and even Bento is user-friendlier
than LO Base, but FMPro now costs you an arm and a bloody leg[/quote]
My feelings too. Thats what made me look for an alternative. But Base has
begun to disappoint me if all this is STILL true:
http://forum.openoffice.org/en/forum/viewtopic.php?f=61&t=6025#p53756
Yes, this is still true. As I mentioned previously, the Base UI
promises, but doesn't deliver. It is not entirely without interest, but
it certainly doesn't satisfy my definition of a user friendly (and
functional) UI.
Alex
Hi All
I'm sure Alex is right - so thanks for pointing out the 'bits' that don't work from Base!!
As a "plain ordinary - everyday" Front-End I have so far found Base to be adequate... so far (??) But I note the comments made. Must say I've been busy with other things for some days and have not been able to press-on with my development.
I wonder what Front-End _YOU_ use Alex?? Would be interested to know. ("m NOT on a Mac but on Linux (PCLOS 2012).
IanW
Pretoria RSA
Hi Ian,
I wonder what Front-End _YOU_ use Alex?? Would be interested to know.
("m NOT on a Mac but on Linux (PCLOS 2012).
I mostly use sql from the command line
or MySQL Workbench :-))
I have used Base in the past (with OpenOffice.org) for a simple UI with
a few list boxes and automatically generated (macro activated) combo
lists, to an internal work database I'd set up for my former law firm,
but I separated out the forms from the ODB file, because it gave me
greater flexibility (most notably with shared access to forms and
queries residing on a central network share).
Most of the db stuff I've worked with recently uses mysql, PHP and the
Zend Framework, or CRUD frameworks (cakewalk, etc).
I'm also exploring other UI alternatives, such as Dabo :
I don't need the single "all-in-one wrapped up" file that is currently
proposed with Base, I'm not bothered about not having everything under
one roof. This is also why I'm not too bothered about the LO Base UI not
working as it was supposed to, as I design around it.
Alex
There are mysql objects you can not create
from within LO Base, even if you have already got one table defined.
*Any* "generic" (i.e. not vendor-specific) database
design/development/etc. tool will always only cover a lowest common
denominator in terms of functionality.
LO Base is not FMPro (unfortunately), nor Access, not Lotus Approach,
and I seriously doubt that it ever will be.
I would never trade PostgreSQL with any of those.
And if LO could get around to publish tutorials and handbooks
for PyUno together with Base, that could be "quite helpful", since both
LO Base and PyUno are at about The Best Kept Secrets Of
LibreOffice/OpenOffice. Together with Calc for reporting and R
(http://extensions.services.openoffice.org/project/R4Calc) for
statistical analysis, this could be a "killer" application for LO/OO
in corporate environments.
Sincerely,
Wolfgang
Hi :)
Funny you should say that. Work has been going on to translate the Handbook from German.
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook
The Faq had it's Base section finished ahead of all it's other sections
https://wiki.documentfoundation.org/Faq#Base
The Publications page has the first couple of chapters of the full guide but each chapter is large enough to almost be a full guide on it's own. There is just too much to say about each stage.
Plus this list has been very helpful to pretty much anyone asking about Base. All that without even looking towards OpenOffice forums where they have sections dedicated to Base.
Ok, it's still not enough but it's not really all that secret either now.
Regards from
Tom
Funny you should say that. Work has been going on to translate the
Handbook from German.
I was talking about a handbook about PyUno, particularly together with,
but not limited to LO Base.
Sincerely,
Wolfgang