Find Jobs
Hire Freelancers

Modification to MonetDB Database for Loading from Pipe(repost)

$100-500 USD

Terminado
Publicado hace más de 17 años

$100-500 USD

Pagado a la entrega
We are looking for someone to modify the MonetDB database code for making data loading more convenient. MonetDB is an open source database project. More details and source code can be found here: [login to view URL] They offer a client utility called MapiClient. This utility can be used to accept commands, including SQL commands using the -l option. They allow you to load data via the COPY command, from a file as shown in the example below: COPY INTO atom FROM 'PWD/[login to view URL]' USING DELIMITERS ',','\n'; or from stdin, as below: COPY 1 RECORDS INTO table1 FROM stdin USING DELIMITERS ' ','\n'; The first problem is this: when using STDIN as input, you have to specify the number of records to read in, otherwise it does not know when it is finished. This makes it inconvenient if piping in data from another process when you don't know how many records are present and wish to avoid using an intermediate file. The second problem is commiting the data. In our investigation, it appears that a "commit;" may be required afterwards if piping in. We would like this changed so that we can pipe data to MapiClient running COPY from stdin without specifying the number of records, and have the data commit. As part of the implementation, for this to work, the code may have to detect a closed input pipe and see if it was running COPY and explicitly commit the data back on the server. We want to be able to use this like this (ignoring shell escaping here): myprocess | [login to view URL] -t -l sql -h localhost -u myuser -P password -s "COPY INTO mytable FROM stdin DELIMITERS ' ','\n';" As an alternative due to the commit issue, this would be acceptable: myprocess | [login to view URL] -t -l sql -h localhost -u myuser -P password -s "COPY INTO mytable FROM stdin DELIMITERS ' ','\n'; commit;" The quality of the code should be good enough so that it can be submitted to the project and accepted as a part of the standard code base. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2)A list of modules changed and a description of the changes. 3) Deliverables must be in ready-to-run condition. All deliverables will be considered "work made for hire" under U.S. Copyright law. ## Platform Linux
ID del proyecto: 3613307

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 18 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$170 USD en 35 días
4,8 (35 comentarios)
5,2
5,2
2 freelancers están ofertando un promedio de $287 USD por este trabajo
Avatar del usuario
See private message.
$403,75 USD en 35 días
5,0 (109 comentarios)
6,1
6,1

Sobre este cliente

Bandera de UNITED STATES
United States
4,9
10
Miembro desde sept 9, 2003

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.