> 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 B
> 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: http://sqlk
> 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 P
> 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 writ
> 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 transac
> > 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 2
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?
> Syn
> >> 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 th
> > 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...?)
> 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*
> >> 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 ab
> 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 usefu
> 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 y
> 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 availabl
> 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) wit
> 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 d
> 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 m
>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
> 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 lis
> > 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
> 1) First, in LedgerSMB,
What a pity that this is implemented in a write-only programming
language and as a "web application" instead of an actual GUI...
> we started using it to create consistent interfaces to sets of
> storage tables. The storage tables would behave differently, but
> w
> > 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
> 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
> 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 (pgsql-general@postgresql.or
> >> 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:
> >
> > http://www.sqlalchemy.org/trac/wiki/UsageRe
re's a pretty 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 in
> 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:
http
e same
string in one language will be different in other languages.
TIA,
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
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:
http://www.postgresql.org/mailpref/pgsql
> 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
> 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
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 (pgsql-general@postgresql.
re developer of Postgres? :-)
Sincerely,
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
tus_type_key_type,
PRIMARY KEY (db_key)
)
;
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
dministration" must be taken into account. A dedicated individual
just for that is simply out of question 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 feasibl
c.) on the same 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)-
c.) on the same 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)-
nd make 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
d also simplify mapping it
to a logical model in Python quite a bit.
TIA,
Sincerely,
Wolfgang Keller
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
erely,
Wolfgang Keller
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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
about them?
TIA,
Sincerely,
Wolfgang Keller
--
P.S.: My From-address is correct
---(end of broadcast)---
TIP 6: explain analyze is your friend
of as
being the "best of their breed" from personal experience through using
them on a daily basis to earn my living simply wouldn't exist - as they
have all been implemented by people who don't have a CS degree.
And I'm not talking about trendy webcrap
ive but MacOS cannot now run without firewire on a 4
> year old 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)---
T
ever one chooses to learn, if it is tied to
> Windows, then its future is tied to the whims of Microsoft.
Not necessarily.
With Pyhon and wxWidgets or Qt, you can easily work on Windows, Linux,
*BSD (and MacOS and Windows CE and PalmOS and your series 60 Nokia
mobile phone and and and)
, 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
