This is one way Base is more powerful than Access.
That's the whole point.
By not focusing on promoting Base as *the* generic client-side FOSS tool
for access to client-server RDBMs, they're missing a *HUGE* opportunity.
And since Rekall has vanished (despite being GPL), there's not much in
Using LinuxMint v17.0 Qiana qith the MATE DE.
Have followed with interest the recent discussins on Base and have
decided to try and learn how to use it, using PostGreSQL as the
backend. But - and there is always one of those :-) - how many of
the multitude of postgrsql files in Synaptic do
Bullshit. There are plenty of cross-platform RDBMSes that are not
implemented in this grotesque proprietary abomination that Java is.
My comment, or Sun's decision ?
Sun's decision. Compulsive Javamania.
There are bulkloads of programming languages and frameworks that allow
cross-platform
I know that its not LO base specific but can,t find a way how to or
example of something like this.
What i want using cars as example is to make a search for
color,year,doors,model.kilometers driven,cabrio,engine,fuel and so
many more options.
Who can help me on my way how to set somthing
A database like MySQL and mariadb cache the updates and then write
them to disk every 1/2 to full second (or however configured). Seems
like a good idea.
I wouldn't consider MySQL and its descendents as good references for
data integrity.
So I come back to my suggestion earlier today - LO
As I recall, at the time of the release of OpenOffice2, it had to be
like Access
Braindead.
- but of course, as Sun was mainly running the show, that
meant that it had to be multi-OS, thus Java based
Bullshit. There are plenty of cross-platform RDBMSes that are not
implemented in this
Average end-user is challenged enough just installing an O/S and
productivity suite, and learning how to use them, much less a real
RDBMS.
PostgreSQL is pretty foolproof to install and use. I know what I am
talking about since I am the reference fool.
It may be something different if you need
1. How robust are embedded Base files created by the GUI?
With an embedded database, any bug in the application (doesn't
even have to crash) can corrupt your data.
With a client-server database, it's essentially impossible for the
client to corrupt the data.
2. If they are not that reliable,
All the database experts and many others of us keep on recommending
using an external back-end such as Postgresql, MySql/MariaDb or
anything else.
The devs are working on removing the current warped and ancient
version of HsqlDb and replacing it with Firebird.
Using the embedded version of
I have been collecting data for over a year in Calc. I will be
rolling over to Base to use the data more effectively.
One word of free advice: Avoid the built in database engine. Use an
external client-server RDBMS. It's so much safer. The driver for
PostgreSQL comes with LO. Embedded database
The ones where Urmas does help are often highly technical. That
raises the question of whether Urmas is a dev and just socially
clumsy as so many are. Apparently Microsoft have recognised that many
engineers and devs have high functioning aspergers syndrome or,
even further along the
I don't have a clue how to connect to a specific schema within a
PostgreSQL database though, LO only seems to be able to connect the
default schema.
Perhaps this might help: (chapter 5.7)
http://www.postgresql.org/docs/9.3/static/ddl-schemas.html
The point is not how to create a
may I ask a question in line with that thread:
a few month ago, I failed installing LO-base with PostgreSQL-DB when
I stumbled over the input request
URL of data source ?
Since the PostgreSQL SDBC driver uses the native PostgreSQL protocol
(way more efficient than such kludgy crutches as
I'm new user of LO Base, we are transitioning from MS Access, and I
need to redesign our db from it.
One word of advice based on experience:
Avoid use of the built in database.
Use a proper client-server RDBMS. Preferrably PostgreSQL, as it's
reliable and the driver comes with LO.
Otherwise
At the risk of beating a horse to death, today I stumbled on an
online rant against MS-Word.
http://www.antipope.org/charlie/blog-static/2013/10/why-microsoft-word-must-die.html
While the entire blog is worth reading,
But in the mind of a reader who doesn't know better from personal
Perhaps, we could get folks past the Underwood model if office suites
stopped offering that as a legitimate option for creating typeset
documents.
*Proper* document processing software should indeed *enforce* total
separation of structure(d content) and style information through
*exclusive*,
As you can tell I'm new to spreadsheets and computers in general,
thanks in advance for your help and patience.
You want to use a relational database.
Sincerely,
Wolfgang
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Has anyone else been getting duplicate messages from this list? For
the past couple of days, I have been receiving messages from this
list that I had already received 2-3 days earlier.
Didn't you post that question yesterday already?
;-)
Sincerely,
Wolfgang
--
To unsubscribe e-mail to:
I want save my time.
Not defining a primary key *will* cost you a *lot* of time.
In fact it's such a sick idea not to define one that sane RDBMSs don't
even allow it.
Sincerely,
Wolfgang
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
With Python and a decent RAD framework (there are quite a few), you
don't need to implement anything like that yourself.
and a decent RAD framework (there are quite a few)
Really??? Name *ONE*.
using PyQt ( Sqlalchemy):
Qtalchemy: www.qtalchemy.org
Camelot: www.python-camelot.com
My question now is - Where does MySQL store the Database and how do I
track it down to make a backup??
You'll have to use the MySQL administration tool for that. LO only sees
a server running at an IP address listening to a specific port. It has
no means to know where the data is.
And I still
Just a quick question - when on this list (users), shouldn't we keep
the sender's email in the To / Cc list when we reply-all
No.
in case they haven't subscribed to the list (which makes sense if
they're just looking for support and not for helping others out).
A mailinglist allowing
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
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
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
Late last year I converted to MySQL as the Backend and Base as the
Front End. WHAT A DIFFERENCE As I said to people it's like
getting out of your old broken-down, unreliable Beetle and driving
around in the latest Rolls Royce!! Solid, fast, never crashes and is
just fantastic!!
MySQL
I have a good Arabic font but it's in Arabic. I've got to get a
poster together for an Arabic ladies coffee morning and having
trouble finding a font that looks vaguely Arabic but is in fact
English. DOes anyone know of a good free one?
https://www.google.de/search?q=arabic+looking+font
I never even try to share documents between different programs, such
as Word and LO or OO.
I never even try to share documents between two users using both the
same program *and* the same document template, if the program is Word
(or LO /OO). With these applications, the re-use of content is
At one client, this week's production check-in of an application
developed in MS Office (mostly Access) 2007/2010 code is now up to:
110,315 LOCs, 380 Modules, 249 Stored Procedures, and counting...
They probably need that much code because VBA is so poor (while
also being quite vociferous),
Do you use styles?
The point with OO/LO is that unfortunately, like Word, its style concept
does not allow to work in the structure markup way.
So, even if you tried to use styles consistently, you wouldn't be able
to benefit from it the way you can with e.g. LyX/LaTeX or document
processors
If LO Base is not enough for you because you need more application
logic, then there are two VFP developers who have implemented their
own successor to VFP. Cross-platform, open-source, free. It's
called Dabo (www.dabodev.com) and it uses Python as the programming
language. If you've
May I suggest you to contact Kexi main developer, Jarosław Staniek,
with this proposal? You will find his e-mail address here:
I'm subscribed to the Kexi mailinglist, and the subject has been
regularly invoked by various users there.
Without composite keys you can't even implement M:N
I don't know if it will be suitable, but you can try Kexi (part of
Calligra suite, I believe; but you can install it separately). I
heard it is much better than LO Base, but I don't know enough to
verify that statement.
Kexi will become usable as soon as it supports composite (natural) keys.
I am still waiting for a database program that will allow
me to create applications (not pieces of applications, like queries
and forms) without having to learn C (this old dog is not going to
learn that new trick!).
If LO Base is not enough for you because you need more application
logic,
If I'm incorrect, please let me know what is correct - but I'm pretty
sure that someone with some PyUno skills will be needed.
I would guess that those are rare, since PyUNO is at about the best
kept secret of LO(/OO).
Sincerely,
Wolfgang
--
For unsubscribe instructions e-mail to:
Via Simon Phipps on Twitter:
We're rewriting the LibreOffice wizards in Python
because we can no longer be sure Java will be there
-- Michael Meeks, #FOSDEM
Hopefully then Python will replace Basic too. And maybe there might even
be some documentation for LO/Python some
MS has always been at the antipode of ergonomics. And they keep
moving in the *wrong* direction. Ribbons ... are just the latest
cerebral flatulances
emanating from their product managers' brains.
Lol!
This is *not at all* fun for those screen-labourslaves who are
concerned. By
Lol! I liked that post. Very funny.
The reality is much less funny for all screen-labourslaves who have to
work in those pathologically dysfunctional organisations.
I thought PostgreSQL was for large databases?
It's for anything.
Also i thought Firebird was supposed to be quite good?
I have heard that corporates love to have their valuable data in java
based backends
That's because corporations are intrinsicly dysfunctional organisations
that promote opportunist egomaniacs who have no competence in any other
field than careerism into those positions where they can cause the
I have the following -
A Members Table called 'Members' with
* The Key being 'RecordID'. INT, Auto,
* Plus the rest of my 70-odd fields.. (This table comes up
in my Main Form)
70 fields in one table? Sounds like this database may be de-normalised:
But Ooo/LO does use structure markup. All .odt/.ods documents are XML
files.
XML is just syntax. It does not necessarily imply structure markup, as
shown by e.g. .docx and .odt. Just unzip an .odt document and open
contents.xml in a XML editor to see what spaghetti xml looks like.
Sincerely,
I use it at the office for time registration and invoicing. At home
for the Taekwon-do club membership.
Should I perceive that as a threat? ;-
It's actually marvelous in combination with postgresql SDBC driver.
And actually useful as it is so easy to get your data to Calc, more
useful then
that's the way it is and that's why currently I don't use LO Writer
for anything else than for converting .doc files to .pdf
I might just be something a little bit above a IT moron but using LO
Writer to convert doc into pdf appears to me like using a tractor to
participate in a F1 race or
Everything that you get from LaTeX: structure markup instead of
spaghetti formatting, parameterized formatting, etc...
Instead of clicking through dozens of dialogboxes for each and every
line of text, slide title, list item, figure, etc. to get
everything the way you want it, you just
Just like MSAccess, Base is extremely useful as a frontend for
database engines.
The last time I tried to run a non-trivial query (involving a join) from
Access against PostgreSQL, the result was a never-ending cursor
animation. It seems that Access fetches *all* records from the database
and
Since the average IQ is around 60 (or something utterly abysmal like
that) i don't think intelligent decision-making really entered the
equation.
The average IQ is - per definition - equal to 100. It's even calibrated
to be a normal distribution.
Sincerely,
Wolfgang
--
For unsubscribe
I think the market share of MSO has nothing to do with the users
being idiots or not. The 90% share is caused by 3 things
*snip*
2 - Not many people know about alternatives.
That's what I call ignorance. Ignorance plus unwillingness to inform
oneself to remedy that ignorance equals idiocy.
If MSO is a 90% market leader all its users cannot be complete idiots.
cynism
Thank you for this statement that clearly illustrates the typical
pointy haired think (i.e. un-think) of leaders (and their
followers).
The very simple fact is: LibO has to become better in a SWOT
analysis!
And
Is there any documentation for LibreOffice Base?
In german language, yes.
http://wiki.documentfoundation.org/images/d/d4/06_BH_Gesamtband_V35_einseitig.pdf
It's probably in the process of being translated.
Sincerely,
Wolfgang
--
For unsubscribe instructions e-mail to:
In many (most) companies/organizations (other than IT) the managers
have quite little own knowledge in IT why they do not have many
alternatives: they have to buy the IT from outside (more or less)
experts or build up a IT-dept of their own.
Dedicated IT departments are well known and well
A.so in your opinion people - both young and old - not yet
knowing anything about computers, perhaps buying their first unit,
are - not only IT-illiterate but also morons
The point is not whether someone is IT-illiterate or not, but whether
(s)he is aware of the limits of his/her IT
Just had a classic from my boss.
*snip*
He still says there is no problem with IE.
The point is not that there are plenty of hopelessly IT-illiterate
morons out there, the point is imho that it's exactly these
IT-illiterate morons who decide about what those people who have to do
the actual
- actually useful formatting concepts for presentations like e.g.
LaTeX Beamer provides.
Could you elaborate? I don't know Beamer (I have heard the name, but
never really used it) and I am interested in knowing what it has to
offer that LO is not capable of.
Everything that you get from
As an engineer, now retired, I used BASIC for many years, then took
a class in Pascal and wrote some code in Pascal. You are correct--
all I wanted, in almost all cases, was command-line input and screen
or print (or both) output. I first wrote BASIC on a teletype machine
connected by
On 18/09/2012 at 20:13, Doug dmcgarr...@optonline.net wrote:
Note, too, that the old argument, I bought it,
so it's mine, will be out the window--if it's rented, it clearly
is not yours to copy, etc.
As far as I remember, it was never yours. Most EULAs forbid e.g.
reselling of box
What language one first learns is often determined by what is used in
the Introduction to Programming courses and of course when you took
the course. I know a few colleges used VB for their introductory
course in the States.
If I was looking for a university for studying computer science,
My guess the group that complains the most about switching because of
macros would be the second group
Objection.
The point is that those people who actually use office software in
companies have absolutely no influence on what they work with. It's the
manangsters and administrictators who
Most features one needs have been include in office suites since the
some time in the 90's. I can not think of a feature that I want see
implemented that is not already implemented.
Objection.
instead of braindeadly cloning MS features, which are mostly based on
cerebral flatulances emanating
available for free that will keep your data safer (from
corruption) than PostgreSQL.
You don't even have to install PostgreSQL to use it, but of course it
will be more convenient to use then.
Sincerely,
Wolfgang Keller
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
58 matches
Mail list logo