On Fri Aug 20 05:10 PM, Wang, Mary Y wrote:
>
> So my questions are:
> (1) What is the best character encoding that would work for most of
> those languages that have accent marks?
Store data in PostgreSQL as UTF-8
> (2) I assume that I also
> need to do some kind of conversion in the front end
Is there any documentation of the binary format of the 'base' tables?
I found that I can find where a table's data stored with:
SELECT oid FROM pg_database WHERE datname = current_database();
SELECT relfilenode, reltoastrelid FROM pg_class WHERE relname = 'table';
/usr/local/pgsql/data
On Thu Apr 16 05:06 PM, Bill Moran wrote:
>
> The problem comes when the company head wants to search through the
> database to find out which employee has a specific SSN. He should be
> able to do so, since he has access to everything, but the logistics of
> doing so in a reasonable amount of
On Wed Oct 22 10:16 AM, Andrus wrote:
> Jonathan,
>
> Thank you.
>
>> For PHP, your best option is http://www.magentocommerce.com/ --
>> http://svn.magentocommerce.com/source/branches/1.1
>
> Magento is only for MySql.
Wow that's too bad/sad for the mySQL only. At least they are using innoDB.
On Wed Oct 22 07:01 AM, Andrus wrote:
>
> I have looked some PHP source code archives without success yet.
>
For PHP, your best option is http://www.magentocommerce.com/ --
http://svn.magentocommerce.com/source/branches/1.1
I've never used it but it's 'clean' code with commercial backing.
On Tue Sep 16 08:40 AM, Bill Moran wrote:
> In response to Tom Lane <[EMAIL PROTECTED]>:
>
>> Bill Moran <[EMAIL PROTECTED]> writes:
>>> What I'm _asking_ is why would extending SECURITY DEFINER to include
>>> preventing unauthorized users from viewing code _not_ be a valid
>>> method of securin
On Fri Jul 25 02:20 PM, Andrew Sullivan wrote:
> On Fri, Jul 25, 2008 at 01:41:50PM -0400, Jonathan Bond-Caron wrote:
>
>> Uhm, let's not start a PHP debate.
>
> The post would have been more effective if you'd stopped there ;-)
Agreed :)
> That said,
>
>
On Fri Jul 25 01:03 PM, Joshua D. Drake wrote:
> On Fri, 2008-07-25 at 12:29 -0400, Bill Wordsworth wrote:
>> Obviously he is a newbie out of the woods- couldn't make a connection
>> and print results something that the rest of us have been doing for
>> years. It is newbies like him and fan-boys
to_ascii() and utf8 characters
SELECT to_ascii(convert_to_latin('ÀÁÂÃÄÅÒÓÔÕÖ'), 'LATIN1')
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: July 25, 2008 10:42 AM
To: Alvaro Herrera
Cc: Jonathan Bond-Caron; 'Fco. Mario Bar
This would probably help:
CREATE OR REPLACE FUNCTION norm_text_latin(character varying)
RETURNS character varying AS
$BODY$
declare
p_str alias for $1;
v_str varchar;
begin
select translate(p_str, 'ÀÁÂÃÄÅ', 'AA') into v_str;
select transla
I'm been reading up on FOR UPDATE NOWAIT and it looks like it was added in
8.1.
How difficult is it to add FOR UPDATE SKIP LOCKED or something similar?
(basically skip locked rows / oracle syntax)
More background here:
http://forge.mysql.com/worklog/task.php?id=3597
It would be quite u
Application defaults go in the application code not in the database (my
opinion).
If you wants user, group, whatever customizable defaults, they belong in the
database schema i.e. table user_prefs or role_prefs
For your question about "backwards compatible database", in most cases apps
and datab
There is https://priorart.ip.com/ to make claims to novel ideas (this costs
money).
I also share the idea that it would be amazing if companies could get
together and fund a non-profit that would hold a "patent portfolio"/ideas of
open source projects and their contributors. I'm no lawyer, but th
If youre looking for a PHP solution, theres:
http://ezcomponents.org/docs/api/latest/introduction_DatabaseSchema.html
Its very limited but works for simple schemas, I begun extending it to
support more rigorously SQL-92 schema information (will be released BSD
license at openmv.com).
"My premise is that someone will do mistakes in the php code and I'd like to
mitigate the effect of these mistakes."
- Prepared statements is the only "bulletproof" technique
- You can use a database abstraction layer (there are more than many
libraries for PHP) Fast to implement, all queries goe
I'm in the same boat, looking for master-slave replication for 1 master & 2
'standby' read-only servers (one would get promoted to master in case of
failure).
I recently read about WAL here:
http://developer.postgresql.org/pgdocs/postgres/warm-standby.html
The standby server is not available for
16 matches
Mail list logo
