Info regarding integrating a barcode reader with PostgreSQL

Started by Sullivan,Deric [CMC]almost 25 years ago3 messagesgeneral
Jump to latest
#1Sullivan,Deric [CMC]
Deric.Sullivan@ec.gc.ca

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

#2Alex Pilosov
alex@pilosoft.com
In reply to: Sullivan,Deric [CMC] (#1)
Re: Info regarding integrating a barcode reader with PostgreSQL

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:

Show quoted text

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

#3John Burski
John.Burski@911ep.com
In reply to: Sullivan,Deric [CMC] (#1)
Re: Info regarding integrating a barcode reader with PostgreSQL

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