H2 or SQLite can be very reasonable choices for in-app embedded
databases, so long as your app can operate within their constraints on
concurrency and data size.
Firefox uses SQLite and the places.sqlite database is notorious for
getting corrupted every five minutes. Libreoffice/Openoffice
This is now my ranked shortlist which I will evaluate further:
1. Camelot: http://www.python-camelot.com - PyQt
2. Dabo: http://www.dabodev.com - wxPython
3. Gui2Py: http://code.google.com/p/gui2py/ - wxPython
4. Kiwi: http://www.async.com.br/projects/kiwi - PyGTK
5. Sqlkit:
Q1 = Can anybody recommend a desktop GUI tool (preferrably open
source) for PG with customizable forms like Access or FileMaker?
Without programming:
- LO/OO Base: www.libreoffice.org, www.openoffice.org
- Kexi: www.kexi-project.org
- Rekall is apparently dead, unfortunately.
Using Python:
2. With sync replication, you have coordination problems and
therefore it is never (at least IME) a win compared to master-slave
replication since all writes must occur in the same order in the set,
or you need global sequences, or such.
*snip*
You will never get better read or write
It looks like it's been morphed into TED, the TransLattice Elastic
Database. From their FAQ[1]:
TransLattice Elastic Database (TED)
What’s the basis of TED? Did you write it from scratch?
We started TED from PostgreSQL, a very robust, open-source,
ACID-compliant, fully transactional
Instead it lists Postgres-R, which has been in koma for how long
now... Can't even remember any more.
Nope, it is actively developed and sponsored by Translattice.
Actively developed?
http://www.postgres-r.org/ lists the last entry in the column News on
the right with a date of
I should have cross-posted this to pgsql-docs from the beginning, sorry
for the mistake.
For pgsql-docs readers:
The issue is that the official documentation misleadingly omits the
existence of Postgresql-XC:
http://www.postgresql.org/docs/9.3/static/different-replication-solutions.html?
postgresql-xc is not postgresql, its a fork.
It would at least merit being mentioned in the doc, just like other
forks or whatever you may call it, as long as they're open-source.
You seem to not realize how many forks of Postgres there are.
I had mentioned just one.
And that one does
http://www.postgresql.org/docs/9.3/static/different-replication-solutions.html?
Synchronous Multimaster Replication
*snip*
PostgreSQL does not offer this type of replication (...)
Now I compare that statement with:
http://wiki.postgresql.org/wiki/Postgres-XC
Project Overview
*snip*
Seems to me that the editing process of the different parts of
postgresql.org somewhat lacks transactional semantics.
postgresql-xc is not postgresql, its a fork.
As an end-user, why would I care.
Since, besides that it's still open-source (even same license as
PostgreSQL itself...?),
My interpretation of Forms these days are written in HTML means
most interfaces are web front ends to the cloud. Not a GUI framework.
Cloud, web apps, yet more fashionable trendslang buzzwords.
I am talking about worktools that actually help productive information
workers to get useful work
Forms these days are written in HTML.
Only by clueless/careless morons.
HTML has never been, is not and will never be a usable GUI
framework.
And web apps are unusable garbage.
Look -- I appreciate people with strong unorthodox beliefs but your
statement above is just
I have developed an application using MS SQL. I have used MS Access
for creating forms to enter data into the database. I am thinking of
changing over to postgresql and would also like to use any other
available open source tool for creating forms. Are there any free
applications available
Forms these days are written in HTML.
Only by clueless/careless morons.
HTML has never been, is not and will never be a usable GUI framework.
And web apps are unusable garbage.
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Even with that, some clients are being encouraged to change to
PostgreSQL to lower their companies costs in technologies, but very
often they ask if there are success stories of PostgreSQL
implementations in companies in our region or around the world,
success stories (if is possible) with
I'm looking for some good visual query builder which can be used by
non-tech people for some ETL tasks. Do you have any recommendation?
Libreoffice Base?
I know it has a visual query builder and it does support PostgreSQL, but
I have no clue what it is worth, since I tend to use SQL instead.
In my db I have about one hundred tables like this:
code
description
To avoid to have a so great number of similar tables in the db
I wonder if it is a good idea to unify all these tables in one big
table like this:
id
code
table_ name
description
Bad idea.
E.g. how do you want
I have installed and configured PostgreSQL on Windows, FreeBSD, and a
few Linux flavors, but never OSX. I have the basic directions
(http://www.enterprisedb.com/resources-community/pginst-guide) and
found a couple of articles / blogs, but really I'm not an Apple guy
so I don't want to miss
For several reasons (including operational and legal) once data are
entered in a table they cannot be changed or deleted without an audit
trail of the change, when it occurred, who made the change, and the
reason for it.
Besides the need for storing additional information that the user who
Can anyone tell me which free GUI based tools are available for
creating database diagrams for my database in postgresql.
One standard answer to this frequently asked question is:
http://www.databaseanswers.org/modelling_tools.htm
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list
I need to store large files (from several MB to 1GB) in Postgres
database. The database has multiple schemas. It looks like Postgres
has 2 options to store large objects: LOB and BYTEA. However we seem
to hit problems with each of these options.
I believe the general consensus around
1) First, in LedgerSMB,
duck
What a pity that this is implemented in a write-only programming
language and as a web application instead of an actual GUI...
/duck
we started using it to create consistent interfaces to sets of
storage tables. The storage tables would behave differently,
In fact, shouldn't reasonably well-designed data models at least
mostly follow SER principles? In that case, they could be displayed
essentially
as a
tree.
No - and what the heck are SER principles?
Structured Entity Relationship model.
It means that the dependency graph does not
Concerning auto-layout, most if not all tools I have used up to now
make a mess for anything that is not dead simple.
If a data model can not be reasonably untangled by an auto-layout
algorithm (such as e.g. Graphviz) for display as a human-readable graph,
wouldn't that mean that this model is
I could not get the script sqlalchemy_schemadisplay3.py to work with
sqlalchemy 0.7.8-1 (on Debian).
Have you asked on the SQLalchemy mailing list?
http://www.sqlalchemy.org/support.html#mailinglist
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list
Can anyone advice about a tool to visualize a database schema?
SQLalchemy, a Python module, can produce dot (Graphviz) output
which you can load into your favourite diagramming application such
as e.g. Omnigraffle, yEd or Dia:
comprehensive
list:
http://www.databaseanswers.org/modelling_tools.htm
Sincerely,
Wolfgang Keller
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm looking for FOSS PostgreSQL CRUD software, preferably
Perl-compatible, which will enable me to design input forms which can
handle input to tables which reference other tables by foreign key.
Most CRUD applications I have seen so far only deal with direct, form
field to table field input
Is there any open source ERD Tool for Postgresql Database.
I find some paid tools but looking for free tools.
Free or open source? ;-
http://pgdesigner.sourceforge.net/en/index.html
http://www.db-main.eu/
http://sourceforge.net/projects/dbdesigner-fork/
And a list of a lot of others:
schema are not very useful in this case, since it
can't be excluded that depending on the context (i.e. the specific semantics of
the specific type code lookup table) the translation of one and the same
string in one language will be different in other languages.
TIA,
Sincerely,
Wolfgang Keller
Hello,
has anyone ever implemented something similar to postgresql_autodoc in Python?
TIA,
Sincerely,
Wolfgang
--
NO Courtesy Copies PLEASE!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
I'am searching for a free tool to design a Postgre Database. There is
something similar to MySQL Workbench?
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
I've tried out nearly every (affordable or free) ER tool that's available and
so far the one I like the most is
Is it better to create multi databases or create multi schemas?
You're missing one option imho: One database, one schema.
I am writing a program that can have multi instances. Sort like a finanical
accounting system that can have multiable companies. Where each company has a
different
Hello,
what would be the easiest way to generate documentation for a PostgreSQL
database in LaTeX/LyX format? Autodoc doesn't seem to support LaTeX output
directly...
TIA,
Sincerely,
Wolfgang
--
NO Courtesy Copies PLEASE!
--
Sent via pgsql-general mailing list
,
Wolfgang Keller
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
)
)
;
The objective was to make the table definitions more readable (less
fields) and to simplify the work in case the identification schema
changes.
Nonsense? Am I nuts? Is that in fact totally useless? Or is there a
better (simpler) way to achieve this?
TIA,
Sincerely,
Wolfgang Keller
in this world where I live. So
someone who's already available has to do all that in a (as tiny as
possible) fraction of his/her worktime. With MacOS X it's feasible, but
Linux/*BSD? I'm not so sure.
Sincerely,
Wolfgang Keller
---(end of broadcast)---
TIP
hardware?
And Linux to (Free-/Net-/whatever) BSD?
No flamebait, I'm just wondering whether the performance gain is worth
the learning effort required for Linux or BSD compared to the Mac.
Sincerely,
Wolfgang Keller
---(end of broadcast)---
TIP 3
hardware?
And Linux to (Free-/Net-/whatever) BSD?
No flamebait, I'm just wondering whether the performance gain is worth
the learning effort required for Linux or BSD compared to the Mac.
Sincerely,
Wolfgang Keller
---(end of broadcast)---
TIP 4
it more readable for
clueless morons like me. ;-
You can learn a lot by a few minutes of
exploration at a psql prompt.
Yes, I will have to get used to using the Postgres prompt just like I
do with the Python prompt. ;-)
Sincerely,
Wolfgang Keller
---(end of broadcast
a bit.
TIA,
Sincerely,
Wolfgang Keller
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
,
Wolfgang Keller
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
them?
TIA,
Sincerely,
Wolfgang Keller
--
P.S.: My From-address is correct
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello,
Both have trials - try it ;-)
That's what I've done, as I mentioned. But sometimes others know/see
things that I don't see/know, at least not within a restricted trial
period.
Sincerely,
Wolfgang Keller
--
P.S.: My From-address is correct
---(end
computer.
Well, Jobs doesn't want to allow it to do so, because Apple needs to
pay the fuel bills for his bizjet, I guess...
Sincerely,
Wolfgang Keller
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
.
And I'm not talking about trendy webcrap, but things which are used
daily by _lots_ of people to get _actual work_ done.
Things like Framemaker, Catia, Simpack etc...
And, btw: http://learn.to/quote
End of flameware, subthread filtered.
Sincerely
Wolfgang Keller
---(end
(and MacOS and Windows CE and PalmOS and your series 60 Nokia
mobile phone and and and) today and not worry too much about whether
(and on what system) you'll be able to use it tomorrow.
Best regards
Wolfgang Keller
--
P.S.: My From-address is correct
---(end
, maybe using
SQLite for the mobile clients.
Is there a solution which allows for automatic (but fully
user-configurable) asynchronous replication between PostgreSQL and SQLite?
TIA,
Best regards,
Wolfgang Keller
---(end of broadcast)---
TIP 6
48 matches
Mail list logo