Thread: Info regarding integrating a barcode reader with PostgreSQL

Info regarding integrating a barcode reader with PostgreSQL

From
"Sullivan,Deric [CMC]"
Date:
Hi,

    I'm looking for details on how to integrate a barcode reader (e.g.
one from Symbol) with a PostgreSQL database.  Currently I use PostgreSQL
7.1.2 as the backend and psql, pgaccess, pgAdmin v7.1.0 (on Windows),
phpPgAdmin as the frontend(s).  The backend, a couple of the frontends, and
the PHP enabled web server run on a Linux workstation.  I'm new to the
details of barcode readers so I'm also looking for hints on how to get a
barcode reader hardware working on a Linux system.  Any help would be
appreciated.


Thanks,
Deric Sullivan
Deric.Sullivan@ec.gc.ca


Re: Info regarding integrating a barcode reader with PostgreSQL

From
Alex Pilosov
Date:
This is definitely not a pgsql question.

Barcode readers usually have a keyboard interface, where they plug in
between keyboard and host. When a reader scans a barcode, it sends
'keystrokes' to the host...

Alternatively, they can be connected as serial device, outputting data
when they see a barcode.

On Mon, 9 Jul 2001, Sullivan,Deric [CMC] wrote:

> Hi,
>
>     I'm looking for details on how to integrate a barcode reader (e.g.
> one from Symbol) with a PostgreSQL database.  Currently I use PostgreSQL
> 7.1.2 as the backend and psql, pgaccess, pgAdmin v7.1.0 (on Windows),
> phpPgAdmin as the frontend(s).  The backend, a couple of the frontends, and
> the PHP enabled web server run on a Linux workstation.  I'm new to the
> details of barcode readers so I'm also looking for hints on how to get a
> barcode reader hardware working on a Linux system.  Any help would be
> appreciated.
>
>
> Thanks,
> Deric Sullivan
> Deric.Sullivan@ec.gc.ca
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
>


Re: Info regarding integrating a barcode reader with PostgreSQL

From
John Burski
Date:
What kind of interface do your barcode readers use?  If they are a "keyboard
wedge" style there shouldn't be anything specail about connecting them and
making them operational - they fit between the keyboard and the I/O socket on
your computer.  We've used ID Tech barcode/magcard readers for a couple of
years that have this interface with no problems - they have connectors for
both 5-pin DIN and 6-pin mini-DIN connectors.  You may have some issues
pertaining to configuring which barcode patterns they recognize, but those
issues should be covered in any manuals that are supplied.

Good luck!

"Sullivan,Deric [CMC]" wrote:

> Hi,
>
>         I'm looking for details on how to integrate a barcode reader (e.g.
> one from Symbol) with a PostgreSQL database.  Currently I use PostgreSQL
> 7.1.2 as the backend and psql, pgaccess, pgAdmin v7.1.0 (on Windows),
> phpPgAdmin as the frontend(s).  The backend, a couple of the frontends, and
> the PHP enabled web server run on a Linux workstation.  I'm new to the
> details of barcode readers so I'm also looking for hints on how to get a
> barcode reader hardware working on a Linux system.  Any help would be
> appreciated.
>
> Thanks,
> Deric Sullivan
> Deric.Sullivan@ec.gc.ca
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl

--
John Burski
I.T. Manager and Systems Administration
911EP
First in LEDs... The solid state warning light leader.
1-800-863-6911